View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave_d dave_d is offline
external usenet poster
 
Posts: 3
Default 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.