![]() |
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 |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com