Run-time error 7: out of memory

[gandrea]

Hi

Any ideas on why I am getting "Run-time error 7: out of memory" in the code below?

The code runs until the

Please Login or Register  to view this content.

line at the end of my external data import section.

Thanks

Please Login or Register  to view this content.

[thinkspac]

All the previous lines inside the With statement are setting properties.
the

Please Login or Register  to view this content.

is a method call.

The refresh is supposed to refresh the results.
The background Query is for when quering SQL data and is optional so I think you can leave it off and just have

Please Login or Register  to view this content.

?

[gandrea]

thinkspac,

I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but it did not help...

[thinkspac]

Can you provide the workbook?

[gandrea]

I'm embarrassed! i just realized that the txt file that I was trying to import was blank. I put data into the txt file and the macro ran.

Thanks anyway

[jeffreybrown]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save