Excel automation Save As xls instead of xlsx
alsol
Member Posts: 243
We are using Excel automation to generate a daily item status report. By default the file that is generated is in the new xlsx format. But we would like to save the file as xls. Is this possible with automations?
For the automation we are using Microsoft Excel 12.0 Object Library, maybe we need an older library?
For the automation we are using Microsoft Excel 12.0 Object Library, maybe we need an older library?
0
Comments
-
Hi Alsol
You can use SaveAs command. Have a look here for details:
http://www.rondebruin.nl/saveas.htm
Hope this helps
Thomas0 -
Hi Thomas,
Cool, the fileformat expression was exactly what I was looking for. Thanks!
Felix0 -
Welcome!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions