Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Open Dialog Box
I am using the macro below to retreives the path and filename of a file that I select from the File Open dialog box How can I tweak this macro so that the dialog box always opens in the C:\Employee Performance\ directory? Any help would be much appreciatted Sub GetFileName() Dim sFileName As String sFileName = Application.GetOpenFilename If sFileName = "False" Then Exit Sub ThisWorkbook.Activate Range("a1").Value = sFileName End Sub -- Papa Waigo ------------------------------------------------------------------------ Papa Waigo's Profile: http://www.excelforum.com/member.php...o&userid=36074 View this thread: http://www.excelforum.com/showthread...hreadid=560059 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Dialog Box to return Selected File Path and Not Open it. | Excel Programming | |||
File open dialog box | Excel Discussion (Misc queries) | |||
File Browse Function (Open dialog box for choosing file) | Excel Programming | |||
file open dialog | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming |