A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Search Forums
Reload this Page Search Results
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Showing results 1 to 19 of 19
Search took 0.04 seconds. Search: Posts made by: wpiet
Forum: Outlook and VBA September 17th 09, 09:37 PM Posted to microsoft.public.outlook.program_vba
Replies: 5
Views: 1,617
Posted By wpiet
Using Excel UserForm from Open Workbook in Outlook VBA

MIchael, I resolved the Abt issue by qualifying references to it:
"ThisWorkbook.Abt".

--
Will


"Michael Bauer [MVP - Outlook]" wrote:
Forum: Outlook and VBA September 17th 09, 08:31 PM Posted to microsoft.public.outlook.program_vba
Replies: 5
Views: 1,617
Posted By wpiet
Using Excel UserForm from Open Workbook in Outlook VBA

Very insightful. That is exactly right. thanks.

Now that the userform opens, I find another problem the

In the userform Sub cmdOK_Click(), I get "Compile error: Variable not
defined" on...
Forum: Outlook and VBA September 17th 09, 05:45 PM Posted to microsoft.public.outlook.program_vba
Replies: 5
Views: 1,617
Posted By wpiet
Using Excel UserForm from Open Workbook in Outlook VBA

Thanks for the response, Michael.
I'm apparently missing something or doing something else wrong. Here's my
code (Office 2003):

In "This Workbook":

Option Explicit
Public Abt As String
Public...
Forum: Outlook and VBA September 16th 09, 10:50 PM Posted to microsoft.public.outlook.program_vba
Replies: 5
Views: 1,617
Posted By wpiet
Using Excel UserForm from Open Workbook in Outlook VBA

I have an Outlook macro that opens & processes an Excel workbook.
That workbook contains a userform that has textboxes with ControlSources
assigned to cells in the workbook.
Can I use that Excel...
Forum: Outlook and VBA March 7th 09, 02:17 AM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 467
Posted By wpiet
Add Reference to XL function (2003)

Thank you, Ken. I will do that.
--
Will


"Ken Slovak - [MVP - Outlook]" wrote:

You might want to post about calling an Excel UDF from outside Excel in an
Excel programming group, the people...
Forum: Outlook and VBA March 5th 09, 08:51 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 467
Posted By wpiet
Add Reference to XL function (2003)

Is there a way to reference an Excel user-defined function in Outlook VBA?
I created a Boolean function that, via a userform, accepts a username &
password & authenticates them against...
Forum: Outlook and VBA February 18th 09, 01:13 AM Posted to microsoft.public.outlook.program_vba
Replies: 1
Views: 529
Posted By wpiet
Find calendar time blocks of specified length

Can someone direct me to a starting point for developing a calendar program
that accepts input of a desired time-block length (e.g. 15 minutes) that will
search the calendar & return available...
Forum: Outlook and VBA January 23rd 09, 08:35 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 2,813
Posted By wpiet
Attach Excel Worksheet (Not Workbook) to Email

Thanks, Ken.
I'll try that.
--
Will


"Ken Slovak - [MVP - Outlook]" wrote:

As far as I know you will need to save each sheet as a separate workbook,
but you might want to post in an Excel...
Forum: Outlook and VBA January 23rd 09, 06:46 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 2,813
Posted By wpiet
Attach Excel Worksheet (Not Workbook) to Email

Is there a way to attach a single worksheet from an Excel workbook to an
Outlook email?
I have a workbook with multiple worksheets, each of which must attach to a
different email. The following...
Forum: Outlook and VBA January 7th 09, 01:54 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Hey, I'm always open to any suggestion. I have no idea what I'm doing! It's
all new to me, so any insight is appreciated. I had a few other issues rear
their ugly heads but seem to have worked them...
Forum: Outlook and VBA January 6th 09, 09:30 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 758
Posted By wpiet
Access Excel (whether already open or not) from Outlook

That would be why.
I'll file that one under "You da man, Norman."
Thanks
--
Will


"Norman Yuan" wrote:

D you know GetObject() takes TWO optional arguments? The first one is
Forum: Outlook and VBA January 6th 09, 08:23 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 758
Posted By wpiet
Access Excel (whether already open or not) from Outlook

What am I doing wrong with this code?

Dim XL As Object

On Error Resume Next
Set XL = GetObject("Excel.Application")
If XL Is Nothing Then
Set XL =...
Forum: Outlook and VBA January 6th 09, 05:59 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Thanks for the Quit suggestion.
I also discovered an intermittent Error 9 (subscript out of range) on
'XL.Windows("Master.xls").Visible = True' because sometimes the preceding
statement,
'Set WB =...
Forum: Outlook and VBA January 5th 09, 11:11 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Ken & JP,

Thanks to both of you, everything works beautifully.

For the benefit of others looking for such a solution, here's the relevant
code from my Outlook macro that creates e-mails from an...
Forum: Outlook and VBA January 2nd 09, 03:46 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Jimmy, did you just make a change to your site? I followed the link & was
reading the article but when I looked around the site and tried to go back to
the article, I got the "Something's wrong...
Forum: Outlook and VBA December 31st 08, 04:52 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Thanks, Ken. I didn't see your post before my response to JP. Yours answered
those questions of mine. Sounds like we're all on the same page, essentially.
I think I'm getting the idea. Thanks to...
Forum: Outlook and VBA December 31st 08, 04:43 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

My problem is that I don't have a clue what's possible from either
application, since I've never programmed for either one (or done any other
VBA coding).
As it is, the Excel workbook contains 5...
Forum: Outlook and VBA December 30th 08, 11:17 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

Thanks for the suggestion, Ken. I'll be looking into that.
Is it possible to, alternatively, start from Outlook, access the Excel
workbook & process the VBA macro there which creates the e-mails &...
Forum: Outlook and VBA December 30th 08, 07:52 PM Posted to microsoft.public.outlook.program_vba
Replies: 14
Views: 4,443
Posted By wpiet
Can I disable Outlook warning from Excel macro "Send" method

I have an Excel macro that sends e-mails via Outlook, using the VBA "Send
Method."
For each message sent, Outlook displays a warning requiring a "Yes" response.
Is there a way, either in Outlook or...
Showing results 1 to 19 of 19

 
Forum Jump

All times are GMT +1. The time now is 03:19 AM.

Feed Icon - Contact Us - OutlookBanter Home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.