Adding a sheet to a Addin

[starnold007]

I have a Addin that stores information on different sheets. I want to export the sheets to be able to have a back up of the information. I have been able to 'export' these sheets but I have been unable to 'import' them into my addin. I have been trying to use

masterItem - variable holding the name of the sheet selected from a Userform.

(prompts user to open the backup file he/she wants to import)

filename = application.getopenfilename..........
workbooks.open filename:=filename

Sheets(masterItem).Copy Before: = Workbooks("myaddinsname.xla).Sheets(4)

fyi-- i also want the new imported sheet to be xlSheetHidden.

I think my problem is that addin's are not a part of the Workbooks Collection???


Any help would be appreciated.

 

[tusharm]

Untested for obvious reasons:

Sheets(masterItem).Copy Before: = ThisWorkbook.Sheets(4)

That said, it is not a good idea to update worksheets in an add-in. You should think of an add-in as "compiled code." And, one does not store data in compiled code. If you have data that match the code in a template, create a separate workbook that contains the data. Then, make sure that this workbook and the add-in always "travel together."