I am creating a customized Excel 2007 Workbook using VS 2008 and .Net 3.5 using an Excel 2007 Workbook project (C#). I have a desire to use the custom workbook as a data editor which is attached to a Windows Forms application. The Forms application creates project data stores in Access 2007 and places the store into a project directory. The project directory is in a location defined by the end user and can be anywhere on the local computer.
My plan is (was) to copy the custom workbook to the project directory and load that copy when the user clicks a forms button requesting to edit data. All works well if I do not use a copy of the workbook (the workbook located in my VS Excel Workbook project), but if I copy the workbook to the end-user's project directory, the workbook customization fails to be loaded.
I have NOT "deployed" the Excel project, as I am still in the development and testing phase (actually a Proof-Of-Concept phase). I have tried copying all the Excel 2007 Workbook project files from the bin directory into the end-user's project directory and then launching the workbook, but I still get the same problem.
Specifically, when I load (double click) the a copy of the workbook that resides in the end-user's project directory, I get a dialog box stating "The customization assembly could not be found or could not be loaded...". The Details of the dialog box shows the ThisWorkbook.Initialize() mentod failing. The details also does show the failing line of code, completed with the correct full path and filename of the source code file.
I am looking for ideas on how I can proceed with using the worksheet as my data editing form. Does anyone have ideas on what is required to get the workbook copies to run properly?
Thanks