External calls from Excel

S

smartchick

Hi,

I have a template in Excel that I want to be filled with data from several
different queries and all is well, but I want to send in a parameter called
CompanyID.

the commandtext look like this:
..CommandText = Array("SELECT * FROM `C:\PaycheckData`.`3-2CurBMProfile`")

and the query had the [] in it to stop and ask for the parameter. Help!
 
Top