Error with opening excel file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • manontheedge
    New Member
    • Oct 2006
    • 175

    #1

    Error with opening excel file

    I have a program in VB6 that gets data from an internet site, puts it in excel, then opens that excel sheet. It works, but only because I'm throwing an exception and ignoring the error that keeps popping up.

    The problem comes when the excel sheet opens. The sheet opens fine, but the program stops and gives an error message '1004'

    I'm wondering what the error is. I don't understand why the error is given. The program works fine, and everything is correct ( and when I ignore the error in the code, it's perfect ). So, why is this error coming up?
Working...