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!

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!

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!