This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
I have a Excel workbook with vba macros, it was developed using windows 10. I am in the process of transferring to windows 11 on a new laptop. Some of my macros fail in win 11. An example is ExportAsFixedFormat in this case to PDF. The macros still work on my old laptop. The data is in the cloud (onedrive) so it's not the data. I subscribe to 365 so all my software and OSs are up to date. Has anyone had a similar experience.
The problem code snippet is:
RngRsltSht.ExportAsFixedFormat Type:=xlTypePDF, Filename:=lcPDFName, _ Quality:=xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=False
That should just work. Have you tested if the variables contain exactly the same values on either system?
Yes those. Just double check if those are the same.
Thank you Jan. Do you mean the variables Type, Filename etc? If so I can't see how they can be different. There is only one macro being used as the workbook is on OneDrive, I am not using local files so both laptops are running the same macros. if otherwise please advise.
Thank you Jan. Do you mean the variables Type, Filename etc? If so I can't see how they can be different. There is only one macro being used as the workbook is on OneDrive, I am not using local files so both laptops are running the same macros. if otherwise please advise.
Thank you Jan. Do you mean the variables Type, Filename etc? If so I can't see how they can be different. There is only one macro being used as the workbook is on OneDrive, I am not using local files so both laptops are running the same macros. if otherwise please advise.