Copy a worksheet without 'opening' workbook
 

Hello,

I need to copy worksheets off several workbooks. I do not want t
'fully open' the workbooks -- the VBA code takes too long to load.

Is there a way to copy a worksheet without 'fully opening' the file?

Thanks,
Stev

--
Steve
-----------------------------------------------------------------------
SteveS's Profile: http://www.excelforum.com/member.php...fo&userid=1011
View this thread: http://www.excelforum.com/showthread.php?threadid=26819

Copy a worksheet without 'opening' workbook
 

Not that I know of, but you can open the workbook without enabling the
macros, if that's what's taking so long.... just use

Application.EnableEvents = False

'Open the workbook here and do your stuff

Application.EnableEvents = True

--
Regards

Juan Pablo González

"SteveS" wrote in message
...

Hello,

I need to copy worksheets off several workbooks. I do not want to
'fully open' the workbooks -- the VBA code takes too long to load.

Is there a way to copy a worksheet without 'fully opening' the file?

Thanks,
Steve


--
SteveS
------------------------------------------------------------------------
SteveS's Profile:
http://www.excelforum.com/member.php...o&userid=10118
View this thread: http://www.excelforum.com/showthread...hreadid=268196

Copy a worksheet without 'opening' workbook
 

Hi Steve

You can find a example here (read the Tips)
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SteveS" wrote in message ...

Hello,

I need to copy worksheets off several workbooks. I do not want to
'fully open' the workbooks -- the VBA code takes too long to load.

Is there a way to copy a worksheet without 'fully opening' the file?

Thanks,
Steve


--
SteveS
------------------------------------------------------------------------
SteveS's Profile: http://www.excelforum.com/member.php...o&userid=10118
View this thread: http://www.excelforum.com/showthread...hreadid=268196