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 13 of 13
Search took 0.03 seconds. Search: Posts made by: expect_ed
Forum: Outlook and VBA October 23rd 08, 10:53 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 828
Posted By expect_ed
Outlook VBA app references XL-Runtime error 9

Excuse if this is a duplicate post - I thought I posted this an hour ago but
it does not appear:
Now I am thoroughly confused. I tried Alan's code on the other machine and
it worked without an...
Forum: Outlook and VBA October 21st 08, 06:33 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 828
Posted By expect_ed
Outlook VBA app references XL-Runtime error 9

Thanks to both of you for your help. I will try this tomorrow on the
offending machine and let you know the results.
Thanks again.
ed

"Alan Moseley" wrote:

This is the same code but broken...
Forum: Outlook and VBA October 21st 08, 04:57 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 828
Posted By expect_ed
Outlook VBA app references XL-Runtime error 9

Alan / Ken
Thanks for the response. I have gone to the users machine and confirmed
that the workbook is open. It is in fact the same workbook I forwarded to
her, with the exception that she has...
Forum: Outlook and VBA October 20th 08, 09:41 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 828
Posted By expect_ed
Outlook VBA app references XL-Runtime error 9

Hi Ken,
Thanks for the quick response.

The error comes at the line: TopFldr =
xl.Workbooks("Index.xls").Sheets(1).Range("TopFldrG").Value

I've double checked the spelling, spaces, range name,...
Forum: Outlook and VBA October 20th 08, 07:39 PM Posted to microsoft.public.outlook.program_vba
Replies: 9
Views: 828
Posted By expect_ed
Outlook VBA app references XL-Runtime error 9

Created a set of Macros to file messages, then drive them with ALT keys from
toolbar buttons, each button with it's own code. I'm trying to distribute
this to co-workers, so I put the code into a...
Forum: Outlook - Calandaring April 28th 08, 02:39 AM Posted to microsoft.public.outlook.calendaring
Replies: 3
Views: 455
Posted By expect_ed
Calculating Hyperlinks

What is whs??

"Diane Poremsky {MVP}" wrote:

you might be able to do something with VBA in a custom form. I'd probably so
it with a whs and Windows Task Scheduler.

--
Diane Poremsky...
Forum: Outlook - Calandaring April 25th 08, 05:46 PM Posted to microsoft.public.outlook.calendaring
Replies: 3
Views: 455
Posted By expect_ed
Calculating Hyperlinks

I need to review a status report weekly which is stored deep in
sub-directories on a mapped network drive. I have a recurring appt. set to
remind me to review the report and would like to add a...
Forum: Outlook and VBA May 22nd 07, 06:00 PM Posted to microsoft.public.outlook.program_vba
Replies: 1
Views: 946
Posted By expect_ed
Which Macro is linked to Command Button

Hi,
Sorry for the cross post but got no response to this in the general section.

I have created lots of macros to redirect my messages into personal folders.
Then I customized a toolbar to include...
Forum: Outlook and VBA March 28th 07, 02:11 AM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 603
Posted By expect_ed
Referencing Excel cell from Outlook VBA

That did it. Sorry for my limited knowledge and thanks so much for your help.
ed

"Michael Bauer [MVP - Outlook]" wrote:



Please add a reference to Microsoft Excel via Tools/References.

...
Forum: Outlook and VBA March 23rd 07, 06:36 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 603
Posted By expect_ed
Referencing Excel cell from Outlook VBA

Thanks again Michael. I figured out the Workbood.Open syntax and got it to
work
BUT
When I tried using your example i could not get it working, so I tried it in
a macro by itself to isolate the...
Forum: Outlook and VBA March 23rd 07, 01:51 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 603
Posted By expect_ed
Referencing Excel cell from Outlook VBA

Michael, that is excellent. It would have taken me another 2 days work or
more to figure that out on my own. My co-workers are going to think I'm a
genius thanks to you (of course I'm taking all...
Forum: Outlook and VBA March 22nd 07, 10:25 PM Posted to microsoft.public.outlook.program_vba
Replies: 6
Views: 603
Posted By expect_ed
Referencing Excel cell from Outlook VBA

My apologies if this is a redundant post. I responded to a thread from Jan
but it appears there is not a view that shows new replies. If I missed it I
apologize.

My issue is this:
I have about 2...
Forum: Outlook and VBA February 7th 07, 05:03 PM Posted to microsoft.public.outlook.program_vba
Replies: 2
Views: 671
Posted By expect_ed
Programming Context Menus

OK Sue, Thanks for saving me gonig on a wild goose chase. Guess I'll wait
til the company upgrades to '07.


"Sue Mosher [MVP-Outlook]" wrote:

Outlook 2007 provides Application-level events for...
Showing results 1 to 13 of 13

 
Forum Jump

All times are GMT +1. The time now is 05:37 PM.

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.