Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File format conversion on server
I am producing office 2007 files (with no macros) directly on a webserver
from .net. I was then going to rely on users having the compatibility pack on their machines to convert to whatever version of office they have. My boss has now changed his mind and said that we should be able to give our users the choice of formats. Is there recommended way of programmatically converting from office 2007 format to say office 2003 format on a server????? Is OMPM using the ofc appropriate for this environment? regards, Richard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File format conversion on server
How about this: prior to actually creating the Excel file (assuming
that's the "Office 2007 files" you're talking about since you're posting to an Excel group), have the user select the format they want. Then use a conditional statement to save the Excel file in the format you want. Of course, this suggestions makes a lot of assumptions since you posted no code. For example I assume your using an Excel.Application object. Something like the untested code he Private Sub SaveBook(sVer As String) Dim e As Object Dim w As Workbook Set e = CreateObject("Excel.Application") Set w = e.Workbooks.Add Select Case sVer Case "12.0" w.SaveAs "C:\Temp\FileName.xls", xlExcel12 Case Else w.SaveAs "C:\Temp\FileName.xls", xlExcel8 End Select w.Close Set w = Nothing Set e = Nothing End Select End Sub On Sep 27, 7:02 am, Richard Bond wrote: I am producing office 2007 files (with no macros) directly on a webserver from .net. I was then going to rely on users having the compatibility pack on their machines to convert to whatever version of office they have. My boss has now changed his mind and said that we should be able to give our users the choice of formats. Is there recommended way of programmatically converting from office 2007 format to say office 2003 format on a server????? Is OMPM using the ofc appropriate for this environment? regards, Richard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
File format conversion on server
Here's a great explanation of file formats from an Office 2007
perspective. You could easily incorporate the same logic using the Excel.Application object in .NET like I explained previously: http://www.rondebruin.nl/saveas.htm |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
File format conversion on server
apologies for the lack of clarity....I'm Ill at home Today
I'm producing excel files on demand on a webserver by creating the raw xml required and packaging it up into the xlsx format which is fast and light on server resources. As running excel on the server is generally ill advised according to numerous MS articles, I need to be able to convert files to older formats on demand as a second step (ideally not automating any office program) (There is a word conversion group but nothing for excel or office in general as far as i can see) regards, Richard " wrote: How about this: prior to actually creating the Excel file (assuming that's the "Office 2007 files" you're talking about since you're posting to an Excel group), have the user select the format they want. Then use a conditional statement to save the Excel file in the format you want. Of course, this suggestions makes a lot of assumptions since you posted no code. For example I assume your using an Excel.Application object. Something like the untested code he Private Sub SaveBook(sVer As String) Dim e As Object Dim w As Workbook Set e = CreateObject("Excel.Application") Set w = e.Workbooks.Add Select Case sVer Case "12.0" w.SaveAs "C:\Temp\FileName.xls", xlExcel12 Case Else w.SaveAs "C:\Temp\FileName.xls", xlExcel8 End Select w.Close Set w = Nothing Set e = Nothing End Select End Sub On Sep 27, 7:02 am, Richard Bond wrote: I am producing office 2007 files (with no macros) directly on a webserver from .net. I was then going to rely on users having the compatibility pack on their machines to convert to whatever version of office they have. My boss has now changed his mind and said that we should be able to give our users the choice of formats. Is there recommended way of programmatically converting from office 2007 format to say office 2003 format on a server????? Is OMPM using the ofc appropriate for this environment? regards, Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking data from text file on ftp server to excel file | Excel Programming | |||
Conversion to Text file format error | Excel Discussion (Misc queries) | |||
Excel: wheres menu item to change file format conversion options? | Excel Discussion (Misc queries) | |||
Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
conversion to qif or ofx file format | Excel Discussion (Misc queries) |