LinkBack URL
About LinkBacks
Hello all.
Can someone tell me how should i code the WorkBookOpen() event to connect excel to my Oracle database? I know how to do it using OO4O but not with ODBC.
Thanks in advance for any help provided.
Octavio
Hello all.
Can someone tell me how should i code the WorkBookOpen() event to connect excel to my Oracle database? I know how to do it using OO4O but not with ODBC.
Thanks in advance for any help provided.
Octavio
Have you tried to put it in a macro
called "Sub Auto_Open()"
instead ?.
This macro is called direcly when open the workbook.
It works as same when closing the workbook
"Sub Auto_Close()"
Best Regards
Tony
Hello Octavio,
This site may prove useful for how to connect Oracle with Excel. Have a look and post back if you have anymore questions or need help.
http://www.marcel-jan.nl/oracle/tips...ips and Tricks
Sincerely,
Leith Ross
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks