Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

xlbgnm in remote data

124 views
Skip to first unread message

Johnson@discussions.microsoft.com Bill Johnson

unread,
Apr 7, 2009, 1:24:01 PM4/7/09
to
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.

aureliebonvillian

unread,
Apr 22, 2010, 3:21:59 PM4/22/10
to
Did you every find the problem?

Bill Johnso wrote:

xlbgnm in remote data
07-Apr-09

with
=Rslinx|'EC2'!_xlbgnm.ACT01

Previous Posts In This Thread:

On Tuesday, April 07, 2009 1:24 PM
Bill Johnso wrote:

xlbgnm in remote data

with
=Rslinx|'EC2'!_xlbgnm.ACT01


Submitted via EggHeadCafe - Software Developer Portal of Choice
Book Review: C# 4.0 In a Nutshell [O'Reilly]
http://www.eggheadcafe.com/tutorials/aspnet/6dc05c04-c7f9-40cc-a2da-88dde2e6d891/book-review-c-40-in-a.aspx

0 new messages