Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

vbs, Excel and Oracle

  Asked By: Ava    Date: Nov 30    Category: MS Office    Views: 813
  

I want to create a vbs that will do the following:
Create an Excel object

Create a workbook with 21 worksheets (all named)
and for each worksheet, perform a query of an Oracle DB and populate
the worksheet (21 queries for 21 worksheets)

Finally do some post processing on the worksheets looking for
anomalies in the data, do some summarizing, etc. (stuff Excel does so
well)

My original thinking is that I should be able to do this all from
within a vbs file but I may be misguided.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Horia Ahmed     Answered On: Nov 30

I do this every day...
actually, some of this is done during the night.
but, yes, it's possible.
The biggest hurdle you'll have is getting the right
connect string to get your Excel to talk to your
Oracle database.
When I get to work tomorrow, I'll copy out my
"connect" sub and send it to you.

 
Didn't find what you were looking for? Find more on vbs, Excel and Oracle Or get search suggestion and latest updates.




Tagged: