DDE Send functions from Access 2003 not working in Access 2007


Joined
Feb 25, 2013
Messages
1
Reaction score
0
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top