Hi all,
Question : 1
I am creating an Excel workbook using OLE from Forms. It has seven or eight even sometimes 12 spreadsheets inside that workbook. Now i want reorder the sheets in a specific order. Can anyone help me out how to accomplish this one using OLE. i.e. I want to use command “Move or Copy” which we used to do inside the excel application.
Question : 2
For some the cells I want to set the default Number format as ‘Accounting’. i.e. It has show “$” in front of the numbers.
Env :
Forms 6i
Excel 2000
Oracle 9i
I will be very thankful for any valid input on this.
Regards
Dhi
Question : 1
I am creating an Excel workbook using OLE from Forms. It has seven or eight even sometimes 12 spreadsheets inside that workbook. Now i want reorder the sheets in a specific order. Can anyone help me out how to accomplish this one using OLE. i.e. I want to use command “Move or Copy” which we used to do inside the excel application.
Question : 2
For some the cells I want to set the default Number format as ‘Accounting’. i.e. It has show “$” in front of the numbers.
Env :
Forms 6i
Excel 2000
Oracle 9i
I will be very thankful for any valid input on this.
Regards
Dhi