Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro problem | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
VBA Using FileFormat:=xlText | Excel Discussion (Misc queries) | |||
SaveAs Filename and FileFormat in Vs2007 | Excel Discussion (Misc queries) |