Home > IT Answers > Development > Executing a Stored procedure using Excel Macro
SQL Server Ask the Experts
2,585 pts.
 Executing a Stored procedure using Excel Macro
Excel macros, SQL, Stored Procedures, VBA
I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

Software/Hardware used:
ASKED: June 13, 2008  6:36 PM
UPDATED: June 13, 2008  8:14 PM
RELATED QUESTIONS
Answer Wiki:
The easiest way would be to setup a worksheet within your workbook as a work area. Setup some data imports which you can setup to auto refresh when the workbook is open. Then all you need to do is setup a macro to move the data you are looking for into the correct location.
Last Wiki Answer Submitted:  June 13, 2008  8:14 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.