problem of copying individual worksheets in separate workbook

[Ratan]

Hi All,

I have to write a script which does following task...

- Open a workbook.
- Read a worksheet and save it in a new workbook.
- Repeat step 2 for all worksheets of the original workbook.


Please help on solution of this.

Thanks in advance.

 

[Michele Dondi]

Hi All,
Hi!

I have to write a script which does following task...

I have to write a script which will earn me a pony. Now, where's my
pony?!?

- Open a workbook.

*What* is a workbook? Too generic a term for me to think of anything
specific.

- Read a worksheet and save it in a new workbook.

*What* is a workbook? Too generic a term for me to think of anything
specific.

- Repeat step 2 for all worksheets of the original workbook.
Ditto.

Thanks in advance.

You welcome!


Michele

 

[Ratan]

Sorry for the incomplete info...

Actually i am talking here about a Microsoft excel workbook.

- Open a workbook. [This is Microsoft Excel workbook]
- Read a worksheet and save it in a new workbook. [ By worksheet i
mean to say each of the worksheets in Excel]
- Repeat step 2 for all worksheets of the original workbook [ Save
each of the worksheets in new Excel file i.e. workbook]

Hope that this clarifies the question.

 

[Michele Dondi]

Actually i am talking here about a Microsoft excel workbook. [snip]
Hope that this clarifies the question.

It clarifies it in way that makes me sure I can't help you but
possibly pointing you to modules like Spreadsheet:arseExcel,
Spreadsheet::WriteExcel or perhaps on a more general basis Win32::OLE.
None of which I really know anything about.


Michele