FileFormat Macro Problem
I am having a problem with and Excel Macro I wrote. I need a bunch of cells entered, then a text string created to upload to another system. The problem is I keep getting a " at the beginning and end of each line I create. I am using Excel XP. Any ideas what I am doing wrong? Here is the part of the macro I am having problems wit
Application.Goto Reference:="OUTPUT
Selection.Cop
Workbooks.Ad
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:=False, Transpose:=Fals
Application.CutCopyMode = Fals
ActiveWorkbook.SaveAs Filename:="c:\ps\enc.txt", FileFormat:=xlText,
CreateBackup:=Fals
ActiveWindow.Close
|