View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ambarish Ambarish is offline
external usenet poster
 
Posts: 1
Default 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?