Select item from access

[mattress58]

How can I change this line to look at a cell value for the search criteria in access

Please Login or Register  to view this content.

I want to take out 40787 and have it in range("G5") and change 40787 in the above code to look at the cell instead. Mabe something like whats below, but its currently not working

Please Login or Register  to view this content.

[alansidman]

See if this blog helps

http://datapigtechnologies.com/blog/...ry-from-excel/

[mattress58]

I tried looking and using but I am not have luck. It seems so simple, I have been trying different things for 2 hours now.

[alansidman]

Using your current code, add a line before

Please Login or Register  to view this content.

Now substitute the hard code with rng

[mattress58]

I am getting compile error: Object required and the rng is selected when I try that. Here is what I did:

Please Login or Register  to view this content.

[alansidman]

My bad. Remove the word Set from the line of code.