I'm using MS Access to open an Excel file and read information from it using the 'Microsoft Excel 8.0 Object Library'.
The file being opened is most likely located on an network drive. When another user on another machine has it open exclusively my excel object doesn't know that someone else...
I have an Excel Workbook that users enter data into and then press a button and the data gets processed into another application.
The processing occurs in code (one call to the other application per row) and I'd like to save the worksheet after each 100 rows have been processed. The update...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.