VBS To Open Excel File As Read Only?
Jan 31, 2014
I have a excel file that opens and will automatically run a bunch of tasks if a certain user opens it. This user is only used to automatically run this excel file, other users need to open the file occasionally to edit emails address, add clients etc stuff like that, that the automation part of it works off.
Currently I have this user running the file every hour using Win7 Task Scheduler. This is working well, except for the time when another user is editing the file on the hour and of course the Automated user gets the "this file is open blah blah blah, open as read only, cancel etc" popup, this stalls everything, and if I dont notice it, it could sit like this for days.
The file runs in Read Only fine, so... Basically my question is, how to open this file as "Read Only" using Task Scheduler? As if it just ran as Read Only all the time then it wouldnt matter what other users were editing at any given time.
One of my ideas was to have Task Scheduler run a VBS script instead of running the Excel file directly, and having the VBS script simply load the Excel as Read Only.
View 5 Replies
ADVERTISEMENT
May 31, 2013
I've got a spreadsheet that has password protection before you can "modify" it. All of a sudden today, when I open the spreadsheet and enter the correct password, it still opens but only as Read Only.
View 3 Replies
View Related
Jan 16, 2010
1. Check if file is already open
a) If Not then Open the File
b) If It is Open then Show Message That File is Open And Will Load Once the user close it.
2. Check When the file is Closed And Open it
View 3 Replies
View Related
Oct 7, 2008
I have a workbook set up with hidden worksheets available only with a password. What I would like to do is set this up so that those employees who have the password will have full rights to make changes, while those who don't have the password will have "read only" rights. It should always open as a "read only" file, and then change to full rights when you enter the correct password.
I've also set this up so that it cannot be printed; can I also set it up so that it cannot be saved anywhere on our local drive?
I have the macro set up to limit the access via a password, but don't know where or how to set up these other changes.
View 9 Replies
View Related
Nov 27, 2011
I have a VBA script that has been running fine for months on one computer. Today, I ran it on another computer and it opened files in read only mode which disrupted everything.
The file open command is the following:
Workbooks.Open Filename:=sourcePath & sourceFileName
I searched the entire project and appended ", readonly:=false" to every open command. So, the command became
Workbooks.Open Filename:=sourcePath & sourceFileName, readonly:=false
Still, Excel opened the file in read only mode as seen in the title bar (filename [read-only]).
If I double-clicked on the file and opened it, it's NOT in read only mode. I checked the property of the file. It is NOT read only.
View 2 Replies
View Related
Jan 11, 2007
I have a read only excel file which I want to interrogate in another report.
I'm writing some code to open the file but I'm not sure how to get past the password/read-only prompt when opening the file.
My code is:
Workbooks.Open Filename:= "C:Sales2006.xls"
I assume it's possible to write some code to get past the prompt. I have checked the help files which do seem to indicate it's possible to specify a read only property but it doesn't say how.
View 5 Replies
View Related
Aug 12, 2009
I understand that vba can determine if the current file is read-only using the following to return true / false. GetAttr(ThisWorkbook.Path) And vbReadOnly
which seems to work fine for determining if the file is read-only, as there is another instance of the file already open. However when opening a file straight from a zipped directory (i.e. not extracting the file first), Excel opens the file as read-only. The above code returns false in this instance, i guess because the workbook path has a .zip ending rather than the normal .xls etc endings. how to return true that the zip file is read-only?
View 2 Replies
View Related
Apr 9, 2008
Is there a way to remove the option to open a file as read only when the file is already open by another user? Ideally when a user tries to open a file that is already in use they would get a message to that effect and the only option at that point would be for them to select "notify" when file is available.
View 8 Replies
View Related
Dec 11, 2009
I need help for reading data from text files and saving it under different columns in the excel file using vba macro.
For example: I have many text files in the following format ....
View 9 Replies
View Related
Aug 13, 2014
i have a file that needs to have daily postings to it, I would like for it to automatically generate today's date and then if you change figure 1, it carries over to figure 2.
View 3 Replies
View Related
Jan 4, 2007
I'm trying to open a file on a network drive...but I'm getting the following error message when it opens: "This file may be read-only, or you may be trying to access a read-only location. Or the server the document is stored on may not be responding." Now, the file itself has no rights restrictions and is not read only. It doesn't appear to be locked.
Now, there are other Excel files in the same directory which I could open fine; however, the Excel documents having the above problem all have a little black icon "appears to be a padlock" (image attached) at the bottom left hand side of the Excel file icon. I tried the following:
- Renaming
- Converting to a different file format (didn't work, it won't let me)
- Opening in notepad...etc doesn't work.
This file is dated back in 2004...do you think it's corrupt? Is there anything i can do to open or recover this?
View 2 Replies
View Related
Feb 11, 2014
I need a VB code to open excel files located in a path (fixed path) by providing a part of file name through a input box
for ex: I have some files located in my local drive as below
1. colurgreen.xls
2. colurred.xls
3. colurblue.xls
I need a input box asking for file name and I input "green" or "red" or"blue" and it should open the resp file.
View 4 Replies
View Related
Apr 24, 2014
I need to open an excel file based on a date mentioned in the file name, but minus 1 day. The file name is composed with Statistics_date_time.xls
Example: statistics_20140423_142754.xls
Once I need to open the file (only in the mornings), it has to be the one from the previous day to see the yesterdays performance. How can I create a macro that will look at the date in the file and take the one from yesterday?
This will be a part of a macro I'm making. The rest of the macro will just format the file and combine a few ones from different departments.
View 4 Replies
View Related
Dec 7, 2013
I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.
I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.
I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.
Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String
[Code].....
View 2 Replies
View Related
Feb 18, 2009
I have a folder that contains many excel files. Each excel file is named as that date it was created, i.e. 02/18/09.xls
I would like to have some vba code that will open 'todays' file. Here is what I have so far:
An Excel file with the date founction in A1, =today(). I'd like to have a button that reads cell a1 and opens an excel file in a specific folder.
View 8 Replies
View Related
Jan 13, 2013
do a code to open a closed .txt file. Once opened, the data inside of it should be copied on the macro workbook sheet 2 column F. I want the macro to perform a loop until all the .txt files have been opened and copied on the specified sheet and column. No worries I will still include some codes in between .txt files so no overwrite will happen. By the way I want to open the .txt file in sequence base on the file name listed in sheet1 column B2 onwards.
see below list
File Name
1.txt
2.txt
3.txt
4.txt
5.txt
6.txt
7.txt
8.txt
9.txt
10.txt
11.txt
12.txt
So the first .txt file to be open is 1.txt followed by 2.txt and so on it will loop until all filenames have been opened and copied. Path of the file will be in C:SAMPLE
View 1 Replies
View Related
Oct 12, 2013
I was able to open and read this file before installing Windows 8.
The background to this is that after installing Windows 8 and reinstalling Windows University 2010 my word documents and excel files where all opening up as word pad documents. I figured out the solution to the above on my own and I am now able to properly read the excel and word documents that I tested. But I am not able to read a very important excel file. It is very important that I restore somehow this file.
When I open the excel file a dialogue box open up saying "Excel found unreadable content in "Account.xlsx". Do you want to recover the content of this workbook? When I choose Yes the following dialogue box opens up saying "Excel cannot open the file "Account.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the extension matches the format of the file".
The file extension is set to xlsx however how do I test to see if it is corrupt. Is there anything I can do to restore this excel workbook?
View 1 Replies
View Related
Apr 26, 2012
While opening one Excel file I get an error message saying that a 2nd file could not be opened because it cannot be found. I do not want this 2nd file to open. WHere do I find the "command" that is telling this 2nd file to open.
View 3 Replies
View Related
Nov 8, 2012
I seem not to be able to solve, regarding an Excel VB6 integration.
I wish to check if a specific Excel file is open at any given time (I'm using a timer for this.)
This is what I had so far, but I need it to be checking prior to this and I don't like this solution really (wasn't complete.)
Code:
Private Sub Command1_Click()
Dim oXLApp As Excel.Application
Dim oXLBook As Excel.Workbook
[Code]....
View 5 Replies
View Related
May 4, 2009
I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size.
But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else.
Is there anyway then to open the file or to reduce its size without opening it (through magics...)? I just honestly don't know how to retrieve that info before deleting that file.
View 9 Replies
View Related
Jan 10, 2010
I work for a company that has about 650 locations. Each location has a location manager that is responsible for submitting a Performance Review spreadsheet for all the employees at their location.
Currently I have an Excel file that has all employees/locations. One of the columns on my spreadsheet is "Location ID"...which is literately a number we've assigned to our Locations. I have an Excel template saved that I'd like each Location to open into.
Can someone help me? I need each location to be it's own spreadesheet...which I have a template created already. I'd prefer to find an automated way to do this...rather than manually creating 650 spreadsheets.
I'd prefer to do this in anoter application, such as MS Access, but senior management already made the decision this will be done in Excel...so I'm stuck with what I got.
View 13 Replies
View Related
May 27, 2013
Is there a way to Open or Import a PDF file in Excel 07 ?
View 2 Replies
View Related
Oct 17, 2013
I received a USB drive from a client with an Excel spreadsheet with hyperlinks to PDF's (not sure of the version it was originally created in but my version is 2007). The PDF's are in another folder on the USB drive.
The cells with the hyperlinks have a formula to hidden cells [i.e. =HYPERLINK(C17,B17)] - in column B is the name of the hyperlink and in column C looks to be the file trial to the PDF (please see attached picture).
When I select the link, I get an Alert Box stating, "Cannot open the specified file." How I can get these links to work?
Excel Hyperlinks.png
View 1 Replies
View Related
Dec 10, 2013
I have excel file having macros and many formating , I have protected with password but in my office there is only 3 pcs having MS office installed out of 18 pc, all other pc have installed open office. formula and macro is not supporting in open office and also Macro which i have procted in excel easy viewing in open office without asking password (which i don't want )
I want to restrict the file to open in pc where open office installed.
In short excel file should not open other that pc where MS office is not installed.
View 5 Replies
View Related
Jul 18, 2014
I have created several excel files as I cannot open them all at once since they are too large. So I have to open one excel file whilst closing another.
part1
part2
part3
part4
part5
I want a macro that opens the excel file part 1 and part 2. Then it should close part 1 and after closing part 1 it should open part 3. Once part 3 is open, part 2 should be closed and when part 2 is closed part 4 should open. When part 4 is open, then part 3 should be closed and part 5 should open.
View 1 Replies
View Related
Jan 30, 2014
I have emails come in daily to my outlook 2010 as an excel attachment, is there a way to open these attachement in excel by running a macro?
View 4 Replies
View Related
Apr 11, 2008
I have a Listbox which brings up a list of files in 2 folders. The code works perfectly and I have no problems with it however I would like to add a further bit of functionality to the ListBox using:
View 12 Replies
View Related
Jul 17, 2009
I am just wondering if there is a way of checking if the workbook that is currently open is the only one that is open, as I have been asked to make my code exit the application if this is the case rather that just close that one file.
View 6 Replies
View Related
Apr 27, 2014
How can I change this;
Code:
Sub GetData_Example4()
Dim SaveDriveDir As String, MyPath As String
Dim FName As Variant
SaveDriveDir = CurDir
MyPath = Application.DefaultFilePath 'or use "C:Data"
[Code] ....
So that it still prompts the user for the path but limits their selection to only Excel files and only those named 'Roles'?
View 7 Replies
View Related
Jun 3, 2014
I saw one of my classmates do quick normal distribution by the click of a button and when I asked her she said she used VBA function of Excel.
This is what I would like to do: Have a macro/VBA in one excel file. And using that excel file do normal distribution for an excel file that's opened in another window.
View 1 Replies
View Related
