Copy-Pasting values into Notepad, then saving it

Hello,

I have a file from which I get specific values and need to copy-paste into a .txt file. (A certain program I use reads .txt files). I would then like to be able to have code that automatically saves the notepad with the name I desire.

Also, I've found this code to open and copy paste, but I would like to avoid SendKeys (!!)

Please Login or Register  to view this content.

Thank you!

The code below will basically write the lines you have in your "Copied Range" into a text file, without opening Notepad.
if you are satisfied with the answer click " * " add rep icon in the bottom left corner of my post

Please Login or Register  to view this content.

Thank you Raul!

I removed strDirect and changed Myfile to "C:\Users\" & Environ$("Username") & "\Desktop\" & strFileName & ".txt" (found in another post) and everything works ALMOST perfectly: the first 20 or so values in the .txt have a space before the first character. Not-too-coincidentally, I imagine, these are all values which only have number characters (all other values have at least one letter character)

Also, where in your code (which line) does it save? And what is #fnum?


Thanks again!

The space must have been found in the range being written, please check the source range for blank spaces at the begining. This really doesnt save. It opens a file in the background for editing see instruction

Please Login or Register  to view this content.

; Here is an explanation: http://zo-d.com/blog/archives/progra...ect-excel.html
if you are satisfied with the answer click " * " add rep icon in the bottom left corner of my post

Using the initial code I had, the spaces do not appear in the .txt
Also, to confirm, there are no spaces before the value in the cells

Huzzah!

if you are satisfied with the answer click " * " add rep icon in the bottom left corner of my post
Also, Mark the thread as answer for others to reference it.

I get it, you want reputation

Yes, you answered my question, but you brought up another problem that wasn't there initially. I'll give you all the rep you want if you can fix it

OK why dont you just load a file sample and then I can see where the issue is, for the code only goes thru a loop in the "Copied Range" and writes it to the file line by line, if it finds empty spaces, empty columns or anything else that cannot be "printed" it still accounts for it. Without looking at your source data I can only guess, wich is not the best way to get an accurate answer.
Forget about the reputation, if you dont feel like doing it is fine.