View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Executing PL/SQL in Excel

Use ADO.
Create an ADO.Connection, connect to your Oracle database and use
Connection.Execute strPLSQL

Does your code return any records or values? Does it take any parameters?

Tim

--
Tim Williams
Palo Alto, CA


"scos00" wrote in
message ...

Hi,
Anyone know if it is possible to execute Oracle PL/SQL code from within
Excel VBA code?
Thanks.


--
scos00
------------------------------------------------------------------------
scos00's Profile:

http://www.excelforum.com/member.php...o&userid=28264
View this thread: http://www.excelforum.com/showthread...hreadid=491805