ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA "Save As Text" Routine? (https://www.excelbanter.com/excel-programming/275385-vba-save-text-routine.html)

dave_d

VBA "Save As Text" Routine?
 
I've tried several things but I've just about given up. I
write some cells to a blank worksheet page that I try to
save as a tab-delimited text file so that I can import
the data to another application.

Is there a macro out there that calls Excel's "Save As"
dialogue box or saves a tab-delimited text file ? I'm
trying to rig it so that the default name that the .txt
extension is taken from a cell, say "A1".

Any help would be greatly appreciated.


All times are GMT +1. The time now is 04:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com