I have a that gets sent to a Main Frame system which requires the file name to have single quotes on each end of the file.
This is a text file you can view in Notepad, and I'm trying to write a program that opens the file and verifies the date in the header record before it gets sent to the Main Frame to ensure the operator is sending the correct file.
I'm unable to open the file because the command doesn't work:
sFilePath = "c:\'PSDH.XM.M2.P900.CGS.DXMEXT00'"
Open sFilePath For Output As lFileNum
The sFilePath ends up looking like this in debug: "c:\'PSDH.XM.M2.P900.CGS.DXMEXT00"'
Any ideas on how I can read this file in to verify the header record???