[james_lovett]

Hi there,

I am new here and any help will be very much appreciated.

I have an excel spreadsheet with a project schedule running down a column. I would like to click a button and export this list of dates into a graphical calendar which I could print out showing me what I am doing and when.

The calendar could just say project fieldwork start and fill in a key attached with the schedule.

Can anyone help or point me in the right direction?

Cheers
James

[Advertisements]

James,
If you have MS Outlook installed you can try the following;
Tested with Outlook 2003


Step1 - Create a Template

From Outlook select the following menu items
> File
> Import and Export
> Export to a File > Next
> Comma Seperated Values > Next
> Calendar > Next
> Enter DestinationFileName.csv > Next
> Export Appointments > Finish
> Enter Date Range > OK

N.B. Make sure you have some example appointments created before you start


Step2 - Format Data to Import

> Open DestinationFileName.csv
> Add your data to the correct columns
> Save your csv file


Step3 - Import your data

From Outlook select the following menu items
> File
> Import and Export
> Import from another program or File > Next
> Comma Seperated Values > Next
> Enter SourceFileName.csv > Next
> Calendar > Next
> Import SourceFileName.csv into folder : Calendar > Finish


Step4 - View / Print data



hth

dsm

[dsm]

James,
If you have MS Outlook installed you can try the following;
Tested with Outlook 2003


Step1 - Create a Template

From Outlook select the following menu items
> File
> Import and Export
> Export to a File > Next
> Comma Seperated Values > Next
> Calendar > Next
> Enter DestinationFileName.csv > Next
> Export Appointments > Finish
> Enter Date Range > OK

N.B. Make sure you have some example appointments created before you start


Step2 - Format Data to Import

> Open DestinationFileName.csv
> Add your data to the correct columns
> Save your csv file


Step3 - Import your data

From Outlook select the following menu items
> File
> Import and Export
> Import from another program or File > Next
> Comma Seperated Values > Next
> Enter SourceFileName.csv > Next
> Calendar > Next
> Import SourceFileName.csv into folder : Calendar > Finish


Step4 - View / Print data



hth

dsm