Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues


--
When you lose your mind, you free your life.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Late Binding Issues

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...

--
When you lose your mind, you free your life.



  #3   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues

sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...

--
When you lose your mind, you free your life.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Late Binding Issues

http://office.microsoft.com/en-us/as...347711033.aspx

look and use the /regserver switch



--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...
sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever

Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in

message
...

--
When you lose your mind, you free your life.






  #5   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues

Good thought,

I tried that already, tried it again just now.

says the "The Command Line argument is not valid. Verify the switch you are
using."

--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/as...347711033.aspx

look and use the /regserver switch



--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...
sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever

Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in

message
...

--
When you lose your mind, you free your life.








  #6   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues

http://support.microsoft.com/default...b;en-us;827593

this behaviour is by design

--
When you lose your mind, you free your life.


"ben" wrote:

Good thought,

I tried that already, tried it again just now.

says the "The Command Line argument is not valid. Verify the switch you are
using."

--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/as...347711033.aspx

look and use the /regserver switch



--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...
sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever

Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in

message
...

--
When you lose your mind, you free your life.






  #7   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues

So evidently SP3 removes the outlook key, and they don't want you to
re-install it. Does this mean that Microsoft is removing automation
compatibility for Outlook?




--
When you lose your mind, you free your life.


"ben" wrote:

http://support.microsoft.com/default...b;en-us;827593

this behaviour is by design

--
When you lose your mind, you free your life.


"ben" wrote:

Good thought,

I tried that already, tried it again just now.

says the "The Command Line argument is not valid. Verify the switch you are
using."

--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/as...347711033.aspx

look and use the /regserver switch



--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...
sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever
Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in
message
...

--
When you lose your mind, you free your life.






  #8   Report Post  
Posted to microsoft.public.excel.programming
ben ben is offline
external usenet poster
 
Posts: 232
Default Late Binding Issues

For anyone reading this post there seems to be a work-around albeit not as
useful.

Using

set olApp = GetObject( , "Outlook.Application")

this method will fail if outlook is not open, so I tell the user to Open
outlook and press retry or just cancel the function.

--
When you lose your mind, you free your life.


"ben" wrote:

So evidently SP3 removes the outlook key, and they don't want you to
re-install it. Does this mean that Microsoft is removing automation
compatibility for Outlook?




--
When you lose your mind, you free your life.


"ben" wrote:

http://support.microsoft.com/default...b;en-us;827593

this behaviour is by design

--
When you lose your mind, you free your life.


"ben" wrote:

Good thought,

I tried that already, tried it again just now.

says the "The Command Line argument is not valid. Verify the switch you are
using."

--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://office.microsoft.com/en-us/as...347711033.aspx

look and use the /regserver switch



--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in message
...
sorry tom see post above for text
--
When you lose your mind, you free your life.


"Tom Ogilvy" wrote:

http://support.microsoft.com/default...b;EN-US;244167
INFO: Writing Automation Clients for Multiple Office Versions

http://support.microsoft.com/default...b;en-us;245115
INFO: Using Early Binding and Late Binding in Automation

http://support.microsoft.com/default...b;en-us;247579
INFO: Use DISPID Binding to Automate Office Applications Whenever
Possible

Address some of the issues.

--
Regards,
Tom Ogilvy


"ben" (remove this if mailing direct) wrote in
message
...

--
When you lose your mind, you free your life.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Late binding issues with Excel and Outlook Dave Benson Excel Programming 0 November 26th 05 03:00 AM
Late Binding Mark Excel Programming 4 October 17th 05 04:02 PM
Late Binding issues when closing workbooks HeatherO Excel Programming 18 April 1st 05 06:04 PM
Late Binding examples of binding excel application HeatherO Excel Programming 13 March 17th 05 08:19 AM
EARLY binding or LATE binding ? jason Excel Programming 6 February 26th 04 04:57 PM


All times are GMT +1. The time now is 10:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"