Txt format problem - quotes missing

[mcclanat]

Hello all,

I'm trying to write a macro that opens a text file, copies it, then pastes the values into the original workbook. I got it working, but when the it pastes the text, excel stripes out double quotes. I tried using Format:="Unicode Text", but got errors. I also tried pasting values only, but that didn't work either. The code I'm using is below and the spreadsheet I'm using to test this are attached. Any help would be appreciated.

Thanks!

Please Login or Register  to view this content.

[MaczaQ]

attach example of source text file too

Best Regards

[mcclanat]

The text file I was using to test the macro is attached below with a .txt extension because .inp extentions are not approved as attachments for this website. An inp file is an input file for energy simulation software. It is just a text file that is saved with a .inp extension so the software will read it. You can open the attached example file and save it with a .inp on the end. I tested the macro above with both .inp and .txt extensions, and it striped the double quotes out in both cases.

If I manaully copy and paste the information, then select text import wizard, delimited, text qualifier = none, the code pastes correctly. However, I haven't been able to duplicate this with VBA code. I tried recording a macro and it used Format:="Unicode Text", but I got errors when I tried that.

[TMS]

Try:

Please Login or Register  to view this content.

Regards

[mcclanat]

That worked. Thank you!

[TMS]

You're welcome. Thanks for the rep.