Updating database asp
I've heard reports that when the add-in is on a network folder, this does work.
I don't know if it works in all cases though and would be pleased to get your feedback on that (use form at bottom of page or send me an email).
I did this because in this case you will confuse your user of he does not get "immediate" feedback on the result.
The code that does the actual updating is wrapped in a class module called "cls Update", see the entire code below.
To work around this problem, the add-in's "Is Addin" property is temporarily set to False, then the web query is inserted and the property is set back to True.
The updating process works as follows: Note: I've tried whether marking the add-in file as read-only would enable the code to delete the file itself, but this appears not to work when the file is on a local drive.
What the user sees in the security dialog after clicking the Options button on the message bar.
Also, it appears Excel 2007 does not allow inserting a webquery in one of the add-in's worksheets.
So in my App_Data folder I have an title "Device Database." In that database I have three tables: "Galaxy Nexus", "Hercules" , and "Ruby" I am trying to import four cells from each imported excel sheet to their respective tables. For example, get the value in the cell and use that to update the table: msdn.microsoft.com/en-us/library/ms177523Im kinda confused about this.