Jeff S
asked on
Microsoft Excel 2007 - "Parameters are not allowed in queries that can't be displayed graphically"
I am trying to pass a Stored Procedure through an Excel worksheet with the following SQL and getting this Error - "Parameters are not allowed in queries that can't be displayed graphically".
My code is this - EXEC cusExcelMTD, ?, ?
I have seen that I need to use VB to alter my Excel spreadsheet, but I have no clue as to how to do this or the coding. The two parameters I want to pass are "StartDate" and "EndDate". Can someone please lend me hand?
My code is this - EXEC cusExcelMTD, ?, ?
I have seen that I need to use VB to alter my Excel spreadsheet, but I have no clue as to how to do this or the coding. The two parameters I want to pass are "StartDate" and "EndDate". Can someone please lend me hand?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER