Is there a code for a command Button to open a Workbook to enter New Data
A aussiegirlone Apr 6, 2009 #1 Is there a code for a command Button to open a Workbook to enter New Data
G Gary''s Student Apr 6, 2009 #2 Assign this macro to your button: Sub dural() Workbooks.Open Filename:=Application.GetOpenFilename() End Sub
Assign this macro to your button: Sub dural() Workbooks.Open Filename:=Application.GetOpenFilename() End Sub
A aussiegirlone Apr 7, 2009 #3 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.
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.
