Can a macro be run to install an add-in? Here is my problem:
I use the SendWithLotus function to send my workbook through the network as an attachment in the e-mail. If the user opens the file from the e-mail and tries to run any of the macros, it attempts to open the macro from the original location of the workbook; that is, instead of running Macro(), it tries to run C:\\Documents And Settings\My Project.Macro(), which causes an error since the book is already opened.
Can anyone assist me in fixing this problem so that the macro assignments always run the macro in the open workbook?
Thank in advance for any assistance!
I use the SendWithLotus function to send my workbook through the network as an attachment in the e-mail. If the user opens the file from the e-mail and tries to run any of the macros, it attempts to open the macro from the original location of the workbook; that is, instead of running Macro(), it tries to run C:\\Documents And Settings\My Project.Macro(), which causes an error since the book is already opened.
Can anyone assist me in fixing this problem so that the macro assignments always run the macro in the open workbook?
Thank in advance for any assistance!