VBA macro 2007 vs 2010 compatibility

Hi there,

I have a spreadsheet with very useful VBA macros but after reinstalling my computer and upgrading to MS Excel 2010 all VBA macros does not work :-( Any clue? You can find some example of one of non-functioning macro below:

Please Login or Register  to view this content.

What "does not work" means:
In Excel 2007 this macro creates a PDF file saved in specific hard drive location form one selected list of spreadsheet. The file is automaticly named by a specific string of cells and letters.
In Excel 2010 this macro produce and error message: "Run-time error '1004' The file wasn't saved. Possible reasons: The document is already opened or some errors during saving occured." (sorry for inaccuracy in translation from my native language) Note: The document is not already opened because is not even created.
Any clue, experience?
Thank you for your help in advance.

Michal

After you edit your post to add CODE tags as described below, please explain what "does not work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results?
• Does it hang?

---

Please take the time to review our rules. There aren't many, and they are all important.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thank you for your comment. Hope your requirements are fullfilled now by editing my original post.