I'm attempting to write a macro that goes to a workbook
that's not open, copy data from it, and paste it into the
workbook that is open. Is this possible? If so, how do
I "get" to the workbook that's closed to copy data from it?

Any help would be appreciated.

Thanks,

Kevin G

p.s. - has anyone noticed any of their posts not
displaying? I posted one yesterday that never showed up???

Hi Kevin

See this Webpage from John Walkenbach
http://j-walk.com/ss/excel/tips/tip82.htm

But opening the workbook is in most cases faster with
ScreenUpdating to false

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Kevin G" wrote in message ...
I'm attempting to write a macro that goes to a workbook
that's not open, copy data from it, and paste it into the
workbook that is open. Is this possible? If so, how do
I "get" to the workbook that's closed to copy data from it?

Any help would be appreciated.

Thanks,

Kevin G

p.s. - has anyone noticed any of their posts not
displaying? I posted one yesterday that never showed up???