Currently I am copying ranges to notepad and letting the user choose the path to save to. However, this gets pretty annoying after 10 or 20 times of doing it. Is there a way to save the text file automatically?
Preferably creating a folder on the users desktop and saving the file in there with a variable name. As this is new territory to me I appreciate any help.
Please Login or Register to view this content.
Last edited by 111StepsAhead; 05-21-2012 at 01:19 PM.
Please Login or Register to view this content.
StevenM,
Thank you for that line. I've managed to create a folder on my desktop.
My other question is how do I saveas the notepad file that is "in focus"?Please Login or Register to view this content.
Don't run from the VBE (because of SendKeys).
Please Login or Register to view this content.
Weird. I kept updating this thread all day and never saw your last post StevenM. I appreciate you putting in the time to make that but I am unable to save the file in the new directory I created with the above code. (ie I can't change the directory correctly.)
I guess sendkeys is as unstable as they say. Guess I'll have to find a better way to export the information but if you know what the issue is let me know. Thanks!Please Login or Register to view this content.
Personally, although I was able to get it to work, I wouldn't use SendKeys. I don't know why you would want to use NotePad when you can use Excel VBA to open, read, & write text files without NotePad.
Hello 111StepsAhead,
Here is a macro to copy a Range into a newly opened instance of Notepad. Copy and paste this code into a new standard module.
Please Login or Register to view this content.
Here is an example of using the macro.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith and Steven,
Thank you for your help. I had been using notepad because I originally needed the user to be able to copy the data to another application that can't be easily interfaced with or have the option to save the text file. My plan in this thread was to automatically save the text file in a location and let the user go back and get what they need. My solution came from http://www.cpearson.com/excel/ImpText.aspx. Basically it cuts out notepad, like Steven suggested, and appears to work much quicker than sendkeys.
Hello 111StepsAhead,
Copying data to another application using SendKeys is not ideal and complex. Now you know both ways to do it. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks