Exporting Dimesnions Question

[rerun_lives]

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.

[Stuart]

If you have Datapage, send it all the dimensions to DP, then Export to a file from DP. Import that file into Excel.

Stu

[Matthew D. Hoedeman]

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?

Send them to Datapage, then dump it out as a text file and pull it into Excel.

[Jan d.]

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.

[T Miller]

Why not just use one of the excel scripts

[rerun_lives]

Jan D. The problem is having a way to export the dimensions as a generic text file having the export reference more than one aligment using a single export. Clear as Mud?

[rerun_lives]

T Miller what Excel Scripts and where would I find them so I can look at them?

[T Miller]

http://www.wilcoxassoc.com/home.htm

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.

[Jan d.]

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.

[fmred79]

Just 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

[rerun_lives]

Still not working!!!

Just 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

Sorry Gang,
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?

[T Miller]

I could never type the endscript it shows up after the first run.

[Jan d.]

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.

[T Miller]

You may have to edit the excel file to be used with 4.1

[rerun_lives]

Here is the error message I am getting:

"Error on line 4 4 - OLE Automation Method Exception"

OK All you VB Experts Jump on in!