- Joined
- Dec 16, 2009
- Messages
- 3
- Reaction score
- 0
We're working on writing a script in Excel using variables from the spreadsheet that ultimately gets saved as a notepad file to be used with another macro program (AutoHotKeys). The problem i'm having is that anytime a line includes a comma, the string is included in quotation marks when it hits notepad.
Range("A121").Value = "click 588, 386"
...
the file then gets saved as directly to the new format:
ActiveWorkbook.SaveAs Filename:="F:\AutoHotkey\LoadTest.ahk", _
FileFormat:=xlCurrentPlatformText, CreateBackup:=False
And the line appears with quotation marks. I need it to read just: click 588, 386.
Any suggestions?
Range("A121").Value = "click 588, 386"
...
the file then gets saved as directly to the new format:
ActiveWorkbook.SaveAs Filename:="F:\AutoHotkey\LoadTest.ahk", _
FileFormat:=xlCurrentPlatformText, CreateBackup:=False
And the line appears with quotation marks. I need it to read just: click 588, 386.
Any suggestions?