How to use the function EXEC_SQLCMD_MSQ in Excel?

[Former Member]

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]

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]

Hi vasanth,

But i didnt find out the report RSMSQ020.

please help me.

Shankar

[Former Member]

hI,

Does the parameters have correct type specified?

Also check the return value of sy-subrc.