Search found 489 matches
- Nov 12, 2016 7:38
- Forum: General
- Topic: Problem With duplicate definitions in FB_GUI
- Replies: 3
- Views: 737
Re: Problem With duplicate definitions in FB_GUI
Yes, the variable color_menu became a new global variable with windows updates. I first noticed this with Win7. I made a local fix by defining a new namespace for the definition of custom colors. I will upload later this weekend. In fact, I have several years worth of updates to FBGUI to be posted.
- Jul 26, 2016 18:18
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Zippy,
Thanks. xlquitZombies() works perfectly for my needs in xlhelper.
Thanks. xlquitZombies() works perfectly for my needs in xlhelper.
- Jul 18, 2016 17:16
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Zippy,
I should have provided more details. It doesn't matter whether Add.Global is on or off. Quit always reports "success" and yet the process remains active. ZombieCheck finds the PID and successfully kills the process.
I should have provided more details. It doesn't matter whether Add.Global is on or off. Quit always reports "success" and yet the process remains active. ZombieCheck finds the PID and successfully kills the process.
- Jul 18, 2016 17:01
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Zippy,
Zombies still present after quit, but your kill PID routine worked perfectly.
@OSchmidt,
I'm away from the university now (at Big Sky Montana :-) ) so upgrades to excel might be behind the latest available. When I get time, I will upgrade to FB 1.05 and try our SimpleVarient code.
Zombies still present after quit, but your kill PID routine worked perfectly.
@OSchmidt,
I'm away from the university now (at Big Sky Montana :-) ) so upgrades to excel might be behind the latest available. When I get time, I will upgrade to FB 1.05 and try our SimpleVarient code.
- Jul 17, 2016 1:04
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@OSchmidt I will be happy to test this with MSO 2016, but I couldn't get SimpleVarient.bi to compile with your code above. In the BI file: line Mssg 74 Variable not declared, CBool 268 Duplicated definition 269 Duplicated definition 270 Duplicated definition 382 Array not dimensioned, before '(' 386...
- Jul 15, 2016 23:58
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Zippy
Thanks for persisting. I am using Office 365 with Excel Version 16.0.4405.1000 64-bit.
I'll see if it's possible to force an update.
Thanks for persisting. I am using Office 365 with Excel Version 16.0.4405.1000 64-bit.
I'll see if it's possible to force an update.
- Jul 15, 2016 21:00
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Zippy Zombies, indeed. When I run your code with FB 1.03.0 32-bit in Win 7 Enterprise SP1 64-bit with MS Office 2016, I get two lingering excel.exe processes If, however, I force the spreadsheet to be invisible with: xlstart(,FALSE) then no lingering process. The effect is very buggy. Even after xl...
- Jul 14, 2016 22:37
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
Update. There are several references to excel remaining active in the tasklist even after executing an .application.quit command in VBA. This behavior was noted back in MS Office 2013. The cause was identified as: "The most common cause of the problem is a 'global' reference to the automated ap...
- Jul 14, 2016 2:53
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
Thanks for the reference. I agree, looks like Excel 2016 is buggy
- Jul 13, 2016 22:20
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
If you know of a way to get the process ID for the instance of excel that was launched by xlopen(), then I could selectively use taskkill to wipe out just that image of excel.
- Jul 13, 2016 22:16
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
I added xlrelease (just after xlquit) -> the excel.exe image is still active in tasklist. Curiously, xlrelease before xlquit generates an error message: application.quit CallMethod InvokeV The parameter is incorrect code: 80070057 Is this expected if xlrelease is attempted before xlquit?
- Jul 13, 2016 20:06
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
@Phishguy, After installing MS Office 2016, excel remains an active process (shown in Task Manager) even after performing xlquit. The open workbook closes and the application window closes, but the application is active. With multiple xlOpen commands executed, this leaves a huge list of excel.exe ac...
- Jan 21, 2016 5:56
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
Your suggestion of having Excel Visible helped reveal to problem. I'm trying to read an existing Excel file, not create a new one. I mistakenly thought xlstart() was required to launch the application. xlopen() had a create object call as well xlco("Excel.Application", NULL, @xlApp) and so...
- Jan 21, 2016 1:21
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
Even this short little piece of code leaves excel.exe running #include once "xlhelper.bas" xlstart (1,FALSE) 'initialize Excel, 1 sheet, not visible xlopen(curdir & "\" & "My_Excel", FALSE) 'Open file, not visible Print Val(xlgetvalue(1,2)) xlquit xlrelease sleep
- Jan 17, 2016 5:52
- Forum: Projects
- Topic: Excel helper wrapper
- Replies: 71
- Views: 23123
Re: Excel helper wrapper
Excel wrapper is a great tool, but even after closing it down with xlquit and xlrease there still is an excel.exe process running (as shown by the Processes tab in the Task Manager. Moreover, if you make several calls to xlstart and xlopen, then there are multiple processes that are left running.