Open a file from vba code
 

Hi,
i am writing a piece of code where user is prompted to browse and
choose a .sql file. i am taking the file location in a variable.
Now, i want to connect to the database (Oracle). Once I am connected
to Oracle, instead of writing the query I want to give the filename
which I have stored in a varaible (So the file will open and the query
will be run)

How do I open the file stored in the variable?

Open a file from vba code
 

Where is the code that you want to adapt?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ambarish" wrote in message
...
Hi,
i am writing a piece of code where user is prompted to browse and
choose a .sql file. i am taking the file location in a variable.
Now, i want to connect to the database (Oracle). Once I am connected
to Oracle, instead of writing the query I want to give the filename
which I have stored in a varaible (So the file will open and the query
will be run)

How do I open the file stored in the variable?