I have developed a small macro code which saves a record into Excel 2007 when any of my team member sends Meeting Request from Outlook 2007 to Manager for "Working From Home".
Record contains Sender name, date on which sender wants to apply Working From Home.
Coding wise its working fine.
But the thing is the excel is located in the team server. So when anyone who is sending Meeting Request from Home, it gives pop-up
dialog box that
"Excel file does not exist".
But if anyone is applying for "Working From Home" in advance in the office itself, the record is saved in Excel.
So can you please figure out the exact issue and also specify me the solution ASAP.
Edited by Swathi Shankar, 15 September 2011 - 11:45 PM.