View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graham Haughs Graham Haughs is offline
external usenet poster
 
Posts: 49
Default Excel code for exported spreadsheet

We have an online recording system, which is not Excel, but some of the
reports can be exported to an excel spreadsheet. If excel is not open it
just opens it and saves the data. I can create a procedure which then
handles the data to do some data sorting etc and this has been tested
and works fine. What I would like ideally is the procedure to be
available on the spreadsheet to which the data is exported. I don't want
the procedure to start automatically, I want it to be avaiable so that
we just click a button or run a macro and it is fixed. Is that best on a
menu or is there any better way of creating this on the start up sheet?
Hope this is understandable.

Regards
Graham Haughs