Copy from closed workbook to open workbook

[z0rT10ok]

Hi,

I got Excel 2007 and I need to copy data from a closed workbook A to an open workbook B, for the sake of argument lets say rows 10 to 20 using VBA.

Is this possible?

 

[hiker95]

z0rT10ok,

Welcome to the MrExcel forum.

See if this gets you started in the right direction:
http://www.mrexcel.com/forum/showthread.php?t=510342

Extracting data without opening file--please help!!
http://www.mrexcel.com/forum/showthr...25#post2066825

copy data from closed workbooks
http://www.mrexcel.com/forum/showthread.php?t=412589

Get Data from closed workbooks with formulae
http://www.excelforum.com/excel-work...ple-files.html

 

[z0rT10ok]

Thanks Hiker,

However all these posts are formula related I think, what I was really after was kinda the following:

resultString = workbooks("SomeWorkBook").worksheets("Sheet1").cells(1,"A").value

Unfortunately when I try this I get the following error - Runtime error 9: Subscript out of range.

Anyone got any ideas ?

 

[Smitty]

Welcome to the Board!

Check out Ole Erlandsen's ADO/DAO Pages.

HTH

 

[z0rT10ok]

Bingo, works perfectly

Thanks a lot