2004 Excel Calendar

[Guest]

Will there be a calendar template for 2004 in Excel? I see several in Word and Powerpoint but no Excel.

 

[Peo Sjoblom]

http://www.cpearson.com/Zips/CALENDAR.ZIP



--

Regards,

Peo Sjoblom

Will there be a calendar template for 2004 in Excel? I see several in

Word and Powerpoint but no Excel.

 

[Guest]

Thanks for the file

I've tried to open the attached file in Excel 2002 and receive

Run time error 13 Type mismatch

Any suggestion

 

[Chip Pearson]

Laura,

On what line of code do you receive the error? The file works
fine for me in Excel 97, 2002, and 2003. Do you have the Analysis
Tool Pak installed?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

Chip,

I installed the Tool Pak and the file now works great.

Thanks!!


----- Chip Pearson wrote: -----

Laura,

On what line of code do you receive the error? The file works
fine for me in Excel 97, 2002, and 2003. Do you have the Analysis
Tool Pak installed?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mathew P Bennett]

Hi Chip
I also downloaded this calendar of yours, looks great, and very flexible.
You've even provided the code.
I also get the same run-tme error '13' Type mismatch

It seems to occur between lines 268 - 275 of your code.
Please let me know if and when you fix it, I will find it very useful.

Yours,
Mathew

Laura,

On what line of code do you receive the error? The file works
fine for me in Excel 97, 2002, and 2003. Do you have the Analysis
Tool Pak installed?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Chip Pearson]

Mathew,

You must have the Analysis Tool Pack add-in loaded. Go to the
Tools menu, choose Add-Ins, then check "Analysis Tool Pack".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hi Chip
I also downloaded this calendar of yours, looks great, and very flexible.
You've even provided the code.
I also get the same run-tme error '13' Type mismatch

It seems to occur between lines 268 - 275 of your code.
Please let me know if and when you fix it, I will find it very useful.

Yours,
Mathew

Laura,

On what line of code do you receive the error? The file works
fine for me in Excel 97, 2002, and 2003. Do you have the Analysis
Tool Pak installed?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

27/11/2003

 

[Mathew P Bennett]

Hi Chip,
I do have: Analysis Toolpak & Analysis Toolpak - VBA, installed as add-ins, (MS)
Me running MS XP Off XP PentII 233Hz
Mathew

Mathew,

You must have the Analysis Tool Pack add-in loaded. Go to the
Tools menu, choose Add-Ins, then check "Analysis Tool Pack".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hi Chip
I also downloaded this calendar of yours, looks great, and very flexible.
You've even provided the code.
I also get the same run-tme error '13' Type mismatch

It seems to occur between lines 268 - 275 of your code.
Please let me know if and when you fix it, I will find it very useful.

Yours,
Mathew

Laura,

On what line of code do you receive the error? The file works
fine for me in Excel 97, 2002, and 2003. Do you have the Analysis
Tool Pak installed?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

27/11/2003

 

[Gord Dibben]

Chip

That was a quick "fix". Perhaps larger text in the NOTE: section would in
order? Flashing/blinking text?<g>

Gord

 

[JonWittwer]

Chip,

That is a great calendar you've got set up!

Here is another calendar for excel, with a different twist. It doesn'
include the holidays, but it has an interesting way of changing th
colors (and it allows you some freedom in adding info to th
calendar):

'excel calendar
(http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html)

This template also requires that the Analysis ToolPak be installed.

Enjoy,
Jo