Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel automation issue---enter date into cell based on other cellvalue | Excel Programming | |||
Excel Automation : numbers Copy/Paste issue from VB6 | Excel Programming | |||
where do I find docs on excel automation programming? | Excel Programming | |||
Excel Automation Issue | Excel Programming |