VBA doesn't work on CSV file, but works on XLS?

Hi - i have this file which i download everyday in a CSV format. I have written a macro to arrange the data, which requires querying some data from access. However, this doesnt seem to work on the CSV file when i run it.

I get an error "User-defined type not defined", whenever i try to run this on the csv file. I have the macro stored in personal.xlsb as we

However, this is resolved when i manually copy and paste the data from the CSV file into the workbook where the macro is initially created - a xlsm file.

Is there any way to automate and run this macro in my CSV file?

Please Login or Register  to view this content.

Originally Posted by xlnitwit

Hi,

If the macro is in your personal macro workbook, you need to set a reference to the Microsoft ActiveX Data Objects library in that workbook.

How do I do that? I am new