Save as Workbook

[JohnsonFelix]

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

 

[welshgasman]

Care to say what the prompt is?

Plus you say you want to save ddmmyyhhmmss in the title but are formatting the date only as yyyymmdd ?

 

[JohnsonFelix]

Hi,

I found the way to do save as, I just want to know is there any VBA code to copy the last saved workbook path entire path (Clipboard)

Regards,
Johnsn

 

[welshgasman]

You could use this method?

https://www.thespreadsheetguru.com/blog/2015/1/13/how-to-use-vba-code-to-copy-text-to-the-clipboard

Then

https://stackoverflow.com/questions...-using-gettext-avoid-error-on-empty-clipboard

perhaps?

HTH