Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to export a worksheet as a *.txt file but do not want the text quantifiers to appear (ie. the quotations around the text columns). Here is a snippet of my saveas code: ActiveWorkbook.SaveAs Filename:=mylocation , _ FileFormat:=xlText, CreateBackup:=False Do I either have to change the format of the columns before I use the SaveAs or can I mod the SaveAs function (ie. use a different paramter or try different FileFormat's.) Thanks, -Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Outputting rows with a given value to new worksheet | Excel Discussion (Misc queries) | |||
SaveAs call changes text to ##### | Excel Programming | |||
SaveAs Text | Excel Programming | |||
Outputting a formula in a cell using VB | Excel Programming | |||
importing text file, removing data and outputting new text file | Excel Programming |