Read Only To All But Two

Feb 18, 2009

i m wishing to make a ss available to all but only ready only format 2 people need access to ammend the data and spreadsheet.

View 2 Replies


File May Be Read-Only, Or You May Be Trying To Access A Read-Only Location

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 you think it's corrupt? Is there anything i can do to open or recover this?

View 2 Replies View Related

Add-in Is Read-only

Dec 8, 2006

I've created an add-in. When I try to update the coding in the add-in, Excel reports that the add-in is read only and prompts me to choose another name for it. However, it is not currently selected in my Tools -> Add-ins... window.

View 9 Replies View Related

Read A Value Into UserForm

Oct 25, 2011

Simply stated:

Range("A5") = Qty
Range("A6") = Cost
Range("A7") = Cost * Qty

In the UserForm:

TextBox1 fills Qty range
TextBox2 fills Cost range

I'd like to have TextBox3 to show the result on Range("A7"). This box would not be enabled, therefore is not clickable or Tab accessible.

I tried

Private Sub TextBox3_Change()
TextBox3.Value = CStr(Range("A7").Value)
TextBox3.Text = Format(TextBox3.Text, "Currency")
End Sub

but that does not do it.

View 6 Replies View Related

Read Table From IE Using VB

Mar 15, 2012

Lately I've been learning how to pluck data right from a web page:

for instance,
cageNum = IE.document.getElementById("txtCage").Value
will read the info right out of the txtCage textbox at the page where my IE object is.

Now I'd like to read a table into excel. How is that done?

View 1 Replies View Related

How To Read CSV File

Sep 14, 2012

I used to read *.txt file into C/C++ program?

Now from Yahoo downloading stock prices, they are in EXCEL *.csv format. How can read them into C/C++ program?

View 5 Replies View Related

How To Disable Read Only

Jul 10, 2013

I've got an excel sheet from a guy at work who decided to lock the entire document down so I can't do anything with it. Virtually all the ribbon options are greyed out, there isn't anything locking it in the code, I've tried checking the save as "read-only" option and it's not there. How I can actually save this is editable? I've looked in windows explorer and it's not read-only in there either. I tried save-as and even tried making it an XLS instead of an XLSM and it still won't let me edit it

View 1 Replies View Related

Read Only Message

May 27, 2007

The xls file I have written is used by multiple users at the same time. None of them can actually change the file - it opens data files and imports the data it needs then writes back any changes to the data to those files.

So the "read-only" option that my users see is of no importance to them - can this be bypassed somehow?

View 9 Replies View Related

Read A .txt Into Columns

Jan 21, 2009

I have a text file that I want to read the data into a sheet and split and store into columns.

The format of the textfile as follows (Only two records will contain 200 with line break to seperate):

Atom "file" contains: C:B_200801142021_VIDEO_BOYS_EVENTS_FIRSTBIRTHDAY@Video Title 1.mp4
Atom "©nam" contains: Video Title 1
Atom "purd" contains: 200801142021
Atom "keyw" contains: VIDEO_BOYS_FIRSTBIRTHDAY
File "F_©nam" contains: Video Title 1
File "F_purd" contains: 200801142021
File "F_keyw" contains: VIDEO_BOYS_FIRSTBIRTHDAY

View 9 Replies View Related

Read And Parse

Aug 9, 2006

Raw data:

1 acct01 John Doe 10
2 acct01 Hits 20
2 acct01 Runs 05


1 acct01 John Doe 10 20 05

View 3 Replies View Related

Is Workbook Read Only

Dec 29, 2006

For a couple of reasons I have had to take a workbook off of a local machine and place it on the network so others can access it. I cannot share the workbook because of the macro's and protection on it. At any one time only one person should have full control of workbook. The others only need read only access. I won't go into the whole deal but I was hoping there was a way on startup to detect if the workbook is in read only mode or not (Other than the basic notifications and indications that excel gives as many users either ignore or do not understand them). If so I would like a big message to popup stating this fact to the user and also if possible show them who currently has it open. Lastly, they would have a cancel workbook open option until they get the other user to exit.

View 2 Replies View Related

Read Only File

Apr 10, 2007

Is that possible that I can make an excel file as a read only through code... and if needed should be opened by giving password ?

