ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SAP download Web page to XLS (https://www.excelbanter.com/excel-programming/397102-sap-download-web-page-xls.html)

Cathy

SAP download Web page to XLS
 
We recently started using SAP. When we download reports we request an .xls
format... they say they are Excel Format in Explorer, but when you do a 'Save
As', it shows the type as 'Web Page'.

I have written a macro to reformat these reports. My hope was to open them,
run the macro and close them with their original name. I can't seem to
change the format from Web to .xls without programming in a name. Is there a
way to just change the type?

Thank you,
Cathy


All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com