Skip to Content
0

sap bo 4.1 . When i schedule report it saves in (.xlsx) but i need in (.xls)

Nov 09, 2016 at 01:10 PM

66

avatar image

sap bo 4.1 . When i schedule report , it saves in Microsoft Excel Worksheet (.xlsx) but i need in Microsoft Excel 97-2003 Worksheet (.xls))

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Kuldeep Ghosh Nov 09, 2016 at 04:25 PM
0

In the destination when you mention the name of the report, just mention %SI_NAME%.xls. See if that works

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Like this one.

sample.png (20.5 kB)
0
raghu nath Nov 10, 2016 at 12:30 PM
0

Thanks for quick response

File shows as xls and file type in xlsx

Thanks,

Raghunath


output.jpg (22.8 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

how .xlsx type is going to impact?

0
raghu nath Nov 11, 2016 at 06:33 AM
0

we are using macros , macros accepts only xls file

Show 1 Share
10 |10000 characters needed characters left characters exceeded

What does your macro look for .xls extension or Type of file? I dont know much about Macros, but I think they only look for file name and extension. Another suggestion would be to find a macro or script that can convert .xlsx format to .xls in excel.

0