MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel to Outlook calendar using VBA

  Asked By: Mali    Date: Sep 07    Category: MS Office    Views: 1670

I have a Lotus Notes file that has been exported to Excel.

I created a macro that configures the Excel file into something we
want to import into Outlook Calendar.

I know the file is ready to import, I can do it manually

1st Problem:
The file can not be open during the Import to calendar.
If the file is close, won't it stop the macro?
Do I need to Master file as a third file and not the imported file
or is there another way to do this?

2nd Problem:
I can import the file manually, using the wizard; however, I don't
know the Outlook VBA code to make this happen. any ideas?

Ideally, I want a file update button
(I have already created and tested)
after the user has reviewd the data, I want a second button to
export the data into Outlook calendar for the rest of the team to be
able to review.

The project is for the training team to know dates/times, location,
instructors, and subject of all the classes being taught.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Excel to Outlook calendar using VBA Or get search suggestion and latest updates.