sfname

sFName = Application.GetSaveAsFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx, Macro Enabled Workbook" & "(*.xlsm), *xlsm") If sFName <> "False" Then ws.SaveAs sFName, 56 End If With sFName set as a string. I am using MS Office 2016 on win10 if that helps, have not tried...

I have the following VBA code : Originally it had inputboxes but as this is standard I edited in such way that it would go to the right location and files automatically. I found this VBA code somewhere online and I use it to import sheets (sheet1) of several workbooks in the same workbook...

This is the macro I'm using with 2 problems so far Sub Move_Master_EstimatingSheet() Dim SDrv As String Dim DDrv As String Dim Sfname As String Dim Dfname As String Dim wkbSrc As Workbook Dim wkbDst As Workbook Application.DisplayAlerts = False Application.EnableEvents = False...