read

Hi, I have a shared excel workbook that has a bunch of macros in it. I have it set to open up in read only so users can't modify the information in it but I want to be able to know who has it open. So I was wondering if there is a way to check what users have the file open in read only. Is this...

Hi. I need to read a file, based on latest date. Using VBA. I really don't know how to do since before this I only put exact name of the filename. I know how to do it using vb.net, I do like this, Dim stamp As String = DateTime.Now.ToString("yyyyMMdd"...

I have the following data: <tbody> A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses </tbody> Whenever a team wins, a 1 is entered manually into Column B or Column D...

Hello, I am new to the group, thanks for letting me join. We have a tool we use for estimating that I have been automating with VBA. When we win a project I need to take some of the sheets and copy them to a new workbook for a handoff document to project managers. The trick is that I would...

Hi, My code I currently have... =IF(OFFSET(A8,0,1)=OFFSET(A8,-1,1),OFFSET(A8,-1,0),OFFSET(A8,-1,0)+1) Basically if the value in the cell next to it is the same as the one above then the value of the cell the formula is in, it'll be the same number correlating to the one above... Makes it...

What is wrong with this formula? I should be getting a result of 104 but i get no value returned. No error in the cell either. The cell is blank. =SUMPRODUCT(($I$3:$I$2000="")*($E$3:$E$2000="51014")*($K$3:$K$2000)+($I$3:$I$2000="")*($E$3:$E$2000="51010")*($K$3:$K$2000)) I'm asking it to read...

I had password protection added to a workbook so other viewers could not make changes. I removed the protection and re-saved some of the worksheets. Although a password isn't required to open any of the re-saved worksheets, a pop-up appears on opening advising the user that selecting Yes will...

Hello, I have been given a task to check the difference between 2 times in a transcript. The worksheet that I have been given has each transcript inside a single cells (1 cell per transcript). what would be the best way to read each line inside the cell? Do I copy the contents to a temp text...

In XL 2016: Is there a VBA fileformat for saving an Excel file explicitly as ver 2007? I have a legacy program that can read an Excel 2007 xlsx file, but not 2016.

I have some lines in a text file. the lines were written in a way such that the last line is added at the bottom. i have a listbox that i want it to read the lines in the text file in a reverse order i.e from the last line to the first line

Hello all, I'm trying to do something, which seems fairly simple in my head but I can't get to execute in a formula. We record data daily on on a spreadsheet in a new column every day. Some days certain cells return a calculation, others return NA if there was no activity. I originally...

I would like a message box to pop up when a cell in a range changes. The cells in the range all have IF formulas in them. My problem is that the code i am using seems to only read the formula, which doesn't change, hence nothing happens. How can i get my code to read the cell value, which does...

Help! I have been developing a payroll environment in excel for my business to use. After overcoming several hurdles, I find myself stuck at one last one. In the workbook I have an Employee Info sheet wherein I contain indicators for their tax bracket (Married or Single) and the number of...

Hi I have macros that are shortcuts to books that numerous people use. I know how to record the macro to open the book but dont know what to add when its opening as a "READ ONLY" as in the message box warning it read only. Can anyone help?

Hi, I may just be dreaming... If there are many comments on a worksheet, and we click a macro button that shows them all, some comments may hide others, so we cannot read them all. My comments are programmed to autofit. So, they occupy minimum space. The button acts as a toggle button and...

Hi I am reading a article about when I should user ( ) and when not. I wrote a code below but not sure why Y =1 Sub myfoo() Dim x As Integer Dim y As Integer x = InputBox("enter number") y = MsgBox(2 * x) MsgBox y End Sub Also, do you know where I can read about this...

hello all, I am currently working on a web site with a description column that cannot exceed 75 char. The data I have exceeds that in certain circumstances. Is there a VBA or formula you all know that will do this: Read cell content from right to left. Stop at the 75th character then cut all...

Hello all, I am at a loss when it comes to VBA. I have googled, but not been able to find the ideas I am looking for or to how to make it work. I am running a Mac 10.14.3 and Office 365. Here is what I am trying to accomplish: 1) I want the user to read the instructions page, then click a...

Hello...I have downloaded VBHTML Maker so I can post code so it's easier to read, but I just saw that it does NOT work with Excel 64 bit (which I have on my machine). Is there another way I can easily post code to the forum without doing a straight copy/paste, thus making it hard to read...

Hi, We have a form in excel which has to be exported to pdf and then it as to be sent by e-mail. The VBAcoding is finished and works just fine, but it doesn’t work when it’s put on aSharepoint workgroup with read only access. I think it has to do withtemporarily saving the pdf before it’s...