PCDMIS to Excel Issue-DMIS closing Excel after export

[afenner]

Does anyone know how to keep PC-Dmis from closing Excel after exporting the dimensional results?

[Don Ruggieri]

Does anyone know how to keep PC-Dmis from closing Excel after exporting the dimensional results?

There are multiple programs to use Excel with PC-DMIS, which one are you using? When did you download it? Have you modified it at all?

[craiger_ny]

Is there an excel object .quit or any kill statements in the code? Post the code and I am sure someone can nail it right away.

[Don Ruggieri]

If you are talking about the Wizard, you need to open it with the VB editor. Go to the ProgressForm code, line 1272, you should see this -

Closing:
ExcelWorkbook.Save
ExcelWorkbook.Close
Set ExcelWorkbook = Nothing
ExcelApp.Quit
Set ExcelApp = Nothing

Comment out the 4 lines that actually do the closing -

Closing:
ExcelWorkbook.Save
' ExcelWorkbook.Close
' Set ExcelWorkbook = Nothing
' ExcelApp.Quit
' Set ExcelApp = Nothing


Whatever utility you are using, as Craiger_NY says, you should see something like the above.

[afenner]

I am using the wizard....I will try to edit it like Don has stated...I think I can do that...I'll keep ya posted....

Thanks guys

[afenner]

Well, I don't think it editing out the comments worked, unless I didn't do it correctly, which is highly possible.

Is that an apostrophe that comments out the lines? Or that little mark on the ~ button on the keyboard? I tried using both symbols, but neither seemed to work.

DMIS still closes Excel and every document in it, once I hit the finish button for the wizard.

It should be noted that I used Wordpad to edit the file. I'm going to now try it using VB Express. Maybe that has something to do with it.

The issue is still open

[Don Ruggieri]

Sorry, I left out some additional detail. First, it is an apostrophe.

When you are done editing, you need tobuild an executable from it. Then you need to place the executable into the Wizards folder, replace the existing one or make a new one (new name, new icon, etc.), your choice. You need to do all this with VB.

[afenner]

Yup, those seem like some important details to me

Thanks, I'll work on it..

[afenner]

I'm not sure how to build an .exe file out of it....is there a short version of the instructions for that? Can VB do it or do I need another program?

[Don Ruggieri]

In VB6, you go to File (on the menu) and about 2/3 of the way down you'll find a "Make .Exe" option.