View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kurt Kurt is offline
external usenet poster
 
Posts: 47
Default How do I access a sheet in another workbook using VBA?

Greetings everyone!

How do I access a sheet in another workbook?

Currently, I do the cheesie method of referencing it from within the cell,
but I always have to over copy the rows since I don't know when I've reached
the last non-empty row.

I want to be able to write some VBA code that will loop thru the sheet in
one workbook and write the info into a sheet in another work.

Thanks as Always!

Kurt