Adding Data to an existing spreadsheet from SQL Server

M

mbailey256

I know I could create a VB function to perform the following, I just
wanted to see if there were any built in features of Excel 2007 that
would be faster and more accessable to my users.

We regularly need to get additional data from SQL server for an
existing spreadsheet. An example would be a spreadsheet with VendorID
and InvoiceNumber columns and we need the PO column populated.

Is there a way within excel to pass the VendorID and InvoiceNumber
into the script below?

select ponumber from INVOICES
where vendornum = VendorID
and invoicenum = InvoiceNumber

Thanks,
 
Top