Export to PDF error

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)

Apologies, still learning the way with this forum. I have fixed the post

I think you create it twice so after it's created it does it again.

Here, try this:

Please Login or Register  to view this content.

That seem's to still return the same error message. I think I should provide some more context.

I am trying to print a workout program for multiple athletes.

Capture1.JPG

When I click on the save as pdf Macro button it brings up the following user form.

Capture2.JPG

From here I can/want to be able to select which athletes programmes get saved as a pdf. I have this function working if I want to print. so I tried to apply the same code for save as pdf. The full code I am using is below.

Please Login or Register  to view this content.

If further explanation is required please let me know

cheers

Wheeler

It will always save it with same name. Why don't you put variant name so it won't be duplicated?

I hadn't done that because I don't know how to do that to be honest.

Something like this (didn't test it):

Please Login or Register  to view this content.

Same error is still appearing (Run time 1004) but previously i could actually see the pdf start to publish then fail. Now nothing.

This is the debug I get

Capture55.JPG

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

The file is too big. It's 1.3 mb

remove all irrelevant informations. Delete extra rows... Keep just what's important for example.
You can also zip it.

please find the file attached. Note the macro i am trying to get to work is the save as pdf but on the tab named workout card

It's protected.

Originally Posted by zbor

It's protected.

Password is warrior

As I thought, once you create file for first user it opens it and then you can't create file with same name.
But this works for me:

Please Login or Register  to view this content.

It fails only at the part where you have some strange names in the list as: ****AASE****