Test for Windows 7

I have Windows 7 and Excel 2007. This combination allows me to Save As to PDF using the following VBA code,

Please Login or Register  to view this content.

I found that Excel 2007 on XP doesn't allow Save as to PDF so I want to test for the Operating system type.

I use this code,

Please Login or Register  to view this content.

but I think that's wrong. It is certainly giving me the wrong result.

Is there a better way to test?

You can find out the operating system with this:

Please Login or Register  to view this content.

Rhapsodie, welcome to the forum. However, I'm afraid,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Just tried that snippet and I get the 'Can't find project or library compile error'. I used copy/paste of your code.

Please comply with the moderators request i can then continue to help as per the forum rules.

Sorry. I am using this test sub.

Please Login or Register  to view this content.

(I couldn't find any # anywhere so used the Quote icon).

It fails the complile with the above error.

Rhapsodie,

please edit your first post and add code tags before you post anything else.

You can see the # command when you click Go Advanced after clicking the Edit button to edit a post.

When you use the Quick Reply box, you won't see the # command, either. In this case, you can type [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] to add code tags, or click Go Advanced for the single click option.

Thanks.

Use these [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code], you didnt see the # because you used quick reply and the owners of this forum haven't seen fit to comply with requests from its members and staff and add it to the quick reply, you can overcome it by clicking Go Advanced (you need to edit your first post too, then i can help)

Sure
You need to got the VBE (Alt+F11) and then click TOOLS>REFERENCES and make sure that you have:
OLE Automations checked
Visual Basic for Applications checked
Microsoft Excel xx.0 Object Library checked (where xx.0 is your excels version i.e 14.0)
Microsoft Office xx.0 Object Library checked (where xx.0 is your excels version i.e 14.0)

Then run this and you should see all variables:

Please Login or Register  to view this content.

FYI, the save to PDF is not OS specific. In Excel 2007 pre SP2, that function required an add-in that you could download from MS; if you have SP2 installed, it should be a native function.