Hello,
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,
Matt
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,
Matt