View 6 Replies View Related

How To Read Date From Database

Apr 4, 2014

I have a formula that puts a date into a format I want to read date from a data base.

[Code] ..........

Output is correct = '17-03-2014' if the date is greater than or equals to the 10th but if its the 1st for example I get '1-03-2014' which is wrong as I need the zero to count the date properly. I tried a Left formula on a date field to bring in the first 2 digits but because its a date it returns for example 41 instead of 17 if its the 17th. I was going to do a Left(Text type of formula and place it into an if statement but that didnt work.

View 3 Replies View Related

Read Text File Using VBA

Jan 5, 2005

I know how to pull an entire text file
into an Excel Spreadsheet, but I only want specific information from
the text file not the entire text file.

What I have is about 25 text files stored in a folder, let's say
C: est.

Each file is named by a property address as follows:
209 MAIN ST.txt
213 MAIN ST.txt
111 ELM ST.txt
2356 WOOD AVE.txt

On the 11th row of each file is as follows:
Property Address:209 MAIN ST
On the 31st row of each file is as follows:
Total Value:30500

What I would like to do is read each file located in the "C: est
folder and write a record (row) into a single Excel Spreadsheet for
each property. I would like the Excel Spreadsheet to look as follows
once completed. Note the 1st row below is a header row that needs to
be generated by the code.

Property AddressTotal Value
209 MAIN ST 30500
213 MAIN ST 60700
111 ELM ST 20400
2356 WOOD AVE 20900

Can I read a header list (in a spreadsheet, text file, or hard coded in
the code) which I would prefer the spreadsheet or text file method,
write the header row in A1 then B1. Next read the 25 text files and
search based on the header info written above (Property Address & Total
Value) and write the appropriate to the single spreadsheet. The 11th
row of the First text file value written in cell A2, then read the 31st
row of the First text file write the value in cell B2, then loop to the
Second text file and values from The 11th row of the Second text file
value written in cell A3, then read the 31st row of the Second text
file write the value in cell B3, so on and so forth until the last text
file is read and the last record is written.

View 14 Replies View Related

Read The 1st Character In The Hex Code

Dec 8, 2008

I have a set of Hex Code a total of 4 Sets :

A4EC 9ACF 4A02 044E

1. What i need to do is Read the 1st Character in the Hex Code which say A now.

2. Now I need to find if there is another A in this Hex Code. If yes - e.g
A4EC 9A - I need to find the difference between A-A. How many characters are in between the 2 A-A. So for this I have A 4EC9 A so the difference is 4.
2.1 - Another Senario of "A" - A 4EC9ACF4 A the difference is 8 characters

3. Next we will move on to the next Letter which is 4 and do our search.

The key is i only want to record those Hex code which have a difference of 4,8,10,12 differences.

So for that above example I should be able to record the following :

A 4EC9 A == 4 letter difference
4 A020 4 == 4 letter difference
A 4EC9ACF4 A == 8 letter difference
4 EC9ACF4A020 4 == 10 letter difference
E C9ACF4A02044 E == 12 letter difference

View 4 Replies View Related

Saved Files Read Only.?

Jan 8, 2009

I took two weeks perfecting an Excel file and was writing them to disc just now to transport and use on other machines. I opened the file to add instructions and the files are now read only? Propteries show read only on the written files but not on the originals???

View 4 Replies View Related


Jun 1, 2009

I've been trying to use IF OR and CONCATENATE to read 4 cells and give me a list of parts needed based on the data loaded in the 4 cells. I attached an example showing.

View 2 Replies View Related

Read Only The Number Value Of A Cell

Jun 12, 2009

I am trying to get a SUM function to recognise values within a range of cells, that are immediately followed by a *. i.e. 34*

For each range i need to count the total number of inputs, count the number of starred inputs & add up all the values entered.

Currently COUNT doesn't recognise starred values, COUNTIF is set to count only starred values, and SUM wont recognise the value of the starred values.

Is there a way to only read the number element of an input - there are only integer values & starred integer values. The starred inputs are also conditionally formatted. If there is a way would it then affect the COUNT/COUNTIF element?


View 11 Replies View Related

VBA To Read Full Dates Not Just The Day

Aug 5, 2009

I have a macro which searches for the latest date down a column and across particular rows. Extract of the code is shown below:

View 11 Replies View Related

Read Text As Number ?

Sep 19, 2009

=TEXT(B13," dd mmm yy") Formula in C13,I would like to be a number not text

View 7 Replies View Related

Countifs Except When Two Columns Read X?

Dec 17, 2012

I'm trying to find total gross commission within a spreadsheet, where gross commission found in Deals column Q. Columns T & U indicate with an "X" whether the deal was associated with referrals and such.

=SUMIFS(Deals!$Q$2:$Q$500, Deals!$T$2:$T$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")

=SUMIFS(Deals!$Q$2:$Q$500, Deals!$U$2:$U$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")

But now I need to sumif Q2:Q500 excluding rows where "X appears in either T or U, or both, to indicated complete self-generated deals.

View 3 Replies View Related

Open Workbook As Read-only?

Jan 12, 2013

I am running a call centre with 20 users at peak time. I have 1 user who will always have a master workbook open and saving throughout the day. The remainder of the users during calls will need to open this file as read-only to simply view the latest saved version.

This works however sometimes is takes a over a minute for the file to download from the server for the read only box to appear. I was wondering if there was a way for the other users to view it in a simpler and quicker way?

Also issues with the 1 user saving the file which others have it open as read only?

View 11 Replies View Related

Worksheet Is Being Read As Corrupted

Jan 22, 2014

I recently added formulas to the attached worksheet where a cell is linked to a "true" and a "false" which are linked to check boxes. When "true" is activated the cell with the formula will = "HOLD" and when "false" is activated the same cell will ="RELEASE". Now, when i saved this worksheet and tried to reopen it a dialog box popped up that said "the content is not readable.... excel will try to recover the content" (or something like that) so when i click "yes" to the dialog box then the sheet opens fine , however, when i save the sheet the same box pops up? Maybe there is something wrong with my formula because before i inserted the formula to the sheet the sheet worked fine.

See attached TEST1.xlsx

View 4 Replies View Related

Read And Compare Node Value?

Jun 3, 2014

I am reading the xml files like below:

[Code] ......

When a file is read/loaded in DOM, I want to search whether my provided value(Not the key) is present in the file OR not.

If it is present then I want to update it with new value. This should be done for all of the files present in the folder.

View 6 Replies View Related

How To Make Columns Read Only

Aug 7, 2014

Is it possible to make Columns Read only? So not one can type or edit. Not all columns just the ones I need


View 2 Replies View Related

How To Make Cell Read Only

May 9, 2006

I have tried the following code, but doesn't work unless I protect the sheet:

Selection.Locked = True
Selection.FormulaHidden = False

If I protect the sheet, then it works fine, but how can I make a cell read only

WITHOUT protecting the sheet?

View 13 Replies View Related

Add-in Opening A Workbook As Read Only

Feb 9, 2009

I have created an Add-in for use across the business, the add in calculates financial impact based on figures that are stored on the shared drive.

The addin currently opens the workbook, and sets the variables to figures contained in the workbook - and then closes the workbook.

To roll this out to the business - I need to get the add-in to open the workbook as read Only, so that it will allow multiple users to access at once. I have set to open as read only in the past - however this prompts me to save the workbook as something else.

Is there any way I can get this to just open as read only, do what it needs to - and then close; without having the option to save as something else?

View 8 Replies View Related

VBA - Read Values Of Many Cells

Feb 25, 2009

Excel 2003 > I am developing a comprehensive VBA function that needs to read the value of many cells in a worksheet. I don't want to Name all those cells because then I will need to pass too many variables to the function. I can use the following set of objects and properties ...

View 6 Replies View Related

Save A Workbook In Read Only

Apr 23, 2009

i need a way to alter the state of a workbook to "editable" then save and then switch back to "read only"

reason being is i need to hide tabs evertime the workbook is closed

View 8 Replies View Related

Run Macro Only If Workbook Is Read-Only

Jun 11, 2009

I was wondering if there is a way to set a macro to run on an event only if the workbook is read-only. The macro I have set up right now reformats the toolbars to a custom user friendly one, but I want to be able to open the document with a password and not have the toolbars rearange on me.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved