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