Cannot Save CSV file as xlsm

[mitchvail]

I have converted data I receive in PDF format to a csv file and what I want to do is save it as an .xlsm file so I can use macros etc. When I do it manually it works perfectly but not using VBA. Hoping someone could tell me what is wrong with my code.

Please Login or Register  to view this content.

I recorded a macro and that worked and I compared the string developed above with the recording and they to me are identical.

[Marc L]

Try to add the file format parameter in the SaveAs method …

[mitchvail]

Thank you very much I thought I had tried that.