Problem with importing Excel data

Hi all,

When I was conducting training in importing Excel spreadsheet data, my client faced problem in importing. I have enclosed the error log file.

They are using V4.32, XP and Microsoft office 2000.

Anyone faced the same problem in working with these combination?

David

David,

Somewhere along the line, Flexsim has changed from DDE to OLE with importing from Excel, and office 2000 doesn't support OLE.

You can use the maintance command with parameter 1000 to get back to DDE. write something like: "maintenance(1000, 1);" before you make any calls to excel commands. that should do the trick.

Steven

Hi,

we have had the same problem last time.
We tried to change from OLE to DDE and the other way, every time the same error like you have. Maybe v4.32 doesnt support office 2000.

We adviced them to update the office version.

regards
Tobias

Steven and Tobias, thanks for the information.

As I was using the MTEI to import the data, how and should I trigger the maintenance command? At the Script?

I believe we found that the maintenance(1000,1) trick works for Single Table and Custom Import/Export, but does not help the MTEI in this situation. I don't know of a fix for the MTEI.

Kris

Jeff from Flexsim Support team wrote:

"In Excel 2003 and above, the way Flexsim interfaces with Excel is OLE. In Excel 2000, Excel used DDE. The maintenance(1000,1) changes from the default OLE back to DDE. If done in a script window or on a reset trigger somewhere, it should work fine with the MTEI. You only have to run the command once. Until you close Flexsim, it should still be in force."

Thank you Jeff for this detailed answer.