| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying to another Workbook
I want to copy data from one workbook (many sheets) to another workbook.
I want to do this behind the scenes. Don't want to have the end-user to see this happening. I know in FoxPro, using automation, I can visible to False. Is this possible through VBA? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying to another Workbook
The following (untested) will copy all the sheets in the active wortkbook to
a new one. Application.ScreenUpdating = False ActiveWorkbook.Worksheets.Copy ActiveWorkbook.SaveAs "c:\..............\NewName.xls" ActiveWorkbook.Close False Application.ScreenUpdating = True To copy to an existing workbook, modify to suit. -- Vasant "Dthmtlgod" wrote in message ... I want to copy data from one workbook (many sheets) to another workbook. I want to do this behind the scenes. Don't want to have the end-user to see this happening. I know in FoxPro, using automation, I can visible to False. Is this possible through VBA? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying to another Workbook
Thanks
Application.ScreenUpdating = False This is the command to keep everything hidden? Doug "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... The following (untested) will copy all the sheets in the active wortkbook to a new one. Application.ScreenUpdating = False ActiveWorkbook.Worksheets.Copy ActiveWorkbook.SaveAs "c:\..............\NewName.xls" ActiveWorkbook.Close False Application.ScreenUpdating = True To copy to an existing workbook, modify to suit. -- Vasant "Dthmtlgod" wrote in message ... I want to copy data from one workbook (many sheets) to another workbook. I want to do this behind the scenes. Don't want to have the end-user to see this happening. I know in FoxPro, using automation, I can visible to False. Is this possible through VBA? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying to another Workbook
For the most part, yes.
-- Vasant "Dthmtlgod" wrote in message ... Thanks Application.ScreenUpdating = False This is the command to keep everything hidden? Doug "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... The following (untested) will copy all the sheets in the active wortkbook to a new one. Application.ScreenUpdating = False ActiveWorkbook.Worksheets.Copy ActiveWorkbook.SaveAs "c:\..............\NewName.xls" ActiveWorkbook.Close False Application.ScreenUpdating = True To copy to an existing workbook, modify to suit. -- Vasant "Dthmtlgod" wrote in message ... I want to copy data from one workbook (many sheets) to another workbook. I want to do this behind the scenes. Don't want to have the end-user to see this happening. I know in FoxPro, using automation, I can visible to False. Is this possible through VBA? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copying to another Workbook
Cool. Thanks.
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... For the most part, yes. -- Vasant "Dthmtlgod" wrote in message ... Thanks Application.ScreenUpdating = False This is the command to keep everything hidden? Doug "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... The following (untested) will copy all the sheets in the active wortkbook to a new one. Application.ScreenUpdating = False ActiveWorkbook.Worksheets.Copy ActiveWorkbook.SaveAs "c:\..............\NewName.xls" ActiveWorkbook.Close False Application.ScreenUpdating = True To copy to an existing workbook, modify to suit. -- Vasant "Dthmtlgod" wrote in message ... I want to copy data from one workbook (many sheets) to another workbook. I want to do this behind the scenes. Don't want to have the end-user to see this happening. I know in FoxPro, using automation, I can visible to False. Is this possible through VBA? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying workbook formating to a differnent workbook | Excel Worksheet Functions | |||
| Copying Formulas from Workbook to Workbook | Excel Discussion (Misc queries) | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| Copying charts from workbook to workbook | Charts and Charting in Excel | |||
| Copying workbook contents to another workbook | Excel Programming | |||
Linear Mode
