Coding
Excel & VBA
Press Ctrl+Enter to quickly submit your post
Quick Reply
From:
Extrobe (ALDREDD)
5 Sep 2006 17:53
To:
Extrobe (ALDREDD)
2 of 3
30521.2
In reply to
30521.1
hold the press - I think I spoke too soon!
VBA code:
Email_Address = Range("AJ3")
seems to have doen the trick!
0/0
Reply
Quote
More
From:
Extrobe (ALDREDD)
5 Sep 2006 17:57
To:
Extrobe (ALDREDD)
3 of 3
30521.3
In reply to
30521.2
Although - while I'm at it - does any one know how I can just send the worksheet & not the whole work book as an email when using vba?
I currently use
code:
Open_book = ThisWorkbook.FullName
which allows me to attached the workbook
0/0
Reply
Quote
More
Reply to All
1–3
Rate my interest:
Ignore
Normal
Interested
Subscribed
Adjust text size :
Smaller
10
Larger
Beehive Forum 1.5.2 |
FAQ
|
Docs
|
Support
|
Donate!
©2002 - 2024
Project Beehive Forum
Forum Stats