Create an Input box so that the user can tell the code to open a workbook

**kawhite03** · 09-26-2012, 04:52 PM

I am in Excel 2007 and I am trying to create a macro where an Input box is used so that the user can identify the path and filename of the workbook to be worked in Excel.

**tigeravatar** · 09-26-2012, 05:20 PM

kawhite03,

Welcome to the forum!
You mean the Application.GetOpenFilename method?
http://msdn.microsoft.com/en-us/libr.../ff834966.aspx

**kawhite03** · 09-26-2012, 05:30 PM

Well, I feel silly! Thank you so much.

**tigeravatar** · 09-26-2012, 05:36 PM

You're very welcome

Create an Input box so that the user can tell the code to open a workbook

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Create an Input box so that the user can tell the code to open a workbook

Re: Create an Input box so that the user can tell the code to open a workbook

Re: Create an Input box so that the user can tell the code to open a workbook

Re: Create an Input box so that the user can tell the code to open a workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions