First timer command button link - compile error expected end sub

**MONSIRET** · 05-25-2012, 04:34 AM

VB,
COMMAND BUTTON,
PRINT ACTIVE SHEET TO PDF,
ADD NAME TO PDF FROM SPECIFIC CELL,
OPEN OUTLOOK 2010 NEW EMAIL,
ADD EMAIL ADDRESS FROM SPECIFIC CELL,
ADD PDF TO EMAIL AS ATTACHEMENT,
STOP SO THAT EMAIL CAN BE SENT AFTER REVIEW OF PDF ATTACHEMENT

Hi Everyone
If anyone can help me to streamline the above, I would appreciated it.
I copied the code from another VB programmer, but when I linked it to the command button, I get the error message.
Error Message.jpg

Here is the code where the error occurs.
Code.jpg

This is my first VB attempt, so I might have bit off more than I could chew!

**arlu1201** · 05-25-2012, 06:00 AM

If you check at the top of your code, you can have 2 statements

1. Private sub....
2. Sub RDB_workbook....

Remove the 2nd line, then the error will stop.

**MONSIRET** · 05-25-2012, 08:34 AM

Thanks! All good!

First timer command button link - compile error expected end sub

LinkBack

Thread Tools

Rate This Thread

Display

First timer command button link - compile error expected end sub

Re: First timer command button link - compile error expected end sub

Re: First timer command button link - compile error expected end sub

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions