How to use automation to save xls into pdf from office 2007?

Hi all,

I am trying to use offcie automation to convert a xls into pdf. I installed
the the save as pdf or xps addin and it worked fine from the application but
can find the right file format in the enum value.

any help will be approciated.. thx

here is the enum value in my system:
public enum XlFileFormat
{
xlCurrentPlatformText = -4158,
xlWorkbookNormal = -4143,
xlSYLK = 2,
xlWKS = 4,
xlWK1 = 5,
xlCSV = 6,
xlDBF2 = 7,
xlDBF3 = 8,
xlDIF = 9,
xlDBF4 = 11,
xlWJ2WD1 = 14,
xlWK3 = 15,
xlExcel2 = 16,
xlTemplate = 17,
xlTemplate8 = 17,
xlAddIn8 = 18,
xlAddIn = 18,
xlTextMac = 19,
xlTextWindows = 20,
xlTextMSDOS = 21,
xlCSVMac = 22,
xlCSVWindows = 23,
xlCSVMSDOS = 24,
xlIntlMacro = 25,
xlIntlAddIn = 26,
xlExcel2FarEast = 27,
xlWorks2FarEast = 28,
xlExcel3 = 29,
xlWK1FMT = 30,
xlWK1ALL = 31,
xlWK3FM3 = 32,
xlExcel4 = 33,
xlWQ1 = 34,
xlExcel4Workbook = 35,
xlTextPrinter = 36,
xlWK4 = 38,
xlExcel7 = 39,
xlExcel5 = 39,
xlWJ3 = 40,
xlWJ3FJ3 = 41,
xlUnicodeText = 42,
xlExcel9795 = 43,
xlHtml = 44,
xlWebArchive = 45,
xlXMLSpreadsheet = 46,
xlExcel12 = 50,
xlOpenXMLWorkbook = 51,
xlWorkbookDefault = 51,
xlOpenXMLWorkbookMacroEnabled = 52,
xlOpenXMLTemplateMacroEnabled = 53,
xlOpenXMLTemplate = 54,
xlOpenXMLAddIn = 55,
xlExcel8 = 56,
}

the enum values you show are for the FileFormat argument of the Excel native
SaveAs command. If the ability to save as PDF requires an addin, then I
would suggest the command and its arguments are defined in that addin. You
will need to get some documentation for it.

--
Regards,
Tom Ogilvy


"Jun" wrote:

> Hi all,
>
> I am trying to use offcie automation to convert a xls into pdf. I installed
> the the save as pdf or xps addin and it worked fine from the application but
> can find the right file format in the enum value.
>
> any help will be approciated.. thx
>
> here is the enum value in my system:
> public enum XlFileFormat
> {
> xlCurrentPlatformText = -4158,
> xlWorkbookNormal = -4143,
> xlSYLK = 2,
> xlWKS = 4,
> xlWK1 = 5,
> xlCSV = 6,
> xlDBF2 = 7,
> xlDBF3 = 8,
> xlDIF = 9,
> xlDBF4 = 11,
> xlWJ2WD1 = 14,
> xlWK3 = 15,
> xlExcel2 = 16,
> xlTemplate = 17,
> xlTemplate8 = 17,
> xlAddIn8 = 18,
> xlAddIn = 18,
> xlTextMac = 19,
> xlTextWindows = 20,
> xlTextMSDOS = 21,
> xlCSVMac = 22,
> xlCSVWindows = 23,
> xlCSVMSDOS = 24,
> xlIntlMacro = 25,
> xlIntlAddIn = 26,
> xlExcel2FarEast = 27,
> xlWorks2FarEast = 28,
> xlExcel3 = 29,
> xlWK1FMT = 30,
> xlWK1ALL = 31,
> xlWK3FM3 = 32,
> xlExcel4 = 33,
> xlWQ1 = 34,
> xlExcel4Workbook = 35,
> xlTextPrinter = 36,
> xlWK4 = 38,
> xlExcel7 = 39,
> xlExcel5 = 39,
> xlWJ3 = 40,
> xlWJ3FJ3 = 41,
> xlUnicodeText = 42,
> xlExcel9795 = 43,
> xlHtml = 44,
> xlWebArchive = 45,
> xlXMLSpreadsheet = 46,
> xlExcel12 = 50,
> xlOpenXMLWorkbook = 51,
> xlWorkbookDefault = 51,
> xlOpenXMLWorkbookMacroEnabled = 52,
> xlOpenXMLTemplateMacroEnabled = 53,
> xlOpenXMLTemplate = 54,
> xlOpenXMLAddIn = 55,
> xlExcel8 = 56,
> }
>

When I recorded a macro saving as PDF I got this:

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,.....

xlTypePDF equals 0.

--
Jim
"Jun" <Jun@discussions.microsoft.com> wrote in message
news:B9E1B239-82D0-41D0-A3F9-3BE339205E1C@microsoft.com...
| Hi all,
|
| I am trying to use offcie automation to convert a xls into pdf. I
installed
| the the save as pdf or xps addin and it worked fine from the application
but
| can find the right file format in the enum value.
|
| any help will be approciated.. thx
|
| here is the enum value in my system:
| public enum XlFileFormat
| {
| xlCurrentPlatformText = -4158,
| xlWorkbookNormal = -4143,
| xlSYLK = 2,
| xlWKS = 4,
| xlWK1 = 5,
| xlCSV = 6,
| xlDBF2 = 7,
| xlDBF3 = 8,
| xlDIF = 9,
| xlDBF4 = 11,
| xlWJ2WD1 = 14,
| xlWK3 = 15,
| xlExcel2 = 16,
| xlTemplate = 17,
| xlTemplate8 = 17,
| xlAddIn8 = 18,
| xlAddIn = 18,
| xlTextMac = 19,
| xlTextWindows = 20,
| xlTextMSDOS = 21,
| xlCSVMac = 22,
| xlCSVWindows = 23,
| xlCSVMSDOS = 24,
| xlIntlMacro = 25,
| xlIntlAddIn = 26,
| xlExcel2FarEast = 27,
| xlWorks2FarEast = 28,
| xlExcel3 = 29,
| xlWK1FMT = 30,
| xlWK1ALL = 31,
| xlWK3FM3 = 32,
| xlExcel4 = 33,
| xlWQ1 = 34,
| xlExcel4Workbook = 35,
| xlTextPrinter = 36,
| xlWK4 = 38,
| xlExcel7 = 39,
| xlExcel5 = 39,
| xlWJ3 = 40,
| xlWJ3FJ3 = 41,
| xlUnicodeText = 42,
| xlExcel9795 = 43,
| xlHtml = 44,
| xlWebArchive = 45,
| xlXMLSpreadsheet = 46,
| xlExcel12 = 50,
| xlOpenXMLWorkbook = 51,
| xlWorkbookDefault = 51,
| xlOpenXMLWorkbookMacroEnabled = 52,
| xlOpenXMLTemplateMacroEnabled = 53,
| xlOpenXMLTemplate = 54,
| xlOpenXMLAddIn = 55,
| xlExcel8 = 56,
| }
|

Thanks you. i tried to reply yesterday but somehow my computer wont open the
popup.. anyway i was trying to use SaveAs and sure enough for pdf and xps, i
was supposed to use the ExportAsFixedFormat method. Thanks for pointing that
out..
Jun

"Jim Rech" wrote:

> When I recorded a macro saving as PDF I got this:
>
> ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF,.....
>
> xlTypePDF equals 0.
>
> --
> Jim
> "Jun" <Jun@discussions.microsoft.com> wrote in message
> news:B9E1B239-82D0-41D0-A3F9-3BE339205E1C@microsoft.com...
> | Hi all,
> |
> | I am trying to use offcie automation to convert a xls into pdf. I
> installed
> | the the save as pdf or xps addin and it worked fine from the application
> but
> | can find the right file format in the enum value.
> |
> | any help will be approciated.. thx
> |
> | here is the enum value in my system:
> | public enum XlFileFormat
> | {
> | xlCurrentPlatformText = -4158,
> | xlWorkbookNormal = -4143,
> | xlSYLK = 2,
> | xlWKS = 4,
> | xlWK1 = 5,
> | xlCSV = 6,
> | xlDBF2 = 7,
> | xlDBF3 = 8,
> | xlDIF = 9,
> | xlDBF4 = 11,
> | xlWJ2WD1 = 14,
> | xlWK3 = 15,
> | xlExcel2 = 16,
> | xlTemplate = 17,
> | xlTemplate8 = 17,
> | xlAddIn8 = 18,
> | xlAddIn = 18,
> | xlTextMac = 19,
> | xlTextWindows = 20,
> | xlTextMSDOS = 21,
> | xlCSVMac = 22,
> | xlCSVWindows = 23,
> | xlCSVMSDOS = 24,
> | xlIntlMacro = 25,
> | xlIntlAddIn = 26,
> | xlExcel2FarEast = 27,
> | xlWorks2FarEast = 28,
> | xlExcel3 = 29,
> | xlWK1FMT = 30,
> | xlWK1ALL = 31,
> | xlWK3FM3 = 32,
> | xlExcel4 = 33,
> | xlWQ1 = 34,
> | xlExcel4Workbook = 35,
> | xlTextPrinter = 36,
> | xlWK4 = 38,
> | xlExcel7 = 39,
> | xlExcel5 = 39,
> | xlWJ3 = 40,
> | xlWJ3FJ3 = 41,
> | xlUnicodeText = 42,
> | xlExcel9795 = 43,
> | xlHtml = 44,
> | xlWebArchive = 45,
> | xlXMLSpreadsheet = 46,
> | xlExcel12 = 50,
> | xlOpenXMLWorkbook = 51,
> | xlWorkbookDefault = 51,
> | xlOpenXMLWorkbookMacroEnabled = 52,
> | xlOpenXMLTemplateMacroEnabled = 53,
> | xlOpenXMLTemplate = 54,
> | xlOpenXMLAddIn = 55,
> | xlExcel8 = 56,
> | }
> |
>
>
>