Hello everyone
I need a macro that enables me to specify sheet and range to be exported to text file ..
for eample : Sheets("Data").Range("A5:B10")
of course clear all the data or kill the text file before exporting (The text file to be in the same path)
Also I need another macro that enables me to import the data exported and at this point to have inputbox that enables me to specify that range or the cell to which the imported data will be put
I hope it is clear
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Hi,
To select range from differet sheet (not the activesheet), when the inputbox show up, click the target sheet tab first, and then select the range, or you can directly type the full path range to the input box.
Please Login or Register to view this content.
Regards
Thank you very much Mr. Karedog for this wonderful code
It works like charm ..
I need to make the output file name embedded in the code as I was obliged to type the file name followed by the extension
You are welcome.
If you have predefined output filename, then change this line :
to something like :Please Login or Register to view this content.
Please Login or Register to view this content.
Regards
Sorry Mr. Karedog for not reading the code before posting post 3
i had to do it myself .. but I prefer with you to just be learner .. You're professional and your lines of code are wonderful .. i really like all your solutions
It's alright. Maybe because we have the same interest, that is, to avoid as much as possible using the GUI Excel objects, and prefer using non GUI solutions (array, collection/dictionary, etc) instead.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks