Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can an addin save variables or arrays to a workbook
I have an addin that when run, it sorts through a Master worksheet of items
we will be purchasing and creates two sets of new worksheets: Set 1 - worksheets sorted by column MFG(manufacturer); this worksheet has only items that have a similar value in column A in the master worksheet. These are formatted as Purchase Orders Set 2 - worksheets sorted by column Room #; this worksheet has only items that have a similar value in column B in the Master worksheet As it is parsing the information, it creates a new sheet tab for every unique MFG, names the tab the same as the unique name, and then save that name into a collection of MFG tab names. Then it does the same for the rooms. I do this so the user can display only MFG tabs, only Room tabs, or only the Mastersheet(Hiding all others) I would like to save these two collections with the workbook, so when it is re-opened it will still have that information. I have created two workbook names which get saved with the workbook: JNum = 5421 JName = "MyJob" MasterWorkBook.Names.Add Name:="JobNumber", RefersTo:=JNum MasterWorkBook.Names.Add Name:="JobName", RefersTo:=JName Is this the best way to do this? And is there a way to save arrays, collection, UDT's, or classes??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Before Save w Addin | Excel Programming | |||
Variables and arrays | Excel Programming | |||
Save & Install AddIn with VBA | Excel Programming | |||
save file as addin programatically | Excel Programming | |||
Arrays: querying with two variables, why doesn't it work? | Excel Programming |