Printing to PDF Macro - Problems with office 2007 incompatibilities? What can I do?

**EDITED I need this to work with Office 2003, not 2007**

Hi there,

First time post so hopefully I don't ignore any formatting rules that I missed.

So I have a fairly basic Print to PDF macro, I wrote this on my personal laptop that I use at work which currently has Office 2016 installed. Here is the code I am using, on Office 2016 it works perfectly.

Please Login or Register  to view this content.

The problem I have is that I work in the field, and I use a computer in my van here that doesn't have an internet connection. I tried tethering my phone to it to run updates but the cellular service out here isn't good enough for it to work.

This PC uses Office 2003 and Windows 7, it hasn't seen an update since 2012 according to windows update.

When I attempt to use the Print to PDF macro on this PC it returns a Run Time Error "438" Object doesn't support this property or method.

Through some googling I have found that there was a PDF Add-In released for Office 2007, I installed that and it didn't help.

I tried to install the Service Pack 3 update for Office 2003 that I found online but it errors on install saying its for a different operating system, I am assuming this is due to the PC being out of date with its updates.

Is there any way I can rewrite this for 2003 that would make it function? Or is the export to PDF function just simply not existing due to out of date software and I am more or less up shits creek, for lack of a better term?

Everything I have found online was essentially using the same formatting I am, so I am at a loss.

Thanks in advance for any help.

Ok so I get 2 very different versions here.

Please Login or Register  to view this content.

The caveat here is I want it to get the PDF name from a cell (Range O11) and to place the PDF in a folder that it will create if it doesn't exist on the desktop, hence all the other code surrounding the ExportAsFixedFormat code in the original macro.