View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tecnet Tecnet is offline
external usenet poster
 
Posts: 1
Default Creating cub file using VBA

I am trying to figure out how to create programatically cube file out of .txt
file or acess table. I read that I need to install add-in for SQLServer
Analysis Services. So I installed but I do not know how to make use of it in
VBA.

My problem is that I need to create more than hundred cube files weekly -
it's really time-consuming.

How can I do this ? Maybe sample code ? Any help appreciated !

Thanks in advance
Tecnet