Ive trying to figure this out for days, I created a macro and want the macro to save my file with the info in a cell.
ActiveWorkbook.SaveAs Filename:= _
"\\asshare\home$\user\Desktop\Hmda\c6.xlsx", FileFormat:=xlOpenXMLWorkbook _
, CreateBackup:=False
I would like to save a file with the value in c6 in the network path above. I found vba code to save as a cell, but dont know how make it work with the above code. Can anybody help me?
ActiveWorkbook.SaveAs Filename:= _
"\\asshare\home$\user\Desktop\Hmda\c6.xlsx", FileFormat:=xlOpenXMLWorkbook _
, CreateBackup:=False
I would like to save a file with the value in c6 in the network path above. I found vba code to save as a cell, but dont know how make it work with the above code. Can anybody help me?