Macro not working on Windows Server 2016

[thviid]

Hi,

I have an excel sheet with macros working perfect on my local Windows 10 PC. Now I want to move the sheet to a Cloud computer running Windows Server 2016.

When running the macro on the cloud server i get an 1004 error.

Debug routes me to the attached section.

Anybody who has an idea how to fix?

Troels

 

[RoryA]

Do you have a default printer set up on the server? I seem to recall that ExportAsFixedFormat requires that for some reason.

 

[thviid]

Do you have a default printer set up on the server? I seem to recall that ExportAsFixedFormat requires that for some reason.

Thanks a lot RoryA

That worked like a charm.

Troels

 

[RoryA]

Glad to help.