dialogbox

Hi, I have a VBA code that loops through different files, making changes in them and then saving the files. When saving some of the larger files, I have a problem that the Saving dialog box will not close. I save the following way: Application.DisplayAlerts = False...

Good day everyone, I’m looking for some assistance building a macro that would trigger a Dialog Box when TODAY’s date is 90 days shy (before) of the expiry date, then 45, and finally the day of. Also, I would like to highlight the row of that date with a specific color depending how close it is...

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...