Iam able to generate excel from my Form using ole2 package.
Iam using forms 6i and database 10g.
Following is the procedure to save the file to excel
Procedure save_xl(p_path varchar2,p_excel_name varchar2) is
If p_path is not null then
Arglist := OLE2.Create_Arglist;
OLE2.Invoke(workbook, 'SaveAs', Arglist);
Now i want to publish pdf file from this generated excel file programatically. Please help
Note : I tried modifying OLE2.Add_Arg(Arglist,p_path||'\'||p_excel_name||'.xls') to OLE2.Add_Arg(Arglist,p_path||'\'||p_excel_name||'.pdf')
but it creates a pdf file but doesnt work. Because it is just saving the file as .pdf instead of .xls its not publising to pdf actually....
Thanks in advance.