dbTalk Databases Forums  

Excle & VBA function library dll names

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Excle & VBA function library dll names in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Richard R
 
Posts: n/a

Default Excle & VBA function library dll names - 11-07-2003 , 03:49 PM






Quick questions:

I want to use VB ans Excel functions in the cube I'm building. However
becuase SQL Server / Analysis services was loaded onto the machine before VB
and Office, the dlls containing the function libraries were not
automatically registered.

1) What are the .dll names I need to register for Excel functions VB
Functions, and VBA and VB 6 functions?
2) This machine atually has .NET and C## installed rather than VB6. Anyone
been brave enough to try using C# functions? (How one would even register
the assembly to start with is a wild question!)

Thanks in advance,


Richard




Reply With Quote
  #2  
Old   
Coen
 
Posts: n/a

Default Re: Excle & VBA function library dll names - 11-13-2003 , 03:53 PM






Richard R wrote:

Quote:
Quick questions:

I want to use VB ans Excel functions in the cube I'm building. However
becuase SQL Server / Analysis services was loaded onto the machine before VB
and Office, the dlls containing the function libraries were not
automatically registered.
As far as I know, the VBA function libraries are installed with AS. Just
tryb to create a calculated measure with VBA!Now() en see what it does.
i've spent some time on the same problem and then foud out was there all
the time.

Cheers,

Coen



Reply With Quote
Reply




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

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.