Search results
16 cze 2019 · Try the ODBC driver from Oracle {Oracle in OraClient12_home1} instead of the driver from Microsoft {Microsoft ODBC for Oracle} - The exact name of the driver could be slightly different. Check in ODBC Administrator (the 32-bit version!)
8 lip 2022 · If you are a user of Oracle’s Smart View Excel Add-in, you may find yourself wanting to automate some of its data retrieval capabilities with VBA Code. This article will show you how to call some of Smart View’s built-in functions with VBA code.
This is Part 2 in a 2 part series on using Visual Basic 6 to connect to an Oracle database. In Part 1, I showed you how to use an ADO Data Control to make the connection. In this article, I show you how to use ADO Objects to make the connection.
18 mar 2023 · I cannot use BFILE or create directory stuff as my oracle database resides on UNIX and my PDF file is on local c:\ drive. Powerbuilder has a datatype BLOB. I am storing that PDF files into BLOB using fileread (filepointer,blob) after opening the file in stream mode.
13 mar 2023 · This tutorial explains how to use IF NOT logic in VBA to test if some condition is not met, including examples.
30 paź 2023 · IF…AND. IF…OR. IF NOT…. This article will demonstrate how to use the VBA If statement with And, Or and Not. When we us an IF statement in Excel VBA, the statement will execute a line of code if the condition you are testing is true.
This example explains how to use the VBA IF NOT statement to determine whether a particular Excel cell (cell A1) is empty or not. If it is, a message box will be used to display the appropriate message.
