How can I programatically (vb or macro) create new worksheets (ideally based
on a template) on my workbook and populate that new worksheets from a list
of data?

Thanks in advance

Alberto,

Try some code like the following:

With ActiveWorkbook.Worksheets
Workbooks("Templ.xls").Worksheets("Template").Copy after:=.Item(.Count)
.Item(.Count).Select
End With

This will copy the worksheet named "Template" from the workbook "Templ.xls"
to the ActiveWorkbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)


"Alberto Pinto" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How can I programatically (vb or macro) create new worksheets (ideally
> based on a template) on my workbook and populate that new worksheets from
> a list of data?
>
> Thanks in advance
>

Great! Thanks.

Do you know how can i rename and move the new worksheet?
where can i get the list of macros methods and properties available on Excel
?


"Chip Pearson" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Alberto,
>
> Try some code like the following:
>
> With ActiveWorkbook.Worksheets
> Workbooks("Templ.xls").Worksheets("Template").Copy after:=.Item(.Count)
> .Item(.Count).Select
> End With
>
> This will copy the worksheet named "Template" from the workbook
> "Templ.xls" to the ActiveWorkbook.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> www.cpearson.com
> (email address is on the web site)
>
>
> "Alberto Pinto" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> How can I programatically (vb or macro) create new worksheets (ideally
>> based on a template) on my workbook and populate that new worksheets from
>> a list of data?
>>
>> Thanks in advance
>>
>
>

Alberto,
Record a macro of your actions, Tools>Macro>Record New Macro..

Check the Help and Object Browser.

NickHK

"Alberto Pinto" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Great! Thanks.
>
> Do you know how can i rename and move the new worksheet?
> where can i get the list of macros methods and properties available on
Excel
> ?
>
>
> "Chip Pearson" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > Alberto,
> >
> > Try some code like the following:
> >
> > With ActiveWorkbook.Worksheets
> > Workbooks("Templ.xls").Worksheets("Template").Copy
after:=.Item(.Count)
> > .Item(.Count).Select
> > End With
> >
> > This will copy the worksheet named "Template" from the workbook
> > "Templ.xls" to the ActiveWorkbook.
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > www.cpearson.com
> > (email address is on the web site)
> >
> >
> > "Alberto Pinto" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> How can I programatically (vb or macro) create new worksheets (ideally
> >> based on a template) on my workbook and populate that new worksheets
from
> >> a list of data?
> >>
> >> Thanks in advance
> >>
> >
> >
>
>

This can be a very simple question but I can't find information about the
Worksheet(neither about the workbook or others) object in VB for Office Help
or Excel Help.
Where can I find this info?

"NickHK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Alberto,
> Record a macro of your actions, Tools>Macro>Record New Macro..
>
> Check the Help and Object Browser.
>
> NickHK
>
> "Alberto Pinto" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Great! Thanks.
>>
>> Do you know how can i rename and move the new worksheet?
>> where can i get the list of macros methods and properties available on
> Excel
>> ?
>>
>>
>> "Chip Pearson" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > Alberto,
>> >
>> > Try some code like the following:
>> >
>> > With ActiveWorkbook.Worksheets
>> > Workbooks("Templ.xls").Worksheets("Template").Copy
> after:=.Item(.Count)
>> > .Item(.Count).Select
>> > End With
>> >
>> > This will copy the worksheet named "Template" from the workbook
>> > "Templ.xls" to the ActiveWorkbook.
>> >
>> >
>> > --
>> > Cordially,
>> > Chip Pearson
>> > Microsoft MVP - Excel
>> > www.cpearson.com
>> > (email address is on the web site)
>> >
>> >
>> > "Alberto Pinto" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> How can I programatically (vb or macro) create new worksheets (ideally
>> >> based on a template) on my workbook and populate that new worksheets
> from
>> >> a list of data?
>> >>
>> >> Thanks in advance
>> >>
>> >
>> >
>>
>>
>
>

In the VBE, got to Help and type "Object Model"

NickHK

"Alberto Pinto" <(E-Mail Removed)> wrote in message
news:OK$C3zE$(E-Mail Removed)...
> This can be a very simple question but I can't find information about the
> Worksheet(neither about the workbook or others) object in VB for Office
Help
> or Excel Help.
> Where can I find this info?
>
> "NickHK" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Alberto,
> > Record a macro of your actions, Tools>Macro>Record New Macro..
> >
> > Check the Help and Object Browser.
> >
> > NickHK
> >
> > "Alberto Pinto" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> Great! Thanks.
> >>
> >> Do you know how can i rename and move the new worksheet?
> >> where can i get the list of macros methods and properties available on
> > Excel
> >> ?
> >>
> >>
> >> "Chip Pearson" <(E-Mail Removed)> wrote in message
> >> news:%(E-Mail Removed)...
> >> > Alberto,
> >> >
> >> > Try some code like the following:
> >> >
> >> > With ActiveWorkbook.Worksheets
> >> > Workbooks("Templ.xls").Worksheets("Template").Copy
> > after:=.Item(.Count)
> >> > .Item(.Count).Select
> >> > End With
> >> >
> >> > This will copy the worksheet named "Template" from the workbook
> >> > "Templ.xls" to the ActiveWorkbook.
> >> >
> >> >
> >> > --
> >> > Cordially,
> >> > Chip Pearson
> >> > Microsoft MVP - Excel
> >> > www.cpearson.com
> >> > (email address is on the web site)
> >> >
> >> >
> >> > "Alberto Pinto" <(E-Mail Removed)> wrote in message
> >> > news:(E-Mail Removed)...
> >> >> How can I programatically (vb or macro) create new worksheets
(ideally
> >> >> based on a template) on my workbook and populate that new worksheets
> > from
> >> >> a list of data?
> >> >>
> >> >> Thanks in advance
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>