Self Destruct Workbook After Not Logging In Within 30 Days

May 20, 2007

I need a macro that records users accessing a workbook over a network and if I have not logged in after a 30 day period it will replace all calculations with data and if possible wipe all macros.
I have tried to nut this out but time is against me.

I have had my work taken to other sites within our business and passed of as their work, and it bugs me.

View 9 Replies


Logging In A Website With Macros

Dec 12, 2008

I'm trying to automate some webscraping on a website that requires a login, and was wondering how I would do so using Macros with a specific username password somewhere in the spreadsheet, lets say B2, and C2 respectively. The website I'm trying to login is this; I think I have most of the scraping figured out; its just the log-in for now.

View 2 Replies View Related

Recording/Logging Cell Value When Value Changes

May 8, 2009

Is there a way to copy/transfer a cell value to an adjacent cell when the value of the cell changes. So if A1= 5, and it changes to 3, have B2 = 5 when this happens.

View 14 Replies View Related

Automated User Logging

Oct 1, 2009

I keep a spreadsheet with the 50 or so wireless phones in our "lab". When someone checks them out, the rules are that they change the cell under Available to "NO" and add their user ID. When they return the device, they change the Available cell back to "YES". What I want is a log of who checked out the device, and when... which would be kept in "sheet 2".

I attached a small spreadsheet with the same columns and information you would see in the regular spread sheet. Sorry, I would rather have put it here, but I couldn't figure out how to do that.

The spreadsheet has code which updates the "Counter" when someone checks out a device. Many thanks to the "Rocket Scientist" who helped me with that.

View 11 Replies View Related

Logging Changes To A Worksheet Range

Oct 29, 2009

i have a spreadsheet with the following range in a worksheet called "Data".
The range is A3:CH9 where column A contains the data label and row 3contains a label for each month. So the data itself is in B4:CH9

Is it possible to set a macro that logs any changes to the data in the range
B4:CH9 and log that change in another worksheet (eg: "Log"). It would say who made the change (based on the USERNAME), what cell was changed, when it was changed and what the value was changed from and to.

View 10 Replies View Related

Logging Live Data

Nov 30, 2008

I'd like to log live update data continuously,i.e. as the data in the cell changes. The problem I'm facing is that the data comes in at uneven intervals-- ranging from 30 to 50 ticks per second. So I can't really use a timer function. I need to use some function which saves the data as the cell value changes. So, for example, if cell A1 gets updated continuously, cell B1 could save the first value of A1 and then cell B2 could save the second value of cell A1-- and so forth.

View 9 Replies View Related

How To Restrict Users From Logging More Than Once In Excel

Nov 7, 2011

I am doing an excel survey using forms. I want to restrict users from completing the survey more than once. i am using below code to input user login details in to a spreadsheet but i am not sure how to restrict them. I want a msgbox or some sort and then it closes the excel active workbook.

code to get username:
Sub GetName
Dim r As Range
Set r = Sheets("UserNames").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)

r.Value = Environ("username")
r.Offset(0, 1).Value = Date
r.Offset(0, 2).Value = Time

End Sub

After looking through various forums i found code to highlight duplicates but not sure how this can be modified to suit my need.

Code to find duplicates:
Sub Dups()

Application.ScreenUpdating = False
Rng = Selection.Rows.Count

[Code] .......

View 5 Replies View Related

Sumproduct - Number Of Divers Logging Dives

Jan 24, 2014

Building a Dive Record spreadsheet and Annual Statisics requirements to compute automatically. I have gotten this far:


Unfortuantely, I do not have a list of divers names for referencing. I am using these for testing purposes:

Column B Diver's Names: B. Dodson, L. Lloyd, D. Burch, C. Haley, J. Wilson, B.Dodson, B. Dodson Columns M through BO (types of dives): will have "X's" in them if a specific type of dive was made, Scientific, Working, Training, Non-duty... Shore, Boat, Ice, Cave, etc..

I need to know how many Divers made the type of dives. For example, if I make three dives in Saltwater, L. Lloyd makes one, and D. Burch make one, the answer needs to show 3 which is correct. If Dodson makes one, Haley makes one, and Wilson makes one, the number is 2 (actually 2.33). It works in some cases and not in others.

View 7 Replies View Related

Code Reuse - Logging Actions When A Cell Changes

Apr 28, 2009

I am trying to use following codes for a add-in utility so that user can enable or disable logging activity for a given workbook.

My problem is to how to add the following code to a new workbook so that "Loginfo" function could be activated. I have tried some application... based commands but it do not seem to be working.

View 6 Replies View Related

Code Reuse - Logging Actions When A Cell Changes -2

May 2, 2009

I have made an class and created a file to log when user change value or insert formula in a sheet get recorded in a file C:Logme.csv. The problem is it is recording the value and formula at random i.e in some instances it records the value and in some instances it is not recording the value and formula in logme.csv . I am unable to figure out why this is happening?

View 3 Replies View Related

Find Out How Many Ticks Were On Green Days, Amber Days And Red Days

Dec 19, 2008

I have a series of data that acts upon a traffic light system, i.e. Green, Amber and Red. These variables are posted along row 1 for example and there are 10 columns. Per column I have a tick and cross to answer a question. How can I find out how many ticks were on green days, amber days and red days? I have attached an example.

View 4 Replies View Related

Stop Workbook Functioning After X Days

Mar 18, 2009

I need to know how to make a workbook (and any/all copies made there from) cease to function (become irreversibly read-only) after a specific period of time following the first time it is loaded by a user (this would be preferable), or after a specified date (this could also work).

View 9 Replies View Related

Constraining Number Of Days A Workbook Can Be Accessed

Jan 24, 2013

Is there any way to have a input box pop up after a Prescribed number of days or on a particular date and from that point on prompting the user to enter a password that I created (hard coded into the code)In order for the workbook to open If the password is not entered or is not correct then the workbook will close.After the pasword is enterd then the workbook would open from that point on(the input box would be disabled) Also this macro would have to be password protected in order to prevent the user from accessing the code.

View 8 Replies View Related

Count How Many Days Coming Due Within 90 Days Of Each Date Based On Today Function

May 27, 2012

There are dates in column C and I need to count how many days are coming due within 90 days of each date based on the today() function but do not exceed the 90 days.

Countif Today()+90

View 5 Replies View Related

Excel 2007 :: Count Number Of Days Between Two Date Where Off Days Are Friday / Saturday And Holiday

Mar 14, 2014

I am making process TAT(Turn Around Time) which required following information. In Excel 2007.

1-Count number of days between two dates where working days are (Sun to Thursday). So required to exclude (Friday,Sat + Holidays)

A1-Start Date Mar/01/2014
B1-End Date Mar/31/2014
C1-No Of Days 22
D1-Days between two dates 21
E1 To E10-Holidays

2-Count number of days between two dates where working days are (Sat to Thursday). So required to exclude (Friday + Holidays)

A1-Start Date Mar/01/2014
B1-End Date Mar/31/2014
C1-No Of Days 27
D1-Days between two dates 26
E1 To E10-Holidays

Note : Any weekend (off days) dates listed in holidays should not effect the query.

View 9 Replies View Related

Counting The Days Worked And Days Remaining On A Schedule Automatically

Sep 1, 2007

I'm basically looking for a forumla that will count each employees total scheduled work days for the month inserted and then depening upon the day it is will show how many days the employee has left to work for the month.

View 9 Replies View Related

Converting Days To Years,months,days

Jan 23, 2009

How can I convert the number of days for example 366 days to years, months, days 366=1year, 0 months, 1 day

View 3 Replies View Related

Rolling 7 Days, Extract The 3 Previous Days

Oct 19, 2009

I have a spreadsheet in 2007. Days across the top for an entire year. So 365 columns. I need a macro to extract the 3 previous days , today's column, and the 3 next days and load to a different worksheet.

HTML worksheet A:
1/1/09, 1/2/09..... 10/17/09, 10/18/09, 10/19/09, 10/20/09, 10/21/09 .... 12/31/09
10 11 ... 14 15 17 12 22 ... 28
a g ... g c d d a ... a

the macro would create a worksheet B(if run on 10/19/09):
10/17/09, 10/18/09, 10/19/09, 10/20/09, 10/21/09
14 15 17 12 22
g c d d a

View 6 Replies View Related

Change Days Added To Working Days

Jul 31, 2014

I've got the below so far, but where it says V2>=(Q2+5) , I would like it to add 5 working days instead, is this possible?


=IF(AND(T2="Awaiting",V2>=(Q2+5)),"Overdue","Raised within 5 Days")

It would also be great if there is a way to say that if T2="Not Required, then put "Not Required" in W2 (where the IF statement is)

View 4 Replies View Related

Count Days HH:MM Using Network Days

Sep 28, 2011

I need a formula to count how many days hours & mins between 2 dates but included in the formula need to ensure it only counts business days.

Column A 02/09/2011 13:00

Column AO 02/09/2011 13:02

I need in Column AP to show 0 00:02

The formula I have tried using is - =IF(AO3="","",AO3-A3) which doesnt work as instead of showing 0 00:02 it shows 1 00:02. I dont want it to count as 1 day just 2 mins.

Once that has been worked out I need to include WORKDAYS formula to only count working days. I have created the list on 'Controls' Tab Column A10:A47.

merge these together to create the one formula?

View 6 Replies View Related

Calculate End Date Using Start Date And Number Of Days Excluding Specific Days

Nov 22, 2013

I want to calculate the end date of my German courses. This is how it works:

A course consists of 60 LU*. The course can occur i. e. three times a week: Monday, Wednesday and Friday. In each day the course lasts 2 LU, which means 6 LU each week. There is no course on Tuesday, Thursday, Saturday, Sunday and on holidays. Therefore this type of course that begins on 18-Nov-2013 will end on 03-Feb-2014.

