Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Programming
 EXP Systems Forum : PDF reDirect : Programming
Topic: Email Body - Excel Spreadsheet Post Reply Post New Topic
Author Message
JackR
Newbie
Newbie


Joined: 06 Jan 08
Posts: 13
Quote JackR Replybullet Topic: Email Body - Excel Spreadsheet
    Posted: 06 Jan 08 at 2:02PM
I downloaded your VB Examples and am trying to understand how they work. I have not done any VB programming but plan to spend more time working with it in the near future.

I would like to set up a cell on the spreadsheet where I could input the email text so that when I click on the button "Click here to make PDF" the pdf will be created and an email would be generated with the text that was input on the spreadsheet.. I am able to get the email portion working but can not get the email text to work. I named a spreadsheet cell Email_body and declared it(Email_body) as a variable (Public emailbody As String).

Is there any way of pulling in the text for the email from the spreadsheet. Also, other than the help sections, is there any book that you would recommend for learning Visual Basic

Thank you







   
IP IP Logged
JackR
Newbie
Newbie


Joined: 06 Jan 08
Posts: 13
Quote JackR Replybullet Posted: 06 Jan 08 at 10:33PM
Michel

I figured it out. I was missing the reference to the control in the work sheet.
IP IP Logged
Michel_K17
Moderator Group
Moderator Group
Avatar
Forum Administrator

Joined: 25 Jan 03
Posts: 1673
Quote Michel_K17 Replybullet Posted: 07 Jan 08 at 11:13PM
Glad to hear it. Well done! Smile

Learning VB is not too bad once you get over the concept of ParentObject.Object.Method and ParentObject.Object.Property.

For example:
  • Car.Engine.Start would be a method (an action on something) and
  • Car.ExternalColor = Blue (you can usually read and assign a value to a property).

    In terms of a book, I used the book that came with Visual Basic 4 way-back-when (it's dated 1995), and VB6 did not come with a book as by then, Microsoft started to rely on the online documentation. Same goes for VBA (that's the version of VB that comes with Microsoft Office programs). Their online documentation is not bad: it just takes a lot of time to go through the entire user documentation.

    Good luck! It sounds like you are well on your way though.

Michel Korwin-Szymanowski
EXP Systems LLC
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum