| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I run an external command from within VBA
Hi!
How do I run an external command from within VBA? I want to execute a sql command from within Excel and take the SQL output an import it into an Excel sheet for further processiing? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I run an external command from within VBA
This is a long topic. I suggest that you look at ADO connections.
Look for the following ADO command execution ADO recordset objects Excel CopyFromRecordset method Good Luck. -- Stewart Rogers DataSort Software, L.C. "k. moran" wrote: Hi! How do I run an external command from within VBA? I want to execute a sql command from within Excel and take the SQL output an import it into an Excel sheet for further processiing? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I run an external command from within VBA
Hi, please use Shell() statement to execute external commands.
"k. moran" wrote: Hi! How do I run an external command from within VBA? I want to execute a sql command from within Excel and take the SQL output an import it into an Excel sheet for further processiing? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command code ( GOTO command) in formula | New Users to Excel | |||
| Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
| Excel to load COMMAND and type a Run Command? | Excel Programming | |||
| starting an external program with a command line | Excel Programming | |||
| starting an external program with a command line | Excel Programming | |||
Linear Mode
