modified

I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!

Hi all, I'm very new to VBA and macros and am struggling to find a solution for what I would like to do. I am using some code that i found to show the date and time that a worksheet was last modified in a given cell. This does not update on it's own. The only way that I am able to update the...

I have worked out a UDF which replicates Excel Rank() function. Now, I am trying to modify it such that instead of outputting 1 2 2 4 as the ranks for a set {2,5,5,8} it should output 1 3 3 4; and it should be able to handle any data as per the modified logic. Public Function Rnk( _...

Hey, I want to change the ""Modified Date"" of multiple folders in Windows Explorer as per date mentioned in Excel Cells. Thanks in Advance..

I have this array formula which calculates the highest decimal place in a range. {=MAX(LEN(SUBSTITUTE($A$1:$A$9,TRUNC($A$1:$A$9)&"","",1))-1)} How can this be modified to return the lowest decimal place in a range?

I have a spreadsheet on Onedrive for me and my employees to keep track of our machine hrs for maintenance. I use Excel 2013 Pro to set it up. I need to be able to have the date that one cell is modified be enter in another cell to the right of that one. Say I have column "D",with the machine...

Morning. I was wondering if its possible to rename a bunch of pdf files that reside all in the same folder ? Currently the files are just named like, 1.pdf 2.pdf 3.pdf All the files have a date modified next to them for viewing purposes. Can we run a macro that will rename these files & get...

Hello, I am trying to find a way for an automatic date stamp to be populated into a field (Col J) in a row when any other cell contained within the same row is changed or modified. I know this is easy just haven't figured it out

I have a list of files that are lined up using D:\Documents\* with the function =IFERROR(INDEX(FileNameList,ROW()-2),""). With this it lists all the files in my D drive. I'm trying to also display the date last modified of those files in the corresponding cell. Is that possible to do?

Hi all, I'm building an invoice system here and I'm stuck on a part of it. I have all my invoices stored in a folder with filenames like: 0001 Name 0002 Name 0003 Name On my worksheet, I want to be able to run a macro when the master workbook opens that will search the invoice directory on my...

OK ... I searched before posting ... and almost had it. I simply want to list the date a file was last modified in a spreadsheet. There are several files listed. Here is the thread I found ...

Hi. I got a MultiPage with several pages, and a userform to input data on the next line on spesific sheets, but i got a issue. I've had 4 pages for a long time, no issues what so ever, but then i added more pages, and copied the same code as i used for the 4 others, and just modified the names...

Hi I expect the answer is No as I can't find it with Google, but is there a non-VBA way to update a cell with the date a file was last modified? I know there's a myriad of VBA ways but a User wants a non-VBA version, something equivalent to =INFO() or =GET() Cheers

I found this code in a prior thread that is working but hoping someone can help modify for 2 issues. 1. If I highlight a row or range that contains row R, it places the =NOW() result in every column 4 to the right of each active cell. Is there a way to make sure it only does it related to the...

There's a CSV file at the path: C:\Users\Me\Documents\data_files\quotes.csv I have a different file (mainfile.xlsm) open in which I want code that will fetch the date the quotes.csv file in the directory above was last modified, and paste it into cell A1. Anyone help? Thank you!

Hi, I have been able to pull up file names under a folder, but having a hard time trying to to pull up last modified dates for the corresponding files as well. Looking for Non VBA ways to do so first so that I can understand it better. As I am not well versed with VBA. Help would be great!

Hi all Appreciate any advice please. I have a large dataset - a table of about 100,000 records with about 30 data fields. I have powerpivots set up on that data. However, the I extract data from the same source every month. Not only do I have 10000 new entries each month, but quite a large...

Hello. I checked out this forum post: Function for last modified date of cell. I was able to set up a test Excel 2013 spreadsheet ("test.xlsm") with values in column B, cells 2 through 6 and in cells I wanted to have last modified dates in column E, rows 2 through 6. From the spreadsheet I...

Hello, I have an excel sheet and I am trying to find the most secure way to protect it from being modified. I know that sometimes even if you lock the cells if someone save it as then the excel can be modified. Can somebody advise?

Aloha you guys, I'm working on a workbook in which I'm using 6 different sheets. I modified the print settings in each of the sheets so that I can press the button corresponding to the sheet and automatically PRINT without prompting print settings. On the last worksheet, however, I would like...