Hy guys,
I have some files in a loop.
My macro opening them one by one make some modification than save.
Right now the save as function works like this:
I would like to select the folder to save the files with the Save As dialog box.
I tried this, but the dialog box appears with every new file:
Is it possible to make a macro where the dialog box appers only once?
Thank You!
I have some files in a loop.
My macro opening them one by one make some modification than save.
Right now the save as function works like this:
Code:
.....
Path = "C:\test\" FileName = 1 & ".xlsx"
ActiveWorkbook.SaveAs Path & FileName, xlOpenXMLWorkbook
.....
I would like to select the folder to save the files with the Save As dialog box.
I tried this, but the dialog box appears with every new file:
Code:
Dim SvName as String
SvName = "1"
Application.Dialogs(xlDialogSaveAs).Show SvName
Thank You!