Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas?
Accept Labels in Formulas? Accept Labels in Formulas?
Accept Labels in Formulas?
Go Back  Xtreme Visual Basic Talk > > > Accept Labels in Formulas?


Reply
 
Thread Tools Display Modes
  #1  
Old 07-31-2008, 08:43 AM
MillAccept Labels in Formulas? Mill is offline
Ultimate Contributor

Retired Moderator
* Guru *
 
Join Date: Feb 2000
Location: Michigan, USA
Posts: 2,643
Default Accept Labels in Formulas?


Is there an equivalent to this for the new version of Excel?

I have a program that one of my users is trying to use, and my program (developed over the past few years with the older versions of Excel) uses labels in formulas quite a bit.

I can modify some things to get around it, but the "AcceptLabelsInFormulas" property of the workbook object isn't there anymore, and my program uses that when it does exports.
__________________
"The face of a child can say it all, especially the mouth part of the face." - Jack Handey
Reply With Quote
  #2  
Old 07-31-2008, 08:56 AM
Mike Rosenblum's Avatar
Mike Rosenblum Mike Rosenblum is offline
Microsoft Excel MVP

Forum Leader
* Guru *
 
Join Date: Jul 2003
Location: New York, NY, USA
Posts: 7,848
Default

Hi Mill,

Yes, this feature has been removed in Excel 2007. It was deemed too prone to accidents -- if you rename or move a label, all heck can break loose. I strongly prefer to use Range Names instead, and always kept this feature turned off in the past. So I personally concur with their decision (for whatever that's worth!).

The AcceptLabelsInFormulas method is a hidden member now, which you can expose in VBA by showing hidden members. From .NET, I don't think there's a way of exposing it, but you could probably call it via late binding. There's no reason too, however, because in the Excel 2007 object model it always returns 'False' and you cannot attempt to set it to 'True' or you'll get a run-time error. (In Excel 2003 and below you could set it to true.)

Anyway, I would just stick to Range Names, I think they're better anyway.

(Btw, are you using .NET now, or did you post in here by accident?)

Mike
__________________
My Articles:
| Excel from .NET | Excel RibbonX using VBA | Excel from VB6 | CVErr in .NET | MVP |
Avatar by Lebb
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas? Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas? Accept Labels in Formulas?
Accept Labels in Formulas?
Accept Labels in Formulas?
 
Accept Labels in Formulas?
Accept Labels in Formulas?
 
-->