Refresh via VBA

[mohitjain]

Hello,

i have created one user form tro which we can insert records in excel file.
I have made this excel shared so that multiple users can access at the same time and can insert records..
Now my problem is If two users have open the excel same time and inserting the records in the excel , the record got inserted in the same row (for eg row 15)and create a conflict..
Is there any way to refresh the excel so that while updating the excel tro user form it will get the letest row (row 16 if another user has entered the record)
Is there any way to refresh excle thro VB..???//
It will be really grt if any one can help me on this...

mohit

[Richard Buttrey]

Hi,

You need to check out the workbook sharing functionality that's incorporated in Excel. Tools, Share Workbook....

HTH

[romperstomper]

FYI, I strongly suggest you avoid Shared Workbooks. They are notoriously prone to corruption, bloat and weird behaviour. If you need multiple user data, use a database program if at all possible. If you must share the workbook, make sure you keep regular backups and clear it out periodically!