Error 91 object variable block variable not set when importing a CVS file

**ReportBuilder2011** · 05-13-2011, 10:30 AM

Hi there.

I have a Macro to import a CVs file into a specific spreadsheet. It works but I keep trapping an error 91 object variable block variable not set. I know I have to issue a Set command but dont know exactly what object I am setting. Any help clarifying this would be appreciated.

I also notice that whenever i run the macro. the QueryTablecount increments.

Please Login or Register  to view this content.

**111StepsAhead** · 05-13-2011, 10:36 AM

Add code tags around your code please.

**ReportBuilder2011** · 05-13-2011, 10:44 AM

Can i ask what are code tags

**111StepsAhead** · 05-13-2011, 11:33 AM

Before your code type brackets. [ ]
In between the first brackets type the word code.

After the code end with brackets and the word /code.

Also if you go advanced there is a button that automatically makes the tags for you so you can paste the code in between them. This will help members read your code easier.