I recently distributed a 2007 workbook that contained pop up calendars
courtesy of the Microsoft Office Calendar Control 2007. I foolishly assumed
that when a user opened the workbook, Excel would “realise” that there was a
Calendar control embedded and automatically enable the VB reference.
Optimistic eh?
I was looking at ways to automate the enablement of the Calendar reference
object – I found this code on Chip Pearson’s site and wondered if a similar
thing could be run to automatically select the Calendar control? This code
enables the Microsoft Visual Basic Application Extensibility 5.3 object
library.

ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
Major:=5, Minor:=3

All help appreciated!
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.

Surely, if you created the workbook in 2007, and your other users also have
2007, it will already be referenced (did you check the References list?).
More probable is that they don't have the control on their machine.

--

HTH

Bob

"Rodels" <(E-Mail Removed)> wrote in message
news:4E17169A-F7FD-428D-852D-(E-Mail Removed)...
>I recently distributed a 2007 workbook that contained pop up calendars
> courtesy of the Microsoft Office Calendar Control 2007. I foolishly
> assumed
> that when a user opened the workbook, Excel would "realise" that there was
> a
> Calendar control embedded and automatically enable the VB reference.
> Optimistic eh?
> I was looking at ways to automate the enablement of the Calendar reference
> object - I found this code on Chip Pearson's site and wondered if a
> similar
> thing could be run to automatically select the Calendar control? This
> code
> enables the Microsoft Visual Basic Application Extensibility 5.3 object
> library.
>
> ThisWorkbook.VBProject.References.AddFromGuid _
> GUID:="{0002E157-0000-0000-C000-000000000046}", _
> Major:=5, Minor:=3
>
> All help appreciated!
> Kind regards,
> Robert
>
>
> Rodels! Creating weapons of Maths Destruction since 2003.

Bob and Jan Karel,
many thanks.

Bob you are correct - the reason the control would not activate is that the
control was not available. Jan Karel's suggestion of downloading the ocx and
installing that worked. I suspect that environments with locked down secure
desktops could pose a problem to this approach so I will need to rethink.

Many thanks again!

Robert
--
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.


"Rodels" wrote:

> I recently distributed a 2007 workbook that contained pop up calendars
> courtesy of the Microsoft Office Calendar Control 2007. I foolishly assumed
> that when a user opened the workbook, Excel would “realise” that there was a
> Calendar control embedded and automatically enable the VB reference.
> Optimistic eh?
> I was looking at ways to automate the enablement of the Calendar reference
> object – I found this code on Chip Pearson’s site and wondered if a similar
> thing could be run to automatically select the Calendar control? This code
> enables the Microsoft Visual Basic Application Extensibility 5.3 object
> library.
>
> ThisWorkbook.VBProject.References.AddFromGuid _
> GUID:="{0002E157-0000-0000-C000-000000000046}", _
> Major:=5, Minor:=3
>
> All help appreciated!
> Kind regards,
> Robert
>
>
> Rodels! Creating weapons of Maths Destruction since 2003.

That is always a problem, that is why many developers develop their own
calendars.

--

HTH

Bob

"Rodels" <(E-Mail Removed)> wrote in message
news:8BEA7B16-E63D-4381-A519-(E-Mail Removed)...
> Bob and Jan Karel,
> many thanks.
>
> Bob you are correct - the reason the control would not activate is that
> the
> control was not available. Jan Karel's suggestion of downloading the ocx
> and
> installing that worked. I suspect that environments with locked down
> secure
> desktops could pose a problem to this approach so I will need to rethink.
>
> Many thanks again!
>
> Robert
> --
> Kind regards,
> Robert
>
>
> Rodels! Creating weapons of Maths Destruction since 2003.
>
>
> "Rodels" wrote:
>
>> I recently distributed a 2007 workbook that contained pop up calendars
>> courtesy of the Microsoft Office Calendar Control 2007. I foolishly
>> assumed
>> that when a user opened the workbook, Excel would "realise" that there
>> was a
>> Calendar control embedded and automatically enable the VB reference.
>> Optimistic eh?
>> I was looking at ways to automate the enablement of the Calendar
>> reference
>> object - I found this code on Chip Pearson's site and wondered if a
>> similar
>> thing could be run to automatically select the Calendar control? This
>> code
>> enables the Microsoft Visual Basic Application Extensibility 5.3 object
>> library.
>>
>> ThisWorkbook.VBProject.References.AddFromGuid _
>> GUID:="{0002E157-0000-0000-C000-000000000046}", _
>> Major:=5, Minor:=3
>>
>> All help appreciated!
>> Kind regards,
>> Robert
>>
>>
>> Rodels! Creating weapons of Maths Destruction since 2003.