Another course which occurs Tuesday, Thursday and Saturday, and respectively has 2 LU on Tuesday, 2 LU on Thursday and 3 LU on Saturday and starts on 03-Dec-2013 will end on 06-Feb-2014.

Therefore I want to create a worksheet where I set the start date, choose the days and respectively the LU amount on those days. The end date shall be calculated according to these criteria.

The workday function on excel cannot do this and I do not have any programming skills to work with VBA.

*LU = lesson units; 1 LU is 45 minutes


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

View 7 Replies View Related

Days Between Two Dates Separated Into Days Per Month For Multiple Dates - Excel

Feb 13, 2013

I wanted to determine the number of days between two dates. Specifically, if the initial date is in one month, and the second is in a different month and an output would result a number of days in each month until the final date. BUT I have a large amount of data to do this for in a list view, way to put a formula in excel and just drag down the entire list to get the required information. see below for an example.

The result I'm looking for is the separate the months and only show the relevant months between the two dates in one cell or the adjacent. Something similar to the table outlined below.

Input Data
Start Date


View 3 Replies View Related

Formula For Last 7 Days, 30 Days

Dec 8, 2008

I have two rows of data, Date and data.

I want to continously figure avg for last 7 days, 30 days.

View 10 Replies View Related

DAYS 360

Aug 26, 2007

the spreadsheet i've set up have two days in it, and i need to work out the number of days between the dates.

(Column H)
Date Work was requested
(Column S)
Date Work was completed

Now i thought i could use

This does return the number of days between the dates, but if theres no completed date yet (alot of jobs take weeks somethings months to complete) it returns a value of -38541 for example.

View 9 Replies View Related

How To Get To Add Working Days

Jun 6, 2014

In A column the date something is received will be entered.

In B column there is a drop down list that has "insured" "Fee" "Aged Debt" "Other".

In C column I am trying to get another date to populate dependant on what is picked from column B, so if Insured is picked then 1 working day needs to be added to the date in column A and populate in column C. If any of the other 3 options are selected 5 working days needs to be added to the date in column A and populated in column C.

I have been using this formula: =IF(B2="","",IF(B2="Insured",A2+1,A2+5)) however this is not working days and I am stuck how to get to add working days

View 4 Replies View Related

Birthday Is X Days Away?

Jan 7, 2009

I have a column with people(A) and their date of birth(C). I'm looking to find out the number of days when their next birthday is. I searched through here and couldn't find anything. Is there a formula I can use that would calculate this, year after year after year??

View 4 Replies View Related

Looks Up By SS#and A Date That Is Within Two Days Of Each Other

Jan 24, 2009

I am trying to find a formula that looks up by SS#and a date that is within two days of each other. Example file is attached but I have put the two table below just in case. The file explains it better.

Table A


Table B

7/2/2009John555Formula Here
7/3/2008John555Formula Here
8/7/2009Bob777Formula Here
9/7/2009Bob777Formula Here

View 8 Replies View Related

Time Between Days

May 11, 2006

I'm setting up a shift roster and need to determine whether a given time is
between the start time and end time of a shift where the shift runs across 2
calendar days

eg start 23:00 finish 06:00

View 9 Replies View Related

Lookup Name If Between Two Days?

Aug 7, 2012

I just started coding excel literally this week and I'm having trouble getting something to work. >.< I'm trying to look up a Name, if the date falls between Check-In Date and Check-Out Date.

Below is my basic layout:

Sheet 1: This is where raw data is inputted

Room, Name, Check-In Date, Check-Out Date
10......Clark.....Aug 1.............Aug 10
10......James...Aug 15............Aug 16

Sheet 2: This is where raw data is organized daily

Date: August 1/2012
Room, Name

What I'm trying to do is output the "Name" next to the "Room" if that person is staying at that part particular day.

I tried accomplishing this using nested VLOOKUP and if statements, however, it only works for the first Room it finds. If room 10 is used on a different day, I get a #value! error.

=VLOOKUP(10,'Room Reservation'!A4:H1002,IF(AND(VLOOKUP(10,'Room Reservation'!A4:H1002,7,FALSE)A2),2,""),FALSE)

Basically, it's searching for "10" if "Check-In"

View 9 Replies View Related

Calculate Days Between X

Nov 12, 2013

I have a data set that looks like the following.

Description S M T W T F S
Item 1 X X
Item 2 X X

I have a few thousand rows of this. The X's could be placed in any column. I need to go through this data and determine the maximum days between X's for each row. I can't think of how to do something like this with either an equation or with VBA.

I can't get it to line up in the table above. But basically, there could be an X in Sunday and on Wednesday in one row. The next, could be every day of the week, the next could be any other combination. There could be 7 X's, 1 X, 3 X's, whatever.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved