Recent content by aamirault

Workaround found Hi All, Thought I would post the Microsoft workaround for this isssue. All you need to do is share the workbook and allow others to update the workbook. Since this removes the exclusive lock Excel will not prompt you. Hope this helps others.

Hi, I have code that imports data from excel, and it works great however the problem is an annoying pop up once the import is done telling the user that the file is available for editing and giving them the option to Read-Write or cancel. How do I get rid of this box when the impport is...

Thanks Peter! Your help is greatly appreciated, and yes, it works great! Aaron

Remove Record Selectors and Nav Buttons Under the Form Properties Format Tab Set Record Selectors and Navigation Buttons to "No" HTH, Aaron PS. You may want to set dividing lines to No for a cleaner form presentation

Hi All, I am trying to make 12 smaller tables from a table which I imported from an Excel File, basically the file has 12 Worksheets and all were imported from the file using the VBA code in a module: Public Function xlsImport() Dim xlWB As Excel.Workbook Dim xlWS As Excel.Worksheet Dim...