Getting data from a spreadsheet without opening?

  • Thread starter Thread starter NateBuckley
  • Start date Start date
N

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!
 
Thanks alot matey, I had forgotten about that .EnableEvents method.

And thank you for making and running that fantastic website.

Take care.
 
Back
Top