If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register or Login
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Excel Add-In Require Files

I am trying to make an Excel add-in. To make this add-in work, I need certain files to be in a certain directly in the C drive. I was wondering how I can put these files into that directly when I publish the add-in. That way, anyone who installs the add-in, will have the correct files in the correct directly.

Re: Excel Add-In Require Files

I am not sure how to actually copy the files to the user's computer. I want them to be in the project, so when an installation exe is created, they are included as well. But I want them to be moved to the correct directory (I assume the easier way to do this would be ribbon_load method).

Re: Excel Add-In Require Files

Not that familar with the Excel addin project, so I created an addin project and added a class library project to the solution (the solution contained ExcelAddin1 and Excel.Text projects). In the ExcelAddin1 project I set a reference to the Excel.Text project.

To publish, I...
1) Made a Publish folder on my harddrive (this could have been http, ftp, network share, or local). I made it on my local drive.
2) Clicked on Publish "ExcelAddin1" menu item.
3) When prompted for the "Specify the location to publish this addin", I choose the local file path (C:\Documents and Settings\hawcor\My Documents\Visual Studio 2008\Projects\ExcelAddIn1\Publish\).
4) Click Next
5) Under "What is the default installation path on end user computers?", I selected "From a UNC path or share" (I left the optional unc path edit box blank)
6) Click Next, click Finish

Once published, I navigated to the C:\Docu....\...ExcelAddin1\Publish folder and ran Setup.Exe.
When you run setup, it just registers the addin from the folder you run setup from.

Next Open Excel. You'll see a message box with "Hi" and "Bye" when closing Excel. If you click Excel Options and the Addin tab, you'll see that the addin was registered from the folder above (e.g. "file:///C:\Docu....\...ExcelAddin1\Publish\ExcelAddin1.vtso")

To uninstall the addin, go to add/remove programs and select "Remove" for ExcelAddin1.

At any rate, it successfully published and included the Excel.Text.dll assembly alone with the ExcelAddin1.dll assembly.