Getting data from a spreadsheet without opening?
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! |
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! |
Getting data from a spreadsheet without opening?
Thanks alot matey, I had forgotten about that .EnableEvents method.
And thank you for making and running that fantastic website. Take care. "Ron de Bruin" wrote: 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! |
All times are GMT +1. The time now is 09:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com