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
Good morning Paul, Thank you for taking interest in my issue – I really appreciate it! To answer your questions: 1) Yes, ideally I would like to disable the macro permanently and then be able to save the disabled version. Having said that, if it is much easier to complete the task by

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
Are you wanting to disable the macros "permanently" and save the  file? or are you just needing them disabled so you can extract the information you need? If you just need them deactivated temporarily, you can create a macro that issues: Application.enableevents = false then, open each of the 20