How do I run an external command from within VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
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

Special problem deleting a folder 2
Copy value from changing cells without VBA 1
Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Excel VBA in Citrix. 0
Open a word mail-merge document from Excel VBA 1
VBA code to run & wait for cmd line interface application 1
Reference to external program 5
using Forms and VBA within Excel 3

Back
Top