B
Bill Johnson
I have an xls (2003) excel spread sheet that calls data from another
application (DDE) like this:
=RSLINX|'PC2'!'ANA[201]' and like this =Rslinx|'EC2'!ACT01
This is standard DDE, and in 2003 and earlier it works. The problem is that
when I save the spreadsheet as a macro enaabled file in 2007 it replaces
=Rslinx|'EC2'!ACT01
with
=Rslinx|'EC2'!_xlbgnm.ACT01
And it only does it for my topics that contain the letters/word "ACT", none
of the others.
Anyone know what is going on here? Is there a way to get Excel to stop
concatenating the "_xlbgnm." into my call?. If I delete the "_xlbgnm." from
the call, save, and reopen it comes back.
application (DDE) like this:
=RSLINX|'PC2'!'ANA[201]' and like this =Rslinx|'EC2'!ACT01
This is standard DDE, and in 2003 and earlier it works. The problem is that
when I save the spreadsheet as a macro enaabled file in 2007 it replaces
=Rslinx|'EC2'!ACT01
with
=Rslinx|'EC2'!_xlbgnm.ACT01
And it only does it for my topics that contain the letters/word "ACT", none
of the others.
Anyone know what is going on here? Is there a way to get Excel to stop
concatenating the "_xlbgnm." into my call?. If I delete the "_xlbgnm." from
the call, save, and reopen it comes back.