In Excel, the following VBA code does not work properly.
dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls")
It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...
Hello,
I'm trying to build a dialog box where will ask me to load a .data file extension file which later on i will edit few things and save as .xlsx.
Problem is that whenever the file is selected and supposed to be loaded, there is no outcome... it simply ends macro as if nothing happened...
I am compiling a register of projects and have been using VBA to Loop through 25-40 files in a batch.
As the list gets longer I have been manually changing this in the macro text.
1) Does anyone know if i can use a dialog box to set the Lrow, to add to bottom of list? (So I can't forget to...
hi.
On the worksheet named 'timesheet' I want to put a msgbox to state "input date In Cell A2" and a input box to appear & place the applicable in a2. Then move to the worksheet called 'Sheet1' . Again I need a msg box to say"Attach File" and move the cursor H2 and upon enter run the...
hi,
I the following code:-
Sub GetFilePath()
Dim dialogBox As FileDialog
Set dialogBox = Application.FileDialog(msoFileDialogOpen)
'Set the display properties - these are optional
'All the settings must be applied before the .Show command
'Do not allow multiple files to be selected...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.