How do you write a macro to automatically import and map a calenda

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a .csv file that gets generated each day that i want to import into a
shared calendar on the network (not my default calendar). How do i write a
macro that will import the calendar to the shared calendar and map the
fields? It would also need to replace existing appoinments instead of adding
duplicates. The .csv will always have the same name, location and layout. Any
ideas would be appreciated.
 
Hi Dave,

I have the exact requirement as you, importing from a CSV file, did you had
any sucess automating the same? I have some knowledge in scripting, pls share
if u made the code, mail me to coolsanthosh82 AT hotmail.com

thanks
 
I, too, scoured my resources for an easy way to do this. My solution was a
little different. I used a keyboard/mouse automatino tool. In EXCEL there
is a recorder that will record our actions then let us edit and replay them.
This tool doesn't appear to have a recorder but I really only needed to
execute a few commands (File/import/from external program .. etc)

The tool I used to AUTOIT and doctored up their NOTEPAD example. It even
allows me to compilet he script into a small executable so I can create the
calendar entry anywhere and could edit the macro to start outlook/ open the
calendar and complete the import of one or more entries.

It's just a thot !!
 
Back
Top