PCDMIS To Excel !

[Donna]

Before I go into too much detail...Does Anybody know anything about
importing results from PCDMIS into excel ? I ask because I can't find
a single post concerning it which surprises me. PCDMIS is a CMM
software package and I have imported the measurements into Excel. I
have got the data in OK but have 2 questions.

1.) You write a script in VB which is similar to the Excel VB that
contains a line of:-
oxl.Workbooks.Open "FilePathAndName",3,False
This opens Excel and the file but does not open any files that are in
the Excel StartUp Directory (ie the Personal.xls or equivalent). I
don't know what the 3,False does - I've tried changing them but with
no success (in fact I couldn't see any change in anything!). Can
anybody help me out here?

2.)I will post if there are people who are familiar with what I am
tring to do as is concerns how you can import the information quicker.
A particular dimension will have a nominal, measured, upper tol,
lower tol, deviation, out of tol figure etc that I am importing
seperately which is quite slow. I was wondering if you could imprt all
data from a particular dimension in one go perhaps into an array or
something that would quicken up the process.

Thanks to anybody who can help. i have posted question 1 to a PCDMIS
forum but unfortunately haven't had any responses but it is a bit more
of a programming question really.

Donna

[pairoj1978]

I have the example file and VB file to crate Excel file after measurement with PC-Dmis. If you need , give me your e-mail address.

[Wayne Knazek]

I know this is an old thread, and might not get a reply, but . . .

I've used the test32 PC-DMIS to Excel VB file for years. But
never used in "in a program". I just open the Excel sheet. Run
my PC-DMIS program. And hit the download key in excel.

I've been trying to get this to work by editing in the INSERT BASIC code.
But it will not work.

Using the exact instructions in the Test32 "how to", the function does
not insert like it shows in the instructions.

I'm using V4.1. The file has been working fine for about 7 years.

Anyone have any insight as to how to get it to work in a program?

Thanks. Wayne

[cn2018]

Hi;
Can you send me the files ? Thank you.

Cn2018

[FDibbins]

Hi;
Can you send me the files ? Thank you.

Cn2018

what files?

Please start your own thread for this.