TM1 Forum

I came across the old TM1Web Guide (the Applix branded docs) and it had a section on Creating your own toolbars in TM1Web. The heading is under "Developing Excel VBA Applications for TM1 Web". The issues are

1) When I search the IBM docs for 9.4 I get nothing returned. Is this feature no longer supported?

2) Kind of tied, when I search for the TM1WebToolbar.xla file that is called out in the docs I cannot find it on my machine or the development server.

After reading the older doc it seems to have some interesting possibilities for something I am currently working on, but it seems to have fallen off the map. Can anyone point me in the right direction?

George Regateiro wrote:I came across the old TM1Web Guide (the Applix branded docs) and it had a section on Creating your own toolbars in TM1Web. The heading is under "Developing Excel VBA Applications for TM1 Web". The issues are

1) When I search the IBM docs for 9.4 I get nothing returned. Is this feature no longer supported?

2) Kind of tied, when I search for the TM1WebToolbar.xla file that is called out in the docs I cannot find it on my machine or the development server.

After reading the older doc it seems to have some interesting possibilities for something I am currently working on, but it seems to have fallen off the map. Can anyone point me in the right direction?

This one has me scratching my head; I'll have to take a look at the old copies of the documentation to see if I can find that just out of curiosity. But certainly with Web as it exists in 9.0 onwards (the only versions that I have any experience of), "Developing Excel VBA Applications for TM1 Web" is a contradiction in terms. As Lotsaram put it quite succinctly recently:

lotsaram wrote:You have to remember that TM1 Web is NOT Excel it is html. No VBA or ActiveX controls are supported (with the exception of action buttons). The documentation may be sketchy on many things but it is pretty clear on this.

I was somewhat disappointed when I saw what Web could, and more importantly couldn't do (a disappointment that some may say hasn't really departed), but when I started playing around with it and figuring out how it worked I realised why (most of) the limitations are what they are. This, I'm afraid, is one of them.

I was also very suprised since I live in web all day long and have given out the no VBA reasoning alot.

Here is the link

http://download.boulder.ibm.com/ibmdl/p ... -tm1w.pdf

Though looking at the link I am even more confused since it appears on closer examination that it comes from version 8.4.5, but like Alan stated web would not have been around.

I am currently on 9.4 and just stumbled across this while looking for something on google, but that is the only place I can find any reference to TM1WebToolbar.xla filename.

George Regateiro wrote:Though looking at the link I am even more confused since it appears on closer examination that it comes from version 8.4.5, but like Alan stated web would not have been around.

No, I didn't say that; I said that the 9.x versions are the only ones that "I have any experience of". I know that there were versions of Web in 8.x, but my recollection from the Forum postings of the time was that it was so slow as to border on the unusable. (How different things are now. )

George Regateiro wrote:I am currently on 9.4 and just stumbled across this while looking for something on google, but that is the only place I can find any reference to TM1WebToolbar.xla filename.

I've found it somewhere else, at least indirectly; in the 9.0 release notes:

is_document_1272_Tm1_9.0_ReleaseNotes.doc wrote:TM1 Web 8.4 allowed administrators to execute an Excel VBA add-in from the web client at login time. This functionality is not included in TM1 Web 9.0.

My guess is that the change in architecture in Web 9.0 (needed to make the thing run at a kinda-sorta decent pace as long as you don't ask too much of it) made it impossible to implement the VBA functionality as well. That's a guess, since I never had the questionable pleasure of using an 8.x version of Web and therefore don't know what made it tick.