| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a Workbook using a Command Button
Is there a code for a command Button to open a Workbook to enter New Data
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open a Workbook using a Command Button
Assign this macro to your button:
Sub dural() Workbooks.Open Filename:=Application.GetOpenFilename() End Sub -- Gary''s Student - gsnu200843 "aussiegirlone" wrote: Is there a code for a command Button to open a Workbook to enter New Data |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open a Workbook using a Command Button
Thankyou Gary, the macro works well to open the folder where the workbooks
are stored, but I still have to click onto the workbook I want to open. so this macro is not exactly the way I want it to be, as it does not open the actual workbook needed. "Gary''s Student" wrote: Assign this macro to your button: Sub dural() Workbooks.Open Filename:=Application.GetOpenFilename() End Sub -- Gary''s Student - gsnu200843 "aussiegirlone" wrote: Is there a code for a command Button to open a Workbook to enter New Data |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click a command Button to open small worksheet. | Excel Discussion (Misc queries) | |||
| Send Open Spreadsheet using Command button | Excel Discussion (Misc queries) | |||
| Open an Outlook folder when a user clicks on a command button ... | Excel Discussion (Misc queries) | |||
| New button does not open the template workbook set up | Excel Discussion (Misc queries) | |||
| Command Button crashing workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
