Getting data from a spreadsheet without opening?

[NateBuckley]

Hello I need to grab a bunch of data from various spreadsheets and collate
them into one spreadsheet. Unfortunetly some of these spreadsheets do things
on load so Openining them up and getting the data from them will screw things
up.

Is it possible to get information from spreadsheets without opening them up
and enabling macros.

Thanks in advance!

 

[Ron de Bruin]

Hi Nate

You can use ADO
http://www.rondebruin.nl/ado.htm

Or disable event code like I do here
http://www.rondebruin.nl/copy3.htm

 

[NateBuckley]

Thanks alot matey, I had forgotten about that .EnableEvents method.

And thank you for making and running that fantastic website.

Take care.