Thread: Getting data from a spreadsheet without opening?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Getting data from a spreadsheet without opening?
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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"NateBuckley" wrote in message ...
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!
Reply With QuoteReply With Quote