Interesting point.

By the way, I enjoyed your sessions at the Excel User group last year.
--
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.


"Bob Phillips" wrote:

> That is always a problem, that is why many developers develop their own
> calendars.
>
> --
>
> HTH
>
> Bob
>
> "Rodels" <(E-Mail Removed)> wrote in message
> news:8BEA7B16-E63D-4381-A519-(E-Mail Removed)...
> > Bob and Jan Karel,
> > many thanks.
> >
> > Bob you are correct - the reason the control would not activate is that
> > the
> > control was not available. Jan Karel's suggestion of downloading the ocx
> > and
> > installing that worked. I suspect that environments with locked down
> > secure
> > desktops could pose a problem to this approach so I will need to rethink.
> >
> > Many thanks again!
> >
> > Robert
> > --
> > Kind regards,
> > Robert
> >
> >
> > Rodels! Creating weapons of Maths Destruction since 2003.
> >
> >
> > "Rodels" wrote:
> >
> >> I recently distributed a 2007 workbook that contained pop up calendars
> >> courtesy of the Microsoft Office Calendar Control 2007. I foolishly
> >> assumed
> >> that when a user opened the workbook, Excel would "realise" that there
> >> was a
> >> Calendar control embedded and automatically enable the VB reference.
> >> Optimistic eh?
> >> I was looking at ways to automate the enablement of the Calendar
> >> reference
> >> object - I found this code on Chip Pearson's site and wondered if a
> >> similar
> >> thing could be run to automatically select the Calendar control? This
> >> code
> >> enables the Microsoft Visual Basic Application Extensibility 5.3 object
> >> library.
> >>
> >> ThisWorkbook.VBProject.References.AddFromGuid _
> >> GUID:="{0002E157-0000-0000-C000-000000000046}", _
> >> Major:=5, Minor:=3
> >>
> >> All help appreciated!
> >> Kind regards,
> >> Robert
> >>
> >>
> >> Rodels! Creating weapons of Maths Destruction since 2003.
>
>
> .
>

Thank-you, I am sorry there are none planned for this year, but they take a
lot of organising.

--

HTH

Bob

"Rodels" <(E-Mail Removed)> wrote in message
news:1148E7C5-24E2-4889-8259-(E-Mail Removed)...
> Interesting point.
>
> By the way, I enjoyed your sessions at the Excel User group last year.
> --
> Kind regards,
> Robert
>
>
> Rodels! Creating weapons of Maths Destruction since 2003.
>
>
> "Bob Phillips" wrote:
>
>> That is always a problem, that is why many developers develop their own
>> calendars.
>>
>> --
>>
>> HTH
>>
>> Bob
>>
>> "Rodels" <(E-Mail Removed)> wrote in message
>> news:8BEA7B16-E63D-4381-A519-(E-Mail Removed)...
>> > Bob and Jan Karel,
>> > many thanks.
>> >
>> > Bob you are correct - the reason the control would not activate is that
>> > the
>> > control was not available. Jan Karel's suggestion of downloading the
>> > ocx
>> > and
>> > installing that worked. I suspect that environments with locked down
>> > secure
>> > desktops could pose a problem to this approach so I will need to
>> > rethink.
>> >
>> > Many thanks again!
>> >
>> > Robert
>> > --
>> > Kind regards,
>> > Robert
>> >
>> >
>> > Rodels! Creating weapons of Maths Destruction since 2003.
>> >
>> >
>> > "Rodels" wrote:
>> >
>> >> I recently distributed a 2007 workbook that contained pop up calendars
>> >> courtesy of the Microsoft Office Calendar Control 2007. I foolishly
>> >> assumed
>> >> that when a user opened the workbook, Excel would "realise" that there
>> >> was a
>> >> Calendar control embedded and automatically enable the VB reference.
>> >> Optimistic eh?
>> >> I was looking at ways to automate the enablement of the Calendar
>> >> reference
>> >> object - I found this code on Chip Pearson's site and wondered if a
>> >> similar
>> >> thing could be run to automatically select the Calendar control? This
>> >> code
>> >> enables the Microsoft Visual Basic Application Extensibility 5.3
>> >> object
>> >> library.
>> >>
>> >> ThisWorkbook.VBProject.References.AddFromGuid _
>> >> GUID:="{0002E157-0000-0000-C000-000000000046}", _
>> >> Major:=5, Minor:=3
>> >>
>> >> All help appreciated!
>> >> Kind regards,
>> >> Robert
>> >>
>> >>
>> >> Rodels! Creating weapons of Maths Destruction since 2003.
>>
>>
>> .
>>