Dear guys,
I have been trying to create a macro for a while that can save and send as XPS but without any luck. I'm using relative references and this is the results:
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypeXPS, Filename:= _
"C:\Users\itshewe\To do.xps", Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
Application.Dialogs(xlDialogSendMail).Show
However, when running the macro the file format becomes .xlsx
I would highly appreciate any help.
Kind regards,
itshewe
I have been trying to create a macro for a while that can save and send as XPS but without any luck. I'm using relative references and this is the results:
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypeXPS, Filename:= _
"C:\Users\itshewe\To do.xps", Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _
False
Application.Dialogs(xlDialogSendMail).Show
However, when running the macro the file format becomes .xlsx
I would highly appreciate any help.
Kind regards,
itshewe