 |  |  |  |  |  |  |  |
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
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
|
Similar Threads
- This Should be Easy for You Guys! (Linux Servers and Apache)
- Vb Runtime Files (Visual Basic 4 / 5 / 6)
- Why should someone go with a 939 over a 754? (Motherboards, CPUs and RAM)
- c:\searchpage.html --- mtwirl.dll -- Please help! (Viruses, Spyware and other Nasties)
- need help w/ CRON job for backups (*nix Software)
- XP Firewall & security (Windows NT / 2000 / XP)
- Accessing files that are not currently open and running VB macros in them? (Visual Basic 4 / 5 / 6)
- Overclocking 2600+.. help? (Motherboards, CPUs and RAM)
- Hijack this log - can't get rid of pop ups (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: In what Command i can control Hardwere.
- Next Thread: Dhtml
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
