Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create copy of sheet tab (excel 2007) when opening workbook | Excel Worksheet Functions | |||
Shared workbook - opening to the correct worksheet | Excel Discussion (Misc queries) | |||
Prevent worksheet from opening in a workbook | Excel Worksheet Functions | |||
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but | New Users to Excel | |||
How do I set defaut worksheet visible on opening workbook? | Excel Discussion (Misc queries) |