By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Open Excel File and Converting to Text File and Close

P: 34

I have a dynamic named range that changes upon dropdown selection. The name of this range is "OutputFile".

When the macro clicks on it, you will be brought to a specific folder in Windows Explorer (NT) where and Output file exists. I would like to take this output file and convert into a text file (.txt).

I've tried many other ways and it places the data into an Excel / CSV file, however we are still at Excel 2000 and data may surpass 65,000 rows.

Any help would be appreciated.

Thank you,

May 12 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.