Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: Excel file with a name keeps opening
Thread ID: 311209 Message ID: 311259 # Views: 58 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Active X Controls & OLE Automation
Date: Thursday, June 30, 2011 1:00:03 AM         
   


> I wrote an EXCEL Automation program that was working fine until I suddenly had Excel opening the file before I even gave it a name. I believe that this is an Excel configuration issue, but don't know enough about Excel to stop this from re-occurring. I am stopped dead in my tracks and cannot test on this laptop, since Excel keeps opening an Excel file with a pre-determined name, something which is not even done in my code.
>
> I'll show my code and where it occurs:
>

Does excel do that also when you are trying to open an empty sheet straight from desktop or explorer? If so, you may have something on the startup folder allocated for excel. You can check these locations:

a: version 2003 - C:\Program Files\Microsoft Office\Office11\Xlstart
version 2007 - C:\Program Files\Microsoft Office\Office12\Xlstart

b: C:\Documents and Settings\User_name\Application Data\Microsoft\Excel\XLSTART

If any worksheet is placed there, it will be opened outright together with excel.

Also check for macros, maybe something is infused on your excel (by a virus or from whatever).

http://sandstorm36.blogspot.com/
http://weblogs.foxite.com/sandstorm36/default.aspx
http://www.coderisland.com/forum/viewforum.php?f=10

ENTIRE THREAD

Excel file with a name keeps opening Posted by Cecil Champenois @ 6/29/2011 5:28:38 PM
RE: Excel file with a name keeps opening Posted by Vladimir Zhuravlev @ 6/29/2011 7:40:24 PM
RE: Excel file with a name keeps opening Posted by Cecil Champenois @ 6/29/2011 8:50:09 PM
RE: Excel file with a name keeps opening Posted by Jun Tangunan @ 6/30/2011 1:00:03 AM
RE: Excel file with a name keeps opening Posted by Cecil Champenois @ 7/5/2011 4:01:29 PM