Excel / VBForms problem

Yahoo Archive
1
I've done this when there are only a few Excel sessions open. However, our configurators are set-up to run ExcelLookup multiple times to simplify the BOM and configurator rules and make it easy to make revisions. When running/testing, multiple sessions of Excel remain open. I've often have all 512Mb of memory clogged up with tens if not a hundred instances of Excel open. Much easier to shut down than terminate the sessions one by one. When in need to open any Excel files, I just start up Excel first and open the file from within Excel.

I've had this problem in Win98, Win2000 and now in XP. Epicor knows about the problem and recommended a service pack be installed when I was in 5.1 running on Win98. The problem went away for a while then returned when we moved to Win2000. Epicor says they cannot replicate it. They claim that Vantage only looks into the data contained in the Ecel file and does not even open Excel during in the ExcelLookup procedure.

Don't know where the problem lies. Perhaps the sys ad and windows gurus on the list can shed more light on this.

Thanks,

Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...

-----Original Message-----
From: Greg Krumrey [mailto:gkrumrey@...]
Sent: Wednesday, 22 January 2003 8:00 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Excel / VBForms problem


I've had this same problem and discovered a solution.

Here's a solution that works for me (in Windows XP Pro):

Exit any ExCel sessions that you have running on the Task Bar.

Hit Ctrl-Alt-Delete and bring up the task manager. Sort by Image name, look
for ExCel.exe on the list.

Terminate any Excel sessions.

Once they are all terminated, ExCel should work normally.

The way that I've duplicated this problem is creating a spreadsheet using
Progress, without setting it to Visible, then terminating the program
without quitting the application. It does not show up anywhere except the
task manager.

Let me know if this works for you...

Greg Krumrey, Information Manager, Patriot Machine, Inc.
Voice: 636-940-1776 x 130, fax: 636-940-8933
email: mailto:greg.krumrey@...
Alt: mailto:greg.krumrey@... Web: www.patriot-machine.com

Original Problem:
I've noticed this problem in a different situation. After using a product
configurator that has an Excel Lookup expression, clicking any Excel
document file icon will open Excel exactly the way you described it. The
headings and menu items up top are visible but the worksheet area is not. In
our case, you can see the contents of the window underneath! It is
transparent, not greyed out and blank. When closing this ghost window, an
error message pops up that says Excel is terminating the process anyway. The
only way to open an Excel file is to open Excel and then open the file from
there, just as you have described.

Rebooting takes care of the problem until I need to run a configurator
again.




Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/M=241773.2861420.4212388.1925585/D=egroupweb/S=1705007183:HM/A=1394046/R=0/*http://www.hgtv.com/hgtv/pac_ctnt/text/0,,HGTV_3936_5802,FF.html> HGTV Dream Home Giveaway
<http://us.adserver.yahoo.com/l?M=241773.2861420.4212388.1925585/D=egroupmail/S=:HM/A=1394046/rand=351477038>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Someone on the group helped me use the following code to launch an Excel
program from a VBForm. The problem is, after running the code below, Excel
doesn't work properly until a reboot. The symptoms are that (after
accessing Excel via the VBForm) after double-clicking on an Excel file,
Excel will open up, but will not show the spreadsheet. It shows the
headings and menu items at the top of the Excel window, but won't show the
data in the cells. It's all a grey sheet. Moving your arrow key shows the
data from individual cells in the "Edit Formula" window, but you just can't
see the sheet. A workaround is to open Excel first (blank page), then open
your saved worksheet from there. Does anyone see anything in the code below
that would cause Excel to behave like that?

Troy Funte
Liberty Electronics


{vbp/vb.i}
/* start of code */
def var chExcelApplication AS COM-HANDLE NO-UNDO.
def var chWorkbook as com-handle no-undo.
def var chWorkSheet as com-handle no-undo.
def var File-Name AS CHARACTER.
FIND NonConf WHERE ROWID(NonConf) = GetCurrentRowID() no-lock.
ASSIGN File-Name = "C:\My Documents\Inspection checklists by part\" +
NonConf.PartNum + ".xls".
CREATE "Excel.Application" chExcelApplication.
chWorkBook = chExcelApplication:Workbooks:Open(File-Name).
chExcelApplication:Visible = True.
/* end of code */
RETURN.
3
I don't think this has anything to do with the code per se, and it's all Greek to me anyway.

