Object variable or with block variable not set

Hello, i made a code to read data from specific sheets of multiple workbooks. The error i get is the "object variable or with block variable not set". I made a some changes in the code but it did not worked. So here is the code:

Please Login or Register  to view this content.

I get the error in the 9th line where i state "wb1 =". I changed the variables into public instead of dim and nothing happened. I also changed the subs and made them public subs, nothing happened. I also stated the workbook parameters as <Set wb1 = New Workbook> also nothing happened :|
Any suggestions?

You will need to set the values of the workbook e.g.

Please Login or Register  to view this content.

Because you have activated the workbooks all you need to do is use the SET command and they will all be = ActiveWorkbook
You do not need to Activate the workbook as they will be the active workbook so you can remove all the Windows("excelxx.xx").activate from your code

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

Or you could replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

etc ...


The problem is that you have defined wb1 as a range and "excel1.xls" is a text string.



Regards, TMS