Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello:
I have the following code to get a file name: Sub GetFileName() With Application.FileDialog(msoFileDialogFolderPicker) .InitialFileName = Application.DefaultFilePath & "\" .Title = "Please select a location for the PDF orders" .Show If .SelectedItems.Count = 0 Then MsgBox "Canceled" Else myfilename = .SelectedItems(1) End If End With End Sub I want use MyFileName in another module, but the filename does not save the selected file? how can I make MyfileName "remember" and save the file the user selected? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open File, pause macro until file is selected | Excel Programming | |||
have put a passowrd onto an excel file and now cannot remember it | Excel Discussion (Misc queries) | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming | |||
Prompt user to select file with default file selected dialog | Excel Programming |