MaBUa

Excel spreadsheet SORT method

Discussion created by MaBUa on Nov 1, 2012
Latest reply on Nov 2, 2012 by MaBUa

Hi All,

can you please help me?

I modify one old tutorial script from mentor Graphics (ExcelCompList.vbs..... Author: Toby Rimes...about 2007).

It generates an Excel file with list of used components and their coordinates, partname and so on.

I added a short subroutine which select all the cells which need to be sorted (see on the picture).

I need to SORT the table now... 1.side column and second past PARTNUMBER column.

Can somebody help me with the rest of the vbscript?

Many thanks

Martin

Attachments

Outcomes