Add-in Help

[jamtay317]

Hello and thank you for reading my post! I am building an addin that will all me to create the same pivot table many times over, which is great. Where I run into a problem is, I would like to be able to chance the default Fields according to each person that uses is this add in. So I've created a form that will allow the user to choose those defaults.

Now My Problem, where can I store these default settings? so as each person opens the csv files the add in will look at the correct field list.

thank you for your help.

 

[Andrew Poulsom]

You can store them in the Add-In's worksheet. To see it temporarily change the Thisworkbook's IsAddin property to False.

 

[jamtay317]

thank you! that is what I needed!