Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default [GetMacroRegId}

I never noticed this before, but when I assign an XIRR function using code
below:

rng.Formula= StringContainingXIRRformula

When running within Excel, it appears that Analysis Toolpak spits out, e.g.:

[GetMacroRegId] 'XIRR' <
[GetMacroRegId] 'XIRR' - '875692121'

Can that be disabled?
Does not appear if automating Excel from VB 6.

This is in Excel 2003, have not tried in other versions.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 269
Default [GetMacroRegId}

Clarification and Follow-Up,
----------------------------------
When using code such as that given below, the following two lines are
output in the
Immediate window as soon as .Formula is executed.

[GetMacroRegId] 'XIRR' <
[GetMacroRegId] 'XIRR' - '875692121'

With rngXIRR
.Formula = sXIRR ' SXIRR has a valid XIRR formula
.NumberFormat = "0.000%"
.Name = "'" & sThisSheet & "'!" & "WattEver"
End With

Using Google, I found postings indicating that such statements are produced
by Debug.Print in the Analysis ToolPak
If true, all I can say is @$@$%@!!@#.

The suggested solution was to crack the password for the .XLA and modify the
code.
If the password for an XLA is as easy to crack as that of an .XLS, this
would be doable.
MSFT should fix this themselves if the onlty problem is the stupidity of the
developers leaving in such code.
Guess they never heard of comments or conditional compile.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
[GetMacroRegId] in Immediate window bigHatNoCattle[_2_] Excel Programming 18 March 26th 07 05:53 PM
getMacroRegId displayed in Immediate window bigHatNoCattle[_2_] Excel Programming 2 February 11th 07 01:50 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"