I am new in Excel development. I would appreciate for your help in advance. My
problem is as follows:
I have written some macros in a worksheet. A group of these macros performs
some file collation task which are dumped some where on my hard drive. The path
of that specific folder is being fetched by Input box.
Active workbook, range, pivot cache, worksheet, range etc objects has been
used frequently in project. These macros are working well and performing the
required task without any problem while I run them from that workbook.
My problem is when I convert this workbook to an AddIn, I get error messages
as I am using active worksheet method in a macro to get the output which does
not appear in my AddIn. Being specific, I do not get any worksheet in my AddIn.
Questions about my problem are welcome. If necessary, I would paste my code
here.