I have recorded a Macro in MS-Excel, where in the macro has to pick up files from a shared drive, one of the file will be saved with same name on daily basis, where as the other one will be saved with filename+current date.
Currently I have a calendar setup and am able to get a selected date to a particular cell.Say I have date in Cell "B13", how can i connect that to a filename in the Macro. All I have to change is "0325" part of the filename.
I have to connect three different Dates to three different files in the Macro, is it possible to have three different dates in three different Cells say "B13","B16", "B20" to be connected to three different filenames with three different paths?
Scenario Example : As soon as I have 0328 in Cell "B13" then the Macro should pick up file named "Filename0328" to perform necessary functionality.
I wish to change the dates where ever they are in the Macro.txt file attached.
Any help with written code examples would be of great help. Thanks in Advance.
ActiveWorkbook.SaveAs Filename:= _
"\\Andshare06\data06$\ACCOUNT06\ASDSHARE06\GPS TA Group\ARAP" & ActiveSheet.Range("B13") & ".Macro.xls"
The first file is not an .xls sheet, would it still work ?
Although it is pulling the Dates, it is giving errors on "Origin:= " and "Startrow:="
The date it is pulling is not in the format I have formtted the Cell to be. I formatted the cell to be in mmdd format, where as the file extension is coming up as mm/dd/yyyy .
