Hi,
I have written few lines of codes for specific purposes. The codes are working when I am directly using it in a workbook by inserting a module and pasting the code, however when I am saving the file as an add in, I am not able to use it. After creating the addin I have added a new ribbon tab and assigned macros to the tab. The macros are not working when clicked on the icons in the Ribbon.
I have prepared the code to copy sheets from all workbooks in a particular folder and paste it in a new workbook, i.e. this basically combined two workbooks.
The example file is attached. I am not able to attach the UI File.
Please look into the GetSheets subprocedure stored in Module 6.
-Thanks in advance,
Pankaj
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
I have written few lines of codes for specific purposes. The codes are working when I am directly using it in a workbook by inserting a module and pasting the code, however when I am saving the file as an add in, I am not able to use it. After creating the addin I have added a new ribbon tab and assigned macros to the tab. The macros are not working when clicked on the icons in the Ribbon.
I have prepared the code to copy sheets from all workbooks in a particular folder and paste it in a new workbook, i.e. this basically combined two workbooks.
The example file is attached. I am not able to attach the UI File.
Please look into the GetSheets subprocedure stored in Module 6.
-Thanks in advance,
Pankaj
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !