Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Loading Data into Multiple sheets in 1 book

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ralphlov@aol.com - 07 Sep 2006 23:44 GMT
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:\':DETAIL.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 - 10 Sep 2006 15:41 GMT
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.

> Loading Data into Multiple sheets in 1 book
> Hi All
[quoted text clipped - 11 lines]
>
> Ralph

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.