ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FileFormat Macro Problem (https://www.excelbanter.com/excel-programming/293577-fileformat-macro-problem.html)

Jeffrey[_6_]

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