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!