I tried a follow a few other posts here to get me this far, but I am stuck right now and hoping someone can give me a hand. My goal here is to connect to a SQL server (accomplished), run a select statement against SQL that ultimately uses a parameter passed by the user through an inputbox (which is right now hard coded in my SQL) and then return the values of the select statement to my spreadsheet. I finally think I have 1 and 2 accomplished, but I am struggling on getting the data back to Excel. Based on the code below, A1 is turning out to be "prod_order" instead of the value returned from the SQL, same with B1 and C1.
Below is the code I have so far.
Please Login or Register to view this content.
Bookmarks