Good day everybody,
I had a working code from a similar file I copied, but is not working anymore (for some odd reason).
Situation:
I want to automatically save the file in a specific folder with the name DASHMA-GAP + the content from a specific cell in that workbook.
The content of that cell is a date =(not the date of today, just random. Code I use is the next one;
Dim strFilenName1 As String
Dim FName As String
FName = Sheets("INFO").Range("D28").Text
strFilenName1 = "X:\Management-Operations-Supply Chain\Supply Chain Management\SC Proces & Projectmgmt\AUTOMATIC ORDERING\2. DASHBOARDS AND ANALYSE\2.5 DASHBOARD AUTOMATIC\02 GAP\01 MAKRO\02 DASHBOARD RESULTS\DASHMA-GAP " & FName & ".xlsx"
ActiveWorkbook.SaveAs Filename:=strFilenName1, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
If I run this, I get no error and he saves the file WITHOUT the content of cell D28 at the tab INFO.
Could it be the reason that the file is hidden?
Thanks alot!
Another working code to replace this one is fine as well!
Bookmarks