Prev: looking for a function that will populate opening a worksheet
Next: How do I use sumifs -
From: Aurelie on 22 Apr 2010 15:21
Did you every find the problem?



Bill Johnso wrote:

xlbgnm in remote data
07-Apr-09

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.

Previous Posts In This Thread:

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

xlbgnm in remote data
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.


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
 | 
Pages: 1
Prev: looking for a function that will populate opening a worksheet
Next: How do I use sumifs -