LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
external usenet poster
 
Posts: 97
Default programming issue when using Excel automation

Hello,
My application interacts with Excel spreadsheet. Periodically it
reads some data from the predefined sheet's column.
Everything works fine, when user does not use that spreadsheet at the same
time.
However, when user is typing in the sheet at the same time when my app wants
to read data from it there is a problem. Excel displays 'Component Busy'
message with the Switch to..., Retry and Cancel options.

How to solve that problem?
My app uses Excel automation and it connects to Excel using this code:

Public WithEvents moExcelApp As Excel.Application

Set moExcelApp = GetObject(, "Excel.Application")
If moExcelApp Is Nothing Then
Set moExcelApp = CreateObject("Excel.Application")
End If

Your comments appreciated,
Jack


 
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
Excel automation issue---enter date into cell based on other cellvalue [email protected] Excel Programming 0 January 15th 08 09:28 PM
Excel Automation : numbers Copy/Paste issue from VB6 [email protected] Excel Programming 6 July 7th 06 09:18 AM
where do I find docs on excel automation programming? Mike[_108_] Excel Programming 0 June 8th 06 06:41 PM
Excel Automation Issue Matthew Wieder Excel Programming 4 September 8th 03 06:26 AM


All times are GMT +1. The time now is 08:12 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"