Open a Workbook using a Command Button

  • Thread starter Thread starter aussiegirlone
  • Start date Start date
A

aussiegirlone

Is there a code for a command Button to open a Workbook to enter New Data
 
Assign this macro to your button:

Sub dural()
Workbooks.Open Filename:=Application.GetOpenFilename()
End Sub
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Move/Copy Worksheet with Macros 2
Macro to push data to another workbook 0
How can I reduce repetative code 4
Merge Multiple workbook sheets into one workbook 0
Command buttons 2
Command button 1
command buttons disappear when I move worksheet 2007 1

Back
Top