Vlookup to external workbook giving runtime or syntax error.

Hello

I am brand new to VBA and am trying to automate some reports I make. I use many vlookups but have run into difficulty with a vlookup on an external book.

I have opened the external book and I have tested it using my normal vlookup in the worksheet, and works no problem

here is the code i am using, and excuse the crudeness as I am still new to VBA and scripting in general

Please Login or Register  to view this content.

I have tried so many different things, but will get various runtime errors and or syntax errors.

Any advice on the vlookup is greatly appreciated.

thanks

Damn Groundhog

Welcome to the forum!

Is the error on the comment.Value line? It was earlier assigned a string value. Since it is not an object, it will have no Value property.

Precisely

on the comments.value line i am getting a runtime 1004 error, Unable to get the vlookup property of the worksheet function class.

I don't know if i have a wrong variable declared or have written the vlookup function incorrect

Try replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

bakerman2

thank you that seemed to have worked for me. I am now trying to figure out exactly why it worked and why I need to use Range for this.

Appreciate all the help

Damn GroundHog

Uh oh

So, I did some testing out, and moved the other workbook data locally and that is how it worked.

However

when i tried to use the external source, i was returned with a #value instead of the data.

Thanks

I have tried this and now I am getting a

Runtime error 1004

There is an error in the formula you entered.

I will search this function out more and see where it has gone wrong.

Groundhog

Ok.

After my bout of stupidity, it does indeed work.

I can't begin to thank you for this.