vb6 error opening excel


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: vb6 error opening excel

  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Cool vb6 error opening excel

    Hi
    run my program from a .exe it will error out on the line that creates an excel object
    Set XLAPP2 = CreateObject("Excel.application")
    If I step thru it in the debugger it runs just fine any suggestions
    Thanks nick

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    What does the error message say?
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

  3. #3
    Join Date
    Nov 2007
    Posts
    2
    Hi Phil
    1004 method of object failed
    I have a workaround when I capture the error in my error handler i recall the sub and it works. I don't like it but it will get me by till I find out what is wrong.
    Nick

Similar Threads

  1. problem in opening XML with EXCEL via VB6
    By eranfox in forum VB Classic
    Replies: 5
    Last Post: 08-09-2007, 08:18 AM
  2. importing a text file into excel component in vb6
    By Spumbu1977 in forum VB Classic
    Replies: 4
    Last Post: 09-05-2006, 11:07 PM
  3. vb6 and excel
    By Spumbu1977 in forum VB Classic
    Replies: 4
    Last Post: 07-12-2006, 08:50 PM
  4. open & close EXCEL with VB6
    By Garner in forum VB Classic
    Replies: 18
    Last Post: 05-14-2006, 12:59 AM
  5. Using VB6 to write to an Excel file.
    By AM003295 in forum VB Classic
    Replies: 7
    Last Post: 04-18-2005, 05:28 PM

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