Linking dates from excel to outlook

[jfandrich]

I want to link my outlook calendar to a specific excel file on my network. I want to run a macro in outlook and have it pull dates from a certain column on a certain sheet and have the name of my appointment pull from another column on that same sheet. Is this possible? I have found a few examples on the internet but nothing helps with finding the file on the netowrk.

Thanks,

Jason

 

[cummings54]

The following code will open an excel workbook from within outlook. Be sure to establish the reference to the excel object library by using "Tools:References..." menu item and selecting Microsoft Excel xx.xx object library.

Sub XL_Test()
Dim myXLApp As Excel.Application
Dim myXLWB As Excel.Workbook
Workbooks.Open "FNAME"
End Sub