Generate the data on Spread sheet using VB script.

[nandu_rao321]

Hi All,
I need a VB script for the following scenario.

I have a spread sheet, which has 10 tabs and each tab has 10 columns.
The script should have the ability to generate the data on to the XL sheet, for example 1 in Column A , 2 in column B, 3 in column C and so on. in all 10 tabs. How can achive this using VB script?

Thanks in Advance.
Nandu

[pflunk]

You will need to create an Excel object
From there you can create workbooks, add worksheets, insert data etc.

Here is a brief example:

set oe = createobject("Excel.Application")
oe.visible = true
set wb = oe.workbooks.add
set ws = wb.worksheets(1)
ws.range("A1").value = "Hello World"
ws.name = "Hi There"

If you are ever wondering how to code something in Excel just record a macro while you do whatever you were trying to do with code manually. Then look at the code generated by the Excel Macro. Often times this helps in a big way.