I've noticed this problem in a different situation. After using a product configurator that has an Excel Lookup expression, clicking any Excel document file icon will open Excel exactly the way you described it. The headings and menu items up top are visible but the worksheet area is not. In our case, you can see the contents of the window underneath! It is transparent, not greyed out and blank. When closing this ghost window, an error message pops up that says Excel is terminating the process anyway. The only way to open an Excel file is to open Excel and then open the file from there, just as you have described.

Rebooting takes care of the problem until I need to run a configurator again.

We informed our local Epicor Office of problems related to Excel since August when we were testing on 5.1. This one we reported in November when we moved to 5.2. Still pending resolution.

Probably need a big push from a lot of users.

Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, 11 December 2002 10:10 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Excel / VBForms problem


Someone on the group helped me use the following code to launch an Excel
program from a VBForm. The problem is, after running the code below, Excel
doesn't work properly until a reboot. The symptoms are that (after
accessing Excel via the VBForm) after double-clicking on an Excel file,
Excel will open up, but will not show the spreadsheet. It shows the
headings and menu items at the top of the Excel window, but won't show the
data in the cells. It's all a grey sheet. Moving your arrow key shows the
data from individual cells in the "Edit Formula" window, but you just can't
see the sheet. A workaround is to open Excel first (blank page), then open
your saved worksheet from there. Does anyone see anything in the code below
that would cause Excel to behave like that?

Troy Funte
Liberty Electronics


{vbp/vb.i}
/* start of code */
def var chExcelApplication AS COM-HANDLE NO-UNDO.
def var chWorkbook as com-handle no-undo.
def var chWorkSheet as com-handle no-undo.
def var File-Name AS CHARACTER.
FIND NonConf WHERE ROWID(NonConf) = GetCurrentRowID() no-lock.
ASSIGN File-Name = "C:\My Documents\Inspection checklists by part\" +
NonConf.PartNum + ".xls".
CREATE "Excel.Application" chExcelApplication.
chWorkBook = chExcelApplication:Workbooks:Open(File-Name).
chExcelApplication:Visible = True.
/* end of code */
RETURN.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
I've had this same problem and discovered a solution.

Here's a solution that works for me (in Windows XP Pro):

Exit any ExCel sessions that you have running on the Task Bar.

Hit Ctrl-Alt-Delete and bring up the task manager. Sort by Image name, look
for ExCel.exe on the list.

Terminate any Excel sessions.

Once they are all terminated, ExCel should work normally.

The way that I've duplicated this problem is creating a spreadsheet using
Progress, without setting it to Visible, then terminating the program
without quitting the application. It does not show up anywhere except the
task manager.

Let me know if this works for you...

Greg Krumrey, Information Manager, Patriot Machine, Inc.
Voice: 636-940-1776 x 130, fax: 636-940-8933
email: mailto:greg.krumrey@...
Alt: mailto:greg.krumrey@... Web: www.patriot-machine.com

Original Problem:
I've noticed this problem in a different situation. After using a product
configurator that has an Excel Lookup expression, clicking any Excel
document file icon will open Excel exactly the way you described it. The
headings and menu items up top are visible but the worksheet area is not. In
our case, you can see the contents of the window underneath! It is
transparent, not greyed out and blank. When closing this ghost window, an
error message pops up that says Excel is terminating the process anyway. The
only way to open an Excel file is to open Excel and then open the file from
there, just as you have described.

Rebooting takes care of the problem until I need to run a configurator
again.