DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VB Automation error with excel file

  1. #1
    Parita Pai Guest

    VB Automation error with excel file


    Hi,

    I have created an application in VB which which reads from and updates an
    Excel file. But if while the application is running (ie excel is being updated)
    if i open the excel sheet, i get an Automation error. Can you please suggest
    how should i prevent this.


    Thanks and Best Wishes.

  2. #2
    Paul Clement Guest

    Re: VB Automation error with excel file

    On 19 Jul 2002 02:13:31 -0700, "Parita Pai" <parita.pai@patni.com> wrote:


    Hi,

    I have created an application in VB which which reads from and updates an
    Excel file. But if while the application is running (ie excel is being updated)
    if i open the excel sheet, i get an Automation error. Can you please suggest
    how should i prevent this.

    You would need to open another instance of Excel. Unfortunately you cannot work in an instance of
    Excel and concurrently control it via automation.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center