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 / January 2007

Tip: Looking for answers? Try searching our database.

Need to auto-import data from .CSV files using an Excel Template to generate graphs.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nobidon@gmail.com - 03 Jan 2007 21:25 GMT
Hi,
  I already know how to create new worksheets from a template file but
I don't know how to import
my data in an automated way.

When I type "Excel /t TemplateName.xlt" it generates a new empty
worksheet with my predefined graphs ready to go, but there is no data
in the columns to be graphed.

I have programs that generate standard .CSV data with the data I care
about always in the correct columns.    When I import the data by hand
it my new worksheet graphs it perfectly, but I don't want to import the
data by hand.  I want to tell my command line to apply the template and
also import the data in one step.

All the forums I've read so far don't have any information on this.
Do I need to create a data import macro in my template?

- Sincerely,

nobidon@gmail.com
Gord Dibben - 03 Jan 2007 23:55 GMT
Macros cannot be run from the command line, only from workbooks.

Create a Workbook_Open macro for your Template so when a workbook based on the
Template opens, the data will be imported to that workbook.

Gord Dibben  MS Excel MVP

>Hi,
>   I already know how to create new worksheets from a template file but
[quoted text clipped - 17 lines]
>
>nobidon@gmail.com

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.