Using a macro to add code to a newly created workbook.

**Alagard** · 12-03-2010, 04:27 PM

I am using the macro below. It is working great to add data and formulas to the new sheet, however I want to add another feature to this tlmsbiwk.xls file.

Please Login or Register  to view this content.

What I want to add is the code below. I just want it to be included in the new .xls file that is created. I now add it manually and it works fine, I would like to have it included in this step automatically. Thanks for your help.

Please Login or Register  to view this content.

**mrice** · 12-03-2010, 04:46 PM

You could try having the extra code in a workbook that you use as a template and copy the contents of your text file into it.

**jaslake** · 12-15-2010, 04:59 PM

Hi Alagard

Try this

Please Login or Register  to view this content.

Place the code in a general Module of Book 1. It'll write the code in Sheet 1 module of Book 2.

John

**royUK** · 12-16-2010, 02:34 AM

Alagard

Have you bothered to read the Forum Rules? You have posted this question 3 times

http://www.excelforum.com/excel-prog...-workbook.html

http://www.excelforum.com/excel-prog...g-a-macro.html

You haven't even replied to any of them!!!!

Read the Forum Rules then PM me that you intend following them, otherwise I will remove your posting rights.

**Alagard** · 12-16-2010, 01:08 PM

I tried using this and while it did not break anything it also did not add the code into the newly created workbook. Thanks.

**jaslake** · 12-16-2010, 01:34 PM

Hi Alagard

I'll be glad to follow up on this. However, until this is resolved

Read the Forum Rules then PM me that you intend following them, otherwise I will remove your posting rights.

you're under somewhat of a quarantine.

RoyUK...has this issue been resolved?

John

**Alagard** · 12-16-2010, 01:55 PM

I think it has been taken care of. However if it hasn't I am working on another solution as well if that works I will post it here also. Thanks for your help. Also if it helps I am doing all of this with files on a shared network drive.

**snb** · 12-16-2010, 05:08 PM

Please Login or Register  to view this content.

**royUK** · 12-16-2010, 06:05 PM

I've had a reply, but you haven't given me any good reason why you double posted. It's clearly stated in the rules not to double post.

I don't consider your response to even accept the reason for not double posting.

**jaslake** · 12-16-2010, 06:08 PM

Hi royUK

I'll wait to post until the issue is resolved.

John

Using a macro to add code to a newly created workbook.

LinkBack

Thread Tools

Rate This Thread

Display

Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Re: Using a macro to add code to a newly created workbook.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions