Open CSV-file

P

psm

When I open my csv-file using File/Open-commands
everything is all right. But if I record the same
operation in macro and run it, the result is different;
wrong. Can somebody help me?
 
B

BorderMan

My guess- the correct options that you put in the wizard are not in the recorded macro. Edit the macro and verify the Workbooks.OpenText Filename options are what you expect

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Need Help with Macro Security 1
How to open multiple instances of Word 365? 5
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Macro to open CSV files 6

Top