topic How to use the function EXEC_SQLCMD_MSQ in Excel? in Application Development and Automation Discussions

How to use the function EXEC_SQLCMD_MSQ in Excel?

Former Member — Wed, 12 Jul 2006 08:03:46 GMT

Hi Friends,

can anyone explain how to use use this function EXEC_SQLCMD_MSQ in Excel to get the result.

I have written excel macro to use this function, statement like "Select * from t001" but the function doesn't reply any value.

My objective is to pass the (any, generalised)

sql statment to this function and get the result in Excel file.

Please give the solution for this.

Thanks

Shankar

Former Member — Wed, 12 Jul 2006 08:11:59 GMT

Hello Shanker,

The Fm EXEC_SQLCMD_MSQ is used in report RSMSQ020.

U can do the same in ur report.

If useful reward the points.

Regards,

Vasanth

Former Member — Wed, 12 Jul 2006 08:22:46 GMT

Hi vasanth,

But i didnt find out the report RSMSQ020.

please help me.

Shankar

Former Member — Wed, 12 Jul 2006 10:18:36 GMT

hI,

Does the parameters have correct type specified?

Also check the return value of sy-subrc.