Open a file from vba code

  • Thread starter Thread starter Ambarish
  • Start date Start date
A

Ambarish

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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Print Files from Query Results 0
Opening a list of Excel files and run a macro in each 17
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Possible to pass a variable to Excel from command line/short cut? 2
Don't want to hard-code file name in macro 3
What are the steps to fix damaged MDF files in SQL Server? 0
Open a word mail-merge document from Excel VBA 1
Extract data from Oracle 3

Back
Top