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
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
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"
;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”,
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
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
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
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
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
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
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
11 matches
Mail list logo