×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Calendar from Excel Data

Calendar from Excel Data

Calendar from Excel Data

(OP)
I have a list of jobs with due dates in an excel file.  I want to take the data and make it into a normal looking Monthly calendar.  I can find lots of templates for excel calendards that look good.  But my question is how to integrate the two.

My first thought is to use the LOOKUP function.  And that would appear to work, but I almost have to start over and make my own calendar.  Is there a smarter way to do this?

I guess I am just wondering if anyone has already done this and could send me a sample I can modify.  I did a quick search of the forums and the web, but did not find a ready made solution.

Thanks, M

RE: Calendar from Excel Data

Ihave never tried to do it, but you might be able to import the data into Outlook and have Outlook create the calender. Or you could just set up the tasks in Outlook and it give you what you want, Assumimng you don't have too much to retype.

RE: Calendar from Excel Data

I have wanted to do this for years and am surprised how difficult it is within MS Office, which appears to have the components but yet this task seems impossible.

Please let us know what you figure out, if you have any luck with it.

RE: Calendar from Excel Data

Isn't this a feature of MS Project?

RE: Calendar from Excel Data

I can't give you a solution, but you can do

Insert->Object->Calender Control.

This will add ActiveX object to your sheet. How to use it further, I don't know. You can do some research on this. If you do, please don't forget to share your findings with us.

Ciao.

RE: Calendar from Excel Data

Sorry I don't have time to do this project, but I would use Outlook Calendar as my display mode. The Outlook Object model can be seen here and it's fairly easy if you've done any Office automation with VBA before.

Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting

UK steam enthusiasts: www.essexsteam.co.uk

RE: Calendar from Excel Data

(OP)
Thank you everyone for your ideas.   I guess I need to clarify a little. YTes this is exactly what MSProject does, unfortunately I don't have it.

My preference would be to just have a second excel sheet in the same file with the calendar.  Simple as possible really and completely separate from outlook.  It would just use standard excel functions/formulas to update the second sheet.

flamby's idea of insert->Object->Calender Control sounds like a good idea.  I guess I will have to find some free time and just make it myself.  I will let everyone know what I figure out.

RE: Calendar from Excel Data

If you try to make the calendar function in Excel or any other Windows based program work, you will spend a lot of time. Also, you might run into the problem that Microsoft changes the ActiceX module and your code doesn't work in one year. This happen to me using calendar Active X in MS Access.

MS project doe s pretty good job with what you need and you should be able to pick up a legal version for $200.oo. If you hourly rate is $80 you can only spend 2 to 3 hours for a program that will be hard to keep yor software up-to-date every time Microsoft releases a new version of Excel, Calendar ActiveX and so on.

Copying you spreadsheets to MS project is easy.

Sometimes it is worth to spend some money.

RE: Calendar from Excel Data

(OP)
I agree with you Raedle.  This was more of just a small personal project than anything else.

I did create a preliminary versions for those of you who are interested.  It lets you have up to three items happen on the same day and lets you choose any month to look at.  Just need to make sure that you sort your projects by due date for the calendar to work.

I will post it at the following site for a month or so:

http://st26.startlogic.com/~montanab/TEMP/

RE: Calendar from Excel Data

This is also something I have been trying to figure out for a while.  The file you created is very close to what I need for my application.  Can you describe how you did this or send me the macro associated with your file.  I need to add times of the day and view additional months.

Thanks for your help.

RE: Calendar from Excel Data

(OP)
All of the formulas are right in the spreadsheet.  Just need to edit as required.  I got all of my ideas and examples from:

http://www.ozgrid.com/Excel/DynamicRanges.htm

Lots of interesting applications at this site.
Regards, M

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close