issue reading from another workbook.

[kieranbop]

I'm trying to read information from another workbook, workbook a has a userform i click a button and the ideal scenario i want is it to read from workbook b.

I started by implementing reading from current sheet 2

Please Login or Register  to view this content.

and this worked fine but it was on the same workbook, so now I tried to implement reading from another workbook but I'm having no luck. I tried to get it to open another book with screenupdating off and read that contents with same kind of functions but I keep on being prompted with the vb error I put in place.

Please Login or Register  to view this content.

anyone know where I'm going wrong to get it to read from a closed workbook, bare in mind first code works from current sheet and second is an attempt to read from the sheet I'm after. The information on the new sheet in sheet1 not sheet 2 like the current document btw

Any help appreciated

K

[Domski]

Please Login or Register  to view this content.

ThisWorkbook will always refer to the workbook that contains the code.

I think you would need:

Please Login or Register  to view this content.

Dom

[Domski]

Re-written a little:

Please Login or Register  to view this content.

Dom

[kieranbop]

thanks for that dom, works perfectly how I need it now.