Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open a workbook
I have this code in a workbook called "MAINWORKBOOK.XLS that opens another
excel file called "Ledger.xls". the code does one thing, add a new worksheet to ledgers.xls. Sub AddLedger() Application.ScreenUpdating = False Workbooks.Open Filename:=ThisWorkbook.Path & "\Ledger.xls" With ActiveWorkbook .Sheets.Add End With ActiveWindow.Visible = False Workbooks("MAINWORKBOOK.XLS").Activate Application.ScreenUpdating = True End Sub AS you can see the code opens the workbook, then hides it. is there any way other than this to have it open the workbook already hidden so you do not see a little blip on the windows bar at the bottom of the screen? thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming |