running powerQuery from MS Access

hey guys,

I have code in MS Access that opens an XL object and runs vba code that was recorded with the macro recorder by way of a test simulation in excel. the night is a bit long and I'm missing something very simple. Here is the part of my code that is erroring out:

Please Login or Register  to view this content.

the code is throwing error Method Range of Object_Global Failed at this line:

Please Login or Register  to view this content.

can you guys help me spot the error? I know it's very simple. There IS a table named Table 0 (2) so I think the issue is with the code Range($A$1). Sometimes I think a bit too much. thanks.

no big deal. it's almost done anyway. thanks for trying.

Erwin,

I did a workaround that is not 100% automated. I will look at it again later. thanks for the help man!

Adam

This code tries to execute Range in Access, not in Excel.
It should've been something like

Please Login or Register  to view this content.