| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| after opening existing spreadsheet can't input data anymore | Excel Worksheet Functions | |||
| opening a spreadsheet | New Users to Excel | |||
| Opening a spreadsheet | Excel Discussion (Misc queries) | |||
| Opening a spreadsheet using VB | Excel Programming | |||
| Opening a spreadsheet using VB | Excel Programming | |||
Linear Mode
