If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Loading Data into Multiple sheets in 1 book
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 |
#2
|
|||
|
|||
Loading Data into Multiple sheets in 1 book
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. " wrote: 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 |
Thread Tools | |
Display Modes | |
|
|