I have a need to export my dimensional information to excel. I have been able to do that but I notice that It will only let you choose a single alignment prior to exporting my data. Some of my dimensions are going be taken from different alignments. How can I overcome this problem with out having to output all my dimensions several times in each of the necessary alignments? I need to do this without the Advantage of Datapage.
Exporting Dimesnions Question
Collapse
X
-
Exporting Dimesnions Question
Last edited by rerun_lives; 08-17-2007, 03:04 PM.sigpic
Cold Beer MMMmmmm........
Dell Precision T5400
Windows 7
B&S XCEL
WENZEL LH1512
PCDMIS 2011 MR1Tags: None
-
Originally posted by rerun_lives View PostI have a need to export my dimensional information to excel. I have been able to do that but I notice that It will only let you choose a single alignment prior to exporting my data. Some of my dimensions are going be taken from different alignments. How can I overcome this problem with out having to output all my dimensions several times in each of the necessary alignments?sigpic
Originally posted by AndersII've got one from September 2006 (bug ticket) which has finally been fixed in 2013.
Comment
-
Export whatever you want directly to a .TXT file using the Insert/File I/O Command/Writing Commands. Then pull the .TXT file into Excel.
Jan.***************************
PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.
Comment
-
go to the users area and scripts you have to register to download them but it is no big deal. You may also have to change the version of pcdmis you use in the excel file. Make a copy of it.sigpic
if you had soap on a rope it would be tied to yer ankle
Comment
-
The way I do this is that I do my alignments and dimensions. Then I open the file and append whatever dimensions I need to the text file. Then I close the file. Then I go through my next alignments and do the same thing. This always gives me data in the latest alignment.
Sorry, but I think I still not get what the issue is.... Yes, muddy.... Hey, it's almost Miller time!
Jan.***************************
PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.
Comment
-
Still not working!!!
Originally posted by fmred79 View PostJust type this on the end of the program
And that's it
CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
FUNCTION/LoadExcel,SHOW=YES,,
STARTSCRIPT/
ENDSCRIPT/
GOTO/C2
Was hoping this issue would be resolved by now. I am using 4.1 and I have downloaded the pcdmistoexcel_auto.zip file from the Wilcox website and followed the instructions of where to copy the files (C: drive) but when I go to try and type the above command line it will not let me do it. I have to use the "Insert\Script" command from the Insert dropdown menu and put a script in manually and then try to change it to match the line above. It refuses to let me type in the line "ENDSCRIPT/". I tried running it anyway without the line and it WILL NOT WORK, any other suggestions? I must be missing something - what is the "GOTO/C2" Line all about as well?sigpic
Cold Beer MMMmmmm........
Dell Precision T5400
Windows 7
B&S XCEL
WENZEL LH1512
PCDMIS 2011 MR1
Comment
-
You NEVER type in the ENDSCRIPT/ line. PC-DMIS will put that there automatically after you finish the first time run of the script.
I have no idea what can cause your script problem. You will have to be more specific with what the message is that it returns when it poops out..
Jan.***************************
PC-DMIS/NC 2010MR3; 15 December 2010; running on 18 machine tools.
Romer Infinite; PC-DMIS 2010 MR3; 15 December 2010.
Comment
Related Topics
Collapse
-
by adamclinardIs there a way to export data reports from dmis straight to an excel file?
-
Channel: PC-DMIS for CMMs
11-21-2007, 01:53 PM -
-
by JVau425033I need to export to excel, but I dont want the whole report only the actual measured feature into a set cell. Does anyone know the string code?
-
Channel: PC-DMIS for CMMs
01-06-2012, 10:17 AM -
-
by NMC_CMMI don't know if this is possible, or even worth doing, but I figured I'd ask anyway. We like to do 100% check on all our electrodes before they go to...
-
Channel: PC-DMIS for CMMs
06-20-2008, 05:02 PM -
-
by thomasswayaRequesting the procedure to export data from PC-DMIS into a file that can be copied and pasted into Excel.
Thank you,
...-
Channel: PC-DMIS for CMMs
06-11-2010, 10:28 AM -
-
by Slug DawsonHello all,
We run Excel 2007 on our cmm computer. It has compatiability mode to allow the software to open up previous version of Excel spreadsheets...-
Channel: PC-DMIS for CMMs
09-28-2010, 06:12 PM -
Comment