Hi,
A macro creates a listing of invoices to batch upload into out Accounts Receivable system.
The output in the excel tab looks like 007/18/0000151,100.26,,,,,, (which is the necessary format)
Macro saves the tab as a .txt file
When I open the .txt in Notepad, the output looks like "007/18/0000151,100.26,,,,,,"
and the "s are recognised in the AR system and prevents the file from being processed.
If I copy the "007/18/0000151,100.26,,,,,," back into Excel the "s disappear.
Any ideas as to why these appear and how to prevent them - work around is to edit / replace " with blank in the txt file but this turns a near automatic process into a more manual one ?
thanks
Steve
A macro creates a listing of invoices to batch upload into out Accounts Receivable system.
The output in the excel tab looks like 007/18/0000151,100.26,,,,,, (which is the necessary format)
Macro saves the tab as a .txt file
When I open the .txt in Notepad, the output looks like "007/18/0000151,100.26,,,,,,"
and the "s are recognised in the AR system and prevents the file from being processed.
If I copy the "007/18/0000151,100.26,,,,,," back into Excel the "s disappear.
Any ideas as to why these appear and how to prevent them - work around is to edit / replace " with blank in the txt file but this turns a near automatic process into a more manual one ?
thanks
Steve