954,535 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Trying to run Showcase thru a Macro built in VB

Greetings!
I am a relative newbie to VB programming and have built a macro that performs multiple functions within excel but am now trying to link ShowCase STRATEGY 4.1 to it. I am attempting to figure out how to have an excel file run a ShowCase Query--an application I have no experience with other than clicking the run button. I have added-in the ShowCase Add-in but thru trial and error haven't been able to run the query. It appears as though the Showcase query that I need to run on a daily basis has a prompt that requests a specific date or two (but a quick formula could be used to extract this/these dates on a daily basis however) as well. Any assistance that you could provide me would be greatly appreciated.
Thanks,
Walt

WaltFales
Newbie Poster
2 posts since Jul 2004
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You