| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Workbook
Below is the macro I am using that I have assigned to a
button that is located on a menu in Excel. I have this macro saved in Personal.Xls. I would like to add the code to it to check to see if Workbook Stats Manager.xls is open, and if it is not open, to open it from P:\Stats Manager.xls. After the workbook is open it needs to run the following code. Worksheets(1).Range("C5").Select ActiveSheet.Paste MsgBox "Data Pasted!", vbOKOnly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| Preventing opening workbook inside active workbook. | Excel Programming | |||
| Question for Experts: Opening workbook with workbook references | Excel Programming | |||
![Todd Huttenstine[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
