read

Is there a way to make this save the copy as read only? path = "\\hinas1\MFG\LED\SSL Paperwork\U502\U502FogLBFirstArticle" nom = Left(ActiveWorkbook.Name, (InStrRev(ActiveWorkbook.Name, ".", -1, vbTextCompare) - 1)) & " " & Year(Date) & "-" & Format(Month(Date), "00") & "-" &...

This is just a question out of curiosity. It's about reading files that are stored online like txt, log or csv files. I know I can download these files and do my thing but that's not the issue here. When I run this code for example I can read the information in the online stored txt file and...

Hi! I have a file in the local network to wich i have a shortcut on my desktop. The thing is I usually want to open it in read only. Is there a way of doing it through the shortcut, maybe with some special lunch parameters? I don't like doing this through the open excel program and its menu, it...

Hello, Currently when calculating invoices over 60 days due, the result is: <tbody> 2807.14861111111 OVER 60 How do I format to read 2807.15? My formula is =SUMIF($A$5:$A$200,"<"&TODAY()-60,F5:F200)&(" OVER 60") A - Date column, F - Amount due column I have tried using both round & text at...

Hi I just read that workbooks(1).Name is read only. I wonder how to change the workbooks(1) name in vba? Do I need to be in another workbook? Thank you so much.

I am trying to read cell A1:A1500 on closed workbook C:\TimeCards\CivlianAlphaRoster.xls for loop info on open workbook to save as filename. I have tried for 3 days with no results. Can someone help to see what I may be doing wrong? Mega thanks for any help. Short VBA is below. Sub...

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody> 1 2 2 3 4 5 6 6 7 8 9 9 550 800 800 1400 1600 1600 1800 2000 2550 2800 3600 4000 </tbody> I want to write some syntax that allows the numbers on line 1 from 1-9 to...

Below is the data in my two different sheets: Workbook1 <tbody> LastName FirstName NewPermission <tbody> Aadhi </tbody> <tbody> Vetrivel </tbody> <tbody> Risk Quality Reviewer II </tbody> <tbody> Abudhahir </tbody> <tbody> Imrana Parveen </tbody> <tbody> Risk...

Hello, A workbook I have been using to supply data to my front end vb.net project(it fills in a list box) has suddenly become read only.If I try to modify the file it allows that but when I come to save it I get all of this read only stuff and the only way I can save changes is by saving the...

Ok I can't understand exactly how to get a sum of the time in and out then time in and out after lunch but I need it to calculate by the 15 minutes 8/7/2018 IN OUT 7:45 AM 12:00 PM 12:30 PM 4:00 PM 7:45 The formula i have is =SUM(G21-F21)+G22-F22 but I need the...

lubumbashi 356 kitwe 320 kasumbalesa 356 lusaka 325 ndola 300 kipushi 425 zambia 325 those are road toll fees for those country formula on any cell to read b6 and plug the exact road toll I have done this but dont recall how i did it

Morning all My company have a data register in Excel which when opened, gives the user the option of opening a read only version instead of the main file. This is useful as those who just want to check an entry can do, without blocking others from adding to the register. The issue I have is...

Hi, I have a macro set up in my personal workbook but the Personal workbook file is really annoying me. Every time I open an excel file a pop up says the personal workbook is locked for editing. I can only open the personal workbook as a read only meaning it can't be edited/saved etc. I have...

Hi, I'm hoping someone can help me, I'm trying to import some data to one of our systems in a csv(Comma delimited (*.csv) file. I have a column containing ID numbers (must read this) column below, when i save the file the number string changes to the following (Converts to this) column below...

I have heard about using sum(sumif) but in the examples, they use the value. I want to use the cells. Can someone please fix this formula for me please...

Dear readers, I know this is a common question as I have read other threads related to this issue. But it seems I can't apply the solutions from the other treads - probably due to my lack of experience with VBA. So I hope someone is able te guide me in the right direction I use to keep track...

Hello. Thank you for looking at this problem of mine. The help I am requesting relates to the speed of a VBA user defined function. I have a function which works correctly, as below (relevant parts): Function placeholdername (arg1, arg2, etc) As Double Dim data_table As Range …..Other...

Does anyone know why Microsoft has built Excel to where if sosmeone opens a file in read only, why I cannot open the file in edit mode? This is really frustrating, I need to edit the file and if I am not the first one to open the file, then I am not able to edit it and i have to go track down...

Hello, I have a table the looks like the following; <TBODY> Jan Feb Mar Total 11.75 6.00 17.75 21.50 19.75 41.25 </TBODY> These are total hours calculations. How do I convert the Total column to days? I got the Total/24, but I need it to look like the following. For example...

I am guessing that this topic has been addressed in the past. If anyone knows of where I can find the information that I seek I would greatly appreciate it. I keep my inventory in Excel Column A is a list of numbers that are unique that are also associated to the barcode on our boxes I have a...