file in use

I'm currently using the loop: For i = 1 To 10 Application.Workbooks.Open ( files(i) ) Next To open several excel workbooks. It works fine, but the standard message "File in Use" message box doesn't display, and the files just open in Read-Only mode without warning. Is there any...

Hey All, This is my first question on this site. I use it all of the time by searching through the forums. So I thought I would finally join in the fun. :) Anyhow, time for business. I am running into a problem with the "File in Use" alert. I am attempting to write a code to automatically...

Hello Everyone, I have a macro that opens a word document template that I have saved on the C:\ Drive, changes a few things in it, saves the file as a new name, and then leaves it open to let the user manually edit the rest of the data needed. This works fine, but when I change some data in...

I have a report that I run every week that I need to save as the existing file in the folder. Invariably, someone has this report open, but the message box only says "another user" so I don't know who to go to. Is there a way to force close the file on the network, so I can save the new report?

Hey guys I need something to check if a file is in use, and if it is, abort the procedure, else proceed with update macro. (Company is on a citrix environment) I've found one code on another site that looks like it would do this, but it's a Function, and I've never used one of those before...

Hi. My Excel file is located on network drive and I have a macros which automatically exports data from outlook message to excel file. In case some other user has opened this file I can not run a macros, because file is read only. There is a KB article "Macro code to check whether a...

I am trying to run a macro and everytime I select a file it tells me the file is in use and locked for editing. Why won't it let me open my file? Please help.

Hi Guy's, I've got a form where the user inputs information into 2 textboxes. Then selects save. This opens another workbook, writes the info into the next blank line, saves it, and then closes it. This all works fine. As this file is on a network, I’m trying to pre-empt any possible issue...