Excel Workbooks from an Excel file

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Legacy and Other Languages section within the Software Development category of DaniWeb, a massive community of 391,974 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,145 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Legacy and Other Languages advertiser:

Thread Tools Display Modes

Views: 1170 | Replies: 3 | Solved

•

Join Date: Jan 2007

Location: India

Posts: 187

Reputation: shouvik.d is an unknown quantity at this point

Rep Power: 2

Solved Threads: 6

shouvik.d

Offline

Junior Poster

Excel Workbooks from an Excel file

May 6th, 2008

Hi All,

I am need of using a excel file as a standard template and then use a list of .csv files to populate certain rows and columns of this standard template and save it with a different name so that I can always reuse the standard template and it does not get altered..

Can anybody get me a solution. I prefer to use a VBA so as to have minimal effort to get the csv data and populate the excel.

Please help me.

Regards
Shouvik

•

Join Date: May 2008

Location: San Diego, California

Posts: 3

Reputation: elaurvick is an unknown quantity at this point

Rep Power: 0

Solved Threads: 1

elaurvick

Offline

Newbie Poster

Re: Excel Workbooks from an Excel file

May 8th, 2008

I do this manually with one of my files.
1) Back up your template!!!
2) Open the .csv file with Excel
3) Delete the columns you don't want and save the result with a temporary name as an .xls file.
4) Open the temporary .xls file, highlight the column or columns you want to copy, select "copy", open the template .xls file, highlight the columns to be replaced, and select "paste".
5) If the columns are not next to each other, you'll have to do this one column at a time.
6) Don't forget to make a backup before you start! It's easy to mess up with a manual process.

•

Join Date: Mar 2008

Posts: 26

Reputation: JobMatchNow is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

JobMatchNow JobMatchNow is offline

Offline

Light Poster

Re: Excel Workbooks from an Excel file

May 9th, 2008

Is this way efficent and easy to learn?

•

Join Date: Jan 2007

Location: India

Posts: 187

Reputation: shouvik.d is an unknown quantity at this point

Rep Power: 2

Solved Threads: 6

shouvik.d

Offline

Junior Poster

Re: Excel Workbooks from an Excel file

May 10th, 2008

Hi All,

I could do this in the following manner

 Help with Code Tags 
 VB Syntax (Toggle Plain Text) 
Workbooks.Open Model_Template
Workbooks(Master_Template).Activate
Workbooks(Master_Template).Sheets("Master_Sheet").Select
Workbooks(Master_Template).Sheets("Master_Sheet").Copy before:=Workbooks(Model_Template).Sheets("Sheet1")
Workbooks(Model_Template).Sheets("Master_Sheet").Name = New_Name
Workbooks(Model_Template).Save
Workbooks(Model_Template).Close
Workbooks.Open Model_Template
Workbooks(Master_Template).Activate
Workbooks(Master_Template).Sheets("Master_Sheet").Select
Workbooks(Master_Template).Sheets("Master_Sheet").Copy before:=Workbooks(Model_Template).Sheets("Sheet1")
Workbooks(Model_Template).Sheets("Master_Sheet").Name = New_Name
Workbooks(Model_Template).Save
Workbooks(Model_Template).Close

Master_Template is the original template
Model_Template is the new file.

I used a while loop by which I could create 1272 new Excel Workbooks with the Master_template format but data content varying. It took some 30 minutes to create and populate the new 1272 Workbooks.

Regards
Shouvik