Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel XML - force sort when XML spreadsheet file is opened

Status
Not open for further replies.

rss0213

Programmer
Jul 12, 2007
58
US
Hi, I'm not sure if this is the correct forum, but it IS related to MS Excel...

I have an XML Spreadsheet that I'm creating on the mainframe and sending to my users. I would like for the data in the rows (which I'm creating on the fly with a COBOL program on the MF) to be sorted when the user opens the XML attachment (which opens in Excel). I have the following tags in the XML:

Code:
  <Sorting xmlns="urn:schemas-microsoft-com:office:excel">
   <Sort>Delivery Method</Sort>
   <Sort>Customer Name</Sort>
  </Sorting>

Delivery Method is column 2, Customer Name is column 1.

So when I select the data range and click 'Data', 'Sort...', it defaults to this sort sequence, but I would like for it to sort the data when the spreadsheet is opened instead of the user having to do this. Is there a way to "force" this sort operation to happen when the attachment is opened?

Thanks!
Scott
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top