Good idea, but we can come out of that situation.
Harish, Just put a line in the macro before msgbox: activeworbook.save hope that solves the issue On Tue, Apr 14, 2009 at 8:55 PM, santosh bahuguna <santoshbahug...@gmail.com > wrote: > > working with share file is much diffcult to fix this problem in excel > becouse every user will seat in different different pcs and everytime > user have save the data to make the data sheet update my suguestion is > this please user msaccess to perform this task > > thank > > santosh bahuguna > > > > On 4/11/09, Harmeet Singh <harmeet.hew...@gmail.com> wrote: > > Bingo. > > > > See attached file. > > > > On Sat, Apr 11, 2009 at 4:35 PM, Harish Sharma > > <harishsharma...@gmail.com>wrote: > > > >> Hi Ashish, > >> > >> Can you please help me with the file attached. > >> > >> I have raw data in first sheet columns "B,C&D" and I have 9 associates > to > >> work on this data further but I want now to build a macro where if any > >> agent > >> click on acquire button(will be available in respective agent's sheet) > he > >> gets the data (first availabel data in the raw)from raw data sheet in > FIFO > >> basis and all the agents will also be working on the sheet together so > it > >> would be shared. > >> > >> But the data should not be duplicating and raw data should be protected > >> and > >> once the data is acuired by any agent his name should appear in first > >> column. > >> > >> Thanks in advance > >> > >> -- > >> Kind Regards, > >> Harish Sharma > >> > >> > > >> > > > > > > -- > > Thanks & Regards, > > > > Harmeet Singh > > > > > > > > > > > -- Thanks & Regards, Harmeet Singh --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
