JohnsonFelix
New Member
- Joined
- Jul 22, 2011
- Messages
- 15
Hi,
I have macro excel Sheet and I would like to save as xlsx format with application.username along with ddmmyyhhmmss in a specific folder without closing excel macrowork excel sheet..
Please advise if we can copy clipboard on last saved xlsx worksheet.
ActiveWorkbook.SaveAs filename:= _
"K:\Confidential\Chennai\Snapshots\Johnson\DAKOP" & Environ("Username") & Format(Date, "yyyymmdd") & ".xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Above coding is askin for prompt.
Regards,
Johnson
I have macro excel Sheet and I would like to save as xlsx format with application.username along with ddmmyyhhmmss in a specific folder without closing excel macrowork excel sheet..
Please advise if we can copy clipboard on last saved xlsx worksheet.
ActiveWorkbook.SaveAs filename:= _
"K:\Confidential\Chennai\Snapshots\Johnson\DAKOP" & Environ("Username") & Format(Date, "yyyymmdd") & ".xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Above coding is askin for prompt.
Regards,
Johnson
Last edited: