Loading Data into Multiple sheets in 1 book

[ralphlov]

Loading Data into Multiple sheets in 1 book
Hi All
I have 2 questions

1. I am trying to automatically create a workbook with a number of
sheets in it with different data. I see how the command mode allows you
to feed data to a (one/first) sheet (C:\Program Files\Microsoft
Office\Office\excel.exe" H:\'ETAIL.XFER.SHORT.FILENAME) but how do
you get data to sheets 2 3 4 etc in the workbook?
2. Can you format the data going into the work sheet such that some of
the data would have bold text?

Thanks in advance


Ralph

 

[JLatham]

Typically you do not import data into Excel via the command line. In over 15
years of using Excel, I cannot recall that I have ever done it that way.
Obviously that doesn't mean that the ability or use that way is a bad thing,
just not one I've ever used. I doubt if you have any control over format of
the incoming data at all.

To automate generation of a workbook usually takes a fair amount of VB
coding to locate and open the source file and transfer the data into the
Excel workbook and do things like formatting the data and worksheets, and
even adding new worksheets when required without operator intervention.