read

I added a password to my spreadsheet by going to "Save As", Tools, General Options and added a password to "Password to modify". What I am encountering is when someone opens the file in Read Only, it is locking me out from editing. What I am looking for is when someone opens the file in read...

Hi everybody, I've got a shared excel file and sometimes excel displays message box saying: "excel_file.xlsm is locked for editing by 'Homer Simpson' Open read only or click notify." Usually I'd click on the 'read only' button. But is there a way I could extract the name of the user editing...

hi I have several excel files with vba code, using 1 data file. how can multiple users work with 1 data file? also, how can i work with data file without opening it each time i need to read some data from it? i will explain: 1st excel file read some cells from sheet1 on another excel file. if...

Is it possible to read and display formatted text from an external text file into a text box object of some kind, or the worksheet cells themselves? The only formatting I need is font type, size, and bold/italics. I was thinking there must be a way to read an HTML file that contains the...

Hi everyone, I can not get started with a Problem, I have. There is a folder with several excel files in it, all of these files have the same structure and the cells are already named. Now, i want to extract the data of the cells in the folder and fill them in a new "target" excel file. I...

Hi all, I need some help regarding Index/Match as I'm not sure why this isn't working. <tbody> A B C 1 Jan Feb Mar 2 30.2 40.2 60.0 3 5.4 15.1 90.1 4 30.1 40.5 50.3 </tbody> in the table above, I want to output which Month has the largest value (so in this case, my output should...

Here's a snippet of code that reads in a big txt file. It used to work but the size of the INPUT text file grew such that I'm now getting an out of memory error. On a whim I changed objTS.Read(objFile.Size) to objTS.Read(objFile.Size / 20) and the file is getting read again but apparently only...

Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data...

Hello, I have a problem, maybe it's simple but I'm not able to solve this, thats how my sheet looks like: <tbody> Name Jobnumber Sandro A801336.00 Alex A801233.01 Sandro A802444.00 </tbody> In Cell "J" I'm using this Formula to read out a specific value...

Hello, I'm a newbie in Excel VBA. I have a task assigned where I need to read the inputs from a excel file,like reading of different test cases and paste the outputs(after formulas and all applied) in different sheet everything through a VBA. I don't have a JSON data or a URL to read the data...

I understand that the text property for the Range object is a read only property. Does this mean that I can use this to paste a value in a cell though I can read a cell as text? Are there any good articles that explain what a read only property does in VBA as opposed to a read/write property...

Hey Guys quick one (hopefully ;)). I have a cell that contains multiple text entries. I would like to find dates within that cell. I've partially solved it however I can only find the first date. For example: currently the formula I have finds the first date by search for the word review...

I have moved my excel personal macro workbook to a shared drive and have created a shortcut into the XLSTART folder for everyone on my team. This way whenever I update one of my macros it updates everyone on my teams at the same time across multiple computers. I am running into a problem...

Hi all, I have a userform with text boxes for users to enter numbers, and I have labels set up to display the sum of the entries from those text boxes. If a text box is empty, it is throwing an error when the sum function is triggered. Is there a way to set the form to read blank text boxes...

Hello, I am creating a databse to hold Risk Assessments, when a new Risk Assessment file is created and saved into the correct specific folder, excel picks this up and automatically generates a hyperlink to that file and also when the file was created into the database. In the new files that are...

i have the following code that saves a copy of a file to a location. Is it possible to make it save the copy as a read only? Sub Button28_Click() ActiveSheet.Unprotect "987654" Dim nom As String Dim path As String If Range("K45") <> 34 Then MsgBox ("Review Your Entries, Something Was Missed")...

Hello. I have some VB code that saves a file in read only. What I want to do is save over it daily. I am using Office 2016 and would like to know how to "resave" over the 'read only' file daily. Here is the subroutine I am using: Sub ReadOnlyFile() On Error Resume Next 'Keeps going if there...

Hi Lets say A1 cell is green. I want to check the color of A1 and type Green in cell B1. Is that possible? and if A1 color is red then B1 will read "Red" Thank you.