End Sub How Do I Modify This To Fit My Specific Needs? I am not doing anything but closing the workbook and not copying if it is opened. Since that time, Grundy has written many guides to using various applications that are published on numerous how-to and tutorial sites. Currently I have this user running the file every hour using Win7 Task Scheduler. This is a little over my head, but I will play around with it and show it to co-workers. The file runs in Read Only fine, so.
I have one more question, because it stills asks me the following: MyPaper is locked for editing Read Only Click Notify to open a Read Only copy of the document and Notify receive notification when the document is no longer in use. Select For Each CurCell In Selection If lastCellFx. Is there a way to check if I have the file opened, and then set the focus to that file instead of opening it again? If you set a password to open the document the users will not be able to open the file without a password. Feedback Buttons provided by - Copyright © 2019 DragonByte Technologies Ltd. Copy and paste the following code into the Visual Basic editor window: Sub NewWordDocument Dim wrdApp As Word.
All contents Copyright 1998-2018 by MrExcel Publishing. Your Excel username will appear below. Activate End If End SubI added the piece to check if file is readonly. I can guarantee 9 times out of 10, one of my strategies will get you the answer s you are needing faster than it will take me to get back to you with a possible solution. I have a macro that opens up a file of forms, makes customizations, and saves each worksheet in that file as it's own form in the new project. You may have to before you can post: click the register link above to proceed. Press the F5 key or click the Run button to run the code.
When the file is opened, a message is displayed asking the user if they wish to open as read-only. Carl AccessGuruCarl Programmers helping programmers you can't find a better site. Provide details and share your research! I am creating a spreadsheet for work that has several links to word files. See my 1st and Last Post. This served as a good check and also prevented a bunch of confusion. The best option is to restrict access to the folder in which file is saved. You may have to before you can post: click the register link above to proceed.
Click on the Like button under the post! Please take your time to try the suggestions and let me know the results at your earliest convenience. If I open the workbook directly, and it is already opened by another user, Excel then displays the message. Update This seems to have resolved our issue. Therefore, I only need to open it read-only. I found this code worked. There are several excel and pdf examples here in the forums.
The Save As window will appear. What's interesting is that I don't get the error every time - I can't tell you what it is right now because right now my code works fine :. Hey gang, I think what I want to do is simple but being a relative newbie, I haven't been successful in doing it myself. Chances are this post did not give you the exact answer you were looking for. To start viewing messages, select the forum that you want to visit from the selection below.
The setting you want is in Excel, not in SharePoint. I am merely testing that the user will not get an error while it's opened and exit the macro if it is opened. I have a database of names in one excel file. Please could someone be so kind to give me the proper coding to add?. What I want to know is this; is there a way to open a document in word but for 'Read Only'? Select No, the file definitely exists. Look around, I'm sure you'll get pretty close to what you need.
This is certainly more stringent than the non-password option. Programmer Join Tek-Tips ® Today! I know it's a read only workbook. Hi everyone, I have a problem. Kutools For Excel Brings 300+ Advanced Tools For Solving Work Scenarios, Helps You Solve Excel Problems. If you don't like Google AdSense in the posts, or log in above. It is important that the password is only set for modifying the document.