Yes it's possible using VBA, the steps would be
1. Use the COM to create a list of marketIds you want in each tab
2. Write the marketIds to a text file in the following location, where [USERNAME] is your PC username, [PROFILE NAME] is the profile name in Gruss and [TAB NUMBER] is the tab number starting from index 0
- Code: Select all
C:\Users\[USERNAME]\AppData\Roaming\Gruss Software\BA_QuickPickList_[PROFILE NAME]_[TAB NUMBER].txt
eg a single tab using the default profile will look like
- Code: Select all
C:\Users\[USERNAME]\AppData\Roaming\Gruss Software\BA_QuickPickList_Default_0.txt
3. Write the number of tabs required to file location
- Code: Select all
C:\Users\[USERNAME]\AppData\Roaming\Gruss Software\BA_QuickPickListTabCount_[PROFILE NAME].txt
eg on default profile it will be
- Code: Select all
C:\Users\[USERNAME]\AppData\Roaming\Gruss Software\BA_QuickPickListTabCount_Default.txt
4. In Gruss settings, Options/preferences/quickpicklist markets select retain quick pick list
5. Whenever you write a new list of marketIds you can then send a -3 command to cell Q2 in the first sheet and then select the first market using -5
If you want to do this using multiple tabs just make sure you have enough tabs open to accommodate the maximum number of tabs/sheets required.
