| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open file with code | Excel Discussion (Misc queries) | |||
| How to Open a file with the help of a code in Excel | New Users to Excel | |||
| VBA code to open and copy a file | Excel Programming | |||
| How to open a zip file from the code? | Excel Programming | |||
| VBA code to open file? | Excel Programming | |||
Hybrid Mode
