Help with VBA

[inspectorNDT]

I am really new to VBA's. I am trying to make a "create PDF" button to make a PDF out of the active tab. The file name would be using cells on the active tab then the name of the tab and then another cell.

I would also like it to prompt the user if a file of the same name exist and I would like it to auto save to the active users desktop.

thank you in advance for your help

 

[Logit]

.
What line in the macro code is highlighted yellow when you receive the run time error ?

 

[inspectorNDT]

none

 

[Michael M]

Private Sub CommandButton1_Click()

IS the code attached to a CommandButton ???
If so, yes !...but the code you posted originally didn't show that.

The revised code that both @Logit and I posted added a Backslash after Desktop !!
As mentioned earlier, did you make sure that the cells refering to the filename are correct and DO NOT contain any illegal characters.

I might add that the code works fine for me !!

 

[inspectorNDT]

just above the code entry space. Does the drop down need to be (general), Comandbutton1 or worksheet? Also do i nee to select anything on the left side?

 

[Michael M]

If you Rclick on the command button and select assign macro it will take you to the correct window to paste the code

 

[inspectorNDT]

I would like the code attached to the command button per my first post.

also when i try to run the code now the Private Sub CommandButton1_Click() is highlighted.

IS the code attached to a CommandButton ???
If so, yes !...but the code you posted originally didn't show that.

The revised code that both @Logit and I posted added a Backslash after Desktop !!
As mentioned earlier, did you make sure that the cells refering to the filename are correct and DO NOT contain any illegal characters.

I might add that the code works fine for me !!

 

[inspectorNDT]

Did that and I get a compile error expected end sub and the Private Sub CommandButton1_Click() is highlighted.

If you Rclick on the command button and select assign macro it will take you to the correct window to paste the code

 

[Logit]

.
Type END SUB at the bottom of all your lines of code.

 

[Logit]

.
Download working example : https://www.amazon.com/clouddrive/share/O6uLWDQPZgcVqQi5Hc6JwMlqkPBdNmtqT6GpT4LZZnT

 

[inspectorNDT]

still the same problem

thanks for all your help

.
Type END SUB at the bottom of all your lines of code.