I am having an issue with a form I use to input data from a table into an Excel worksheet. It works fine in either 2000 or 2003 but when I tried using it on the new laptop my company sent me which has Office 2007 the functions only return a #name? error. I tried recreating the form from scratch after converting the database from 2003 to 2007 but I get the same error. Here is an example of the function I am trying to use:
=DDESend("Excel","Sheet1","r11c2",[Account_Name])
The form itself contains around 50 of these commands. If it is run in one of the older versions of office without an Excel document open, it will ask to open the file but in 2007 it just throws the errors without even a prompt regardless if the template is open or not.
Any help would be greatly appreciated.
=DDESend("Excel","Sheet1","r11c2",[Account_Name])
The form itself contains around 50 of these commands. If it is run in one of the older versions of office without an Excel document open, it will ask to open the file but in 2007 it just throws the errors without even a prompt regardless if the template is open or not.
Any help would be greatly appreciated.