RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
11 1:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Template to modify workbooks hi Kent Try this one On Tue, Sep 20, 2011 at 10:31 PM, Boucher, Kent C mailto:kent.bouc...@tbs-sct.gc.ca>> wrote: Hi Ashish, The workbook that you sent back looks awesome

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
roups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: September 20, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Template to modify workbooks Hi Kent try this open and run the macro choose the workbook . it will save the template file in the same di

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
einer Sent: September 20, 2011 12:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Template to modify workbooks I won't be able to work with it unless I can unprotect the VBA project. I tried "pineapple" but it didn't work.. perhaps "grapefruit"

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Paul Schreiner
;excel-macros@googlegroups.com" Sent: Tue, September 20, 2011 10:11:59 AM Subject: RE: $$Excel-Macros$$ Template to modify workbooks Hi Paul – thanks so much for your time!!   I have attached the workbook that is going to be coming back to 20,000 times titled “Reference Excel Workbook”,

RE: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Boucher, Kent C
Behalf Of ashish koul Sent: September 20, 2011 10:56 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Template to modify workbooks HI Kent if u want to share ur workbook within the group write a mail to excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com&g

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread ashish koul
HI Kent if u want to share ur workbook within the group write a mail to excel-macros@googlegroups.com and attach ur wrkb On Tue, Sep 20, 2011 at 6:34 PM, HarryP Knuckles wrote: > Good morning Ashish! Thanks you for taking the time to assist with my > issue – really appreciated! > All the workb

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread Paul Schreiner
he places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: HarryP Knuckles To: MS EXCEL AND VBA MACROS Sent: Tue, September 20, 2011 8:55:49 AM Subject: Re: $$Ex

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
Good morning Ashish! Thanks you for taking the time to assist with my issue – really appreciated! All the workbooks are currently in *.xls format. My objective is to create a template workbook that is will be used to CONTROL and change (unprotect the workbook and worksheets) the *.xls files. I woul

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-20 Thread HarryP Knuckles
- > > > From: HarryP Knuckles > To: MS EXCEL AND VBA MACROS > Sent: Mon, September 19, 2011 3:58:32 PM > Subject: $$Excel-Macros$$ Template to modify workbooks > > Good afternoon, > > I have 20,0

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread ashish koul
Hi Harry 1 are all the workbooks in xlsm or xls format is it possible for u to share a sample workbook On Tue, Sep 20, 2011 at 1:28 AM, HarryP Knuckles wrote: > Good afternoon, > > I have 20,000 workbooks that are going to be returned to me shortly > and i need a template from which i can ope

Re: $$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread Paul Schreiner
” - John Wesley - From: HarryP Knuckles To: MS EXCEL AND VBA MACROS Sent: Mon, September 19, 2011 3:58:32 PM Subject: $$Excel-Macros$$ Template to modify workbooks Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can ope

$$Excel-Macros$$ Template to modify workbooks

2011-09-19 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to:

$$Excel-Macros$$ Template to modify workbooks

2011-09-16 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to:

$$Excel-Macros$$ Template to modify workbooks

2011-09-16 Thread HarryP Knuckles
Good afternoon, I have 20,000 workbooks that are going to be returned to me shortly and i need a template from which i can open the workbooks (individually) and have a marco to perform three necessary functions on all of these workbooks (each workbook will have a unique name). My objective is to: