Macro To Delete Itself Upon Completion

Feb 20, 2009

I have 2 command buttons on a sheet, one of which I would like to upgrade to delete the other, as well as itself, upon completing the rest of its functions. That's right, normal VBA isn't fun enough anymore, I want kamikaze suicidal code that wipes itself off the face of the earth.

My colleagues are... less than comfortable with VBA. I use it to produce some of the forms which I send to them, and if I could delete the code automatically after running, I'd save myself some time and/or save them some confusion.

View 2 Replies


Macro Stops Before Completion?

Apr 13, 2014

i ran some tests and it was working good only doing folders with ~100 files. i tried running the macro on all the files (~70,000), but I ran into problems with the computer going into standby while I was away. I tried running a batch of 3000 files and it completed, but only got up to around ~400 out of ~3000 records. Maybe, it stops cause of code related inefficiencies?

Here's the code:

View 1 Replies View Related

Macro Quitting Before Completion

Nov 24, 2008

The macro is designed to grab a closing stock price for a date specified for a list of Symbols in column A and the date in column B. The closing price is then displayed in column D.

The problems (there are two that I found) I am running into is that when the Macro encounters a symbol in Column A and is not recognized, an error message pops up and the macro stops altogether. I want the macro to continue to run down the list but I can't figure out where in the macro it is stopping and, more importantly, how to make it continue. I have attached a copy of file if needed (if opened, you can see it stops working after row 11).

View 5 Replies View Related

Macro That Closes Excel Upon Completion?

Jan 14, 2008

This is my first time posting to the site so I will start with a simple question. I have an email macro that will send the workbook to a specific recipient. What I want it to be able to do is close excel after the macro is ran and the email is sent. If anyone would be kind enought to supply me with a code that will work .....

View 9 Replies View Related

Subscript Out Of Range After Completion

Dec 31, 2009

I'm getting a "Subscript out of Range" error on a routine that was running fine a few days ago. It's part of a larger macro, so I've pasted the full code for that macro below. The problem is in the routine labled "Replace Regional Labels". What that's supposed to do (and DOES do) is to replace labels such as 110 or 11000-CSD with 11000. The error message comes up AFTER the routine has completed it's work. The offending line is:

View 2 Replies View Related

Time To Completion Countdown Timer

May 8, 2014

I need to list multiple items that end in, example:at time entered there is 45:14:50 = Hr:Mn:Sec to completion, and would like the date and time of completion or just a countdown to 0 would work. I will have 60 to 70 items running at the same time with different start times and lengths. Picture queueing up items at different times to complete in different length of time and I need to be ready when each item is done. I know this is an Excel forum but I also use Apple Numbers so if either one works better I'm fine with that.

In the attached file, column R is the start time that I enter that needs to be calculated to column S. When I enter an item that takes 54hrs 23min 45seconds to complete, what date and time will it be ready.

View 9 Replies View Related

Calculate Workdays - Completion Date

Dec 26, 2012

I have the following function:


The intent is to calculate the completion date against the assigned date as follows:

G13 - Typically the assign date but sometimes can be blank because someone forgets or doesn't bother to insert

For this example, let's say: 12/17/12

H13 - Completion date

For this example, let's say: 12/20/12

I'm expecting a result of '3' for 3 days

The first half of the function is intended to calculate 1 day if G13 is blank or not defined. However, when I have dates in both cells, I'm getting a "false" answer instead of a numerical value that I'm expecting.

In our workplace, we do work weekends & sometimes 7 days a week.

View 11 Replies View Related

How To Forecast Project Completion Date

Sep 28, 2008

I have project start date in cell C2((MMDDYYYY format).In cell D2 I have put the total days needed to complete the project.In cell E2:E6 I have got the scheduled Holidays.

I need to calculate the project completion date in F2.We work from Monday to Saturday,Sunday being off day.

The detail is as follows:-

View 9 Replies View Related

Show Message If Completion Date Not Met

Aug 28, 2007

I have a spreadsheet where I have input all of my technicians service calls and installations.

In Column C Row 5 and up to the max I assume because I'm not sure how many rows I would use in a year, I have an estimated completion date.

In Column D and the same Rows as above I will input the Actual Completion date.

What I want is if the current date is past the estimated completion date (Column C) and there is no date entered in the Actual Completion date (Column D) I would like a MsgBox to pop up saying "Please enter a new completion date on row _"

"_" would be which ever row the estimated completion date has expired without an actual completion date being entered.

View 9 Replies View Related

Changing Cell Colour On Basis Of Completion?

Apr 7, 2013

I have two sheets, one sheet showing the total calories burned, in the sheet two, i have the target set,

How can i change the color of cell in the target on the basis of the achivement for example the target is say 10,000 cells and after I achieve 1500, it will change the color, after 3000 it will change another color and so on and so forth.

View 1 Replies View Related

Vacation Accrual Based On Completion Of 90 Day Probation?

Nov 29, 2013

I need to create a tracking sheet for my vacation. The vacation starts to accrue here after a 90 day probation following the hire date. Each individual is allowed 40 hrs/year. I also need to see the hours accrued, the hours used & the balance. Everyone's balance renews on their anniversary. I will fill in the blanks for the names in one column & the hire date in the next column and I would like formulas for the following columns.

View 12 Replies View Related

Displaying What CAMPUS A Student Was LOCATED At On The Course Completion Date?

Jul 29, 2014

I have a spreadsheet containing 2 worksheets. First worksheet has my Students Details and the second spreadsheet has their Campus Locations.

What I need to create is a Formula that tells me "What CAMPUS was the student LOCATED at on the Course Completion Date?"


what I'm trying to do is as follows:

John Completes his Course on the 25th July 2013, his Student ID is 450.

I need to go to the CAMPUS LOCATION spreadsheet and first search for Johns student ID (450) in column B. Because John is listed in B2,B3 and B4 excel needs to check date in Column E to see if his completion date was before the Date he started at Campus.

If it is then the Campus he was at will be the value of Column D on that line.

If it is not then it needs to search the next line until it satisfies the condition.

View 5 Replies View Related

Progress Bar To Show Both Percentage Completion And Time Left?

May 28, 2014

How to show progress bar for both percentage completion and time left.

The code below is already created with percentage completion. Just to add time left.

[Code] ........

View 6 Replies View Related

Completion Dates - Weekend - Holidays In Office 2003

Nov 6, 2006

In my helpdesk spreadsheet, Column C has the date a request is received and Column D has the day it is signed off as complete.

This is used to compare how many days it takes before each request is completed.

Column B is usually blank, but, if the day a request is due to be completed is in the future, such as waterblasting set for 5 working days ahead, then the expected completion date is in Column B. As we don't want a report to show it took five days to complete, when 5 days was waiting for the booked job, we only want five days when we are working on it for five days.

So a typical request is received on Monday 1st January (C), completed on 3rd January (D), taking 3 working days to complete.

A less typical is a request received on Monday 1st January (C), booked to be done on the 4th January, (B). If the job is completed on the 4th, then that will be entered into (D). And we want it show as taking 1 day or less to complete.

I'm quite new to excel formulas , but would like to know the format for

IF B = Empty, then display the days (minus holidays and minus weekends) between C & D.

IF B = non-blank, then display the days (minus holidays and minus weekends) between B & D.

I've tried to play with the Workday function but it and the format of the IF function seem just beyond my grasp, depsite it simplicity, so hopefully a bit more insight as i get to grips with formulas would help me out...

View 9 Replies View Related

Calculating Task Completion Time In Working Hours

Oct 15, 2007

The below is for Excel 2003.

I want to set up a spreadsheet that can show my work is completed within a service level agreement, based on working hours of 9-5 Monday-Saturday.

I want to be able, for example, to log that a piece of work is reported at 09:00 on a Monday and completed at 10:00 on Monday and for excel to calculate that as 1 hour until completion. Fine so far. But what if that job was closed at 10:00 two days later? Based on an 8 hour working day, that should be 17 hours.

And what if a bit of work comes in at 17:00 on the Saturday. No one works the Sunday. Say the job is completed at 10:00 on the Monday. that should calculate as 1 hour to completion.

The SLA I'm setting is 4 hours.

View 9 Replies View Related

Macro Delete Page (delete A Sheet In A Macro But When I Run The Macro)

Jun 19, 2009

I want to delete a sheet in a macro but when I run the macro, I always get a message warning and I have to answer the msg box to delete the page. Below is the macro command I am using.


View 4 Replies View Related

Finding Data That Has 2 Work Orders And Comparing With Completion Date

May 31, 2007

What I am looking for is a macro/formula that will look at a unit number, then the type of work done, then the completion date and decide if the same type of work was done on the same unit within a 7 day span of time.


Unit is 11111, work is plumbing completion date is 10/4/07
Unit is 11111, work is plumbing completion date is 10/7/07

This means the work has been done 2 times (obviously showing that it did not get fixed the first time)

Is there any way to mark an X in the square with the formula, or any type of identifier what-so-ever

I have attached a spreadsheet and hope it helps

Again I know this is complex so it is OK if no one feels like messing with it but I wanted to check here first.

View 3 Replies View Related

Add This Number To The Start Time, Factor In Break Minutes And Get To The Projected Completion Time

Mar 3, 2009

I am trying to provide a tool for department leaders to monitor productivity for order processing in their departments. The variables I have are: Number of orders(variable), number of pickers (variable), start time(variable). Then, I know each order takes 1 picker 4 minutes to pick on average, and there are 45 minutes worth of breaks during the picking process. So after entering the variables I used =(((C3*4)/60)/D3) to come up with the time needed to process the orders. What I can't get to is how to add this number to the start time, factor in break minutes and get to the projected completion time. I have Excel 2003 at work. Clearly I need to take a class!

View 4 Replies View Related

Macro To Delete Vba Code - Macro Security Warning

Feb 7, 2008

I have recently grabbed the very helpful "Macro to delete VBA code" from this site, and it's working but with one small problem.

My worksheet runs a lot of code, then deletes all macro code and saves itself.

The problem is the next time i open I still get the macro security warning!

I've checked thoroughly and there is definatley no vba left anywhere.

If I open the document, enable macros, and save it, then open it again, I no longer get the warning.

View 9 Replies View Related

Macro To Delete Row

May 15, 2014

I have date from column a to k

I have a formula on column L

I want macro to delete all rows with #N/A

View 5 Replies View Related

Macro If Then Delete Row ()

Dec 20, 2006

Need a macro for the following situation, will be incorporated into my other macro.

For each row in column C,

if value for first 4 letters = "abc " or "def " or "ghi " or "jkl " then delete entire row.

View 9 Replies View Related

Delete Macro

Aug 30, 2007

I'm looking for code that will prompt a user to select column(s) to be deleted.

- With the exception of columns A,B,C.

- Only entire columns can be deleted

- Rows can not be selected for deletion

View 9 Replies View Related

MACRO: Delete Row Contains

Oct 23, 2008

I want to delete a row if it contains componenten.

In here i ask to delete componenten not.

Or should i take "*componenten*" or totaly someting else

For MY_ROWS = Range("c65536").End(xlUp).Row To 1 Step -1
If UCase(Range("c" & MY_ROWS).Value) = "COMPONENTEN" Then
End If

View 9 Replies View Related

Macro Delete Row

Jun 10, 2009

Have a sheet that has a $ value in Col J would like to run a macro that would delete the Row if the value is $0.00 and move the rows up.

View 9 Replies View Related

Delete Row Using A Macro

Oct 27, 2009

On a daily basis I populate data on different worksheets. Meaning on each day I have to delete T-2 data to populate T-1 data.

I would like a macro to select a date to delete rows from each worksheet containing the date in Column A of each worksheet

View 9 Replies View Related

Macro To Delete Itself

Jan 9, 2007

I have a macro that I would like to remove itself from the file as its last action. I don't want a warning message re file containing macros to show on opening the file.

View 9 Replies View Related

Macro Will Not Delete

Apr 23, 2007

I experimented with a simple macro in a worksheet template, but decided not to keep it and deleted the macro. However whenever I add the template to the workbook, it still asks about the macro and whether or not I want to enable it.
When I go back to tools/macro to delete it, there is NO macro that shows up in the dialog box. Why is the workbook still asking me to enable a macro I deleted?

View 4 Replies View Related

Macro To Delete Itself ..

Jun 2, 2007

I am running some macros, but at the end of the macro running i want it to delete itself.

View 4 Replies View Related

Macro To Delete Last Two Rows

Mar 26, 2009

i wrote this macro and want to delete last two rows on active sheet this macro.

Sub deleteLast2Rows()
With ThisWorkbook.Worksheets(1)
Dim rowNum As Integer
Dim m As Range
rowNum = 2
Set m = .Range("A" & rowNum)
rowNum = rowNum - 2

End With
End Sub

View 2 Replies View Related

Macro To Find And Delete?

Dec 3, 2009

I have tried to record this but I cannot get it to work? On the tab “Add & Delete” cell “L17” I have a drop down list that is a list of the policy numbers from the “Data” tab.

What I am trying to do is assign a macro that searches column “J” on the “Data” tab based on the “L17” content on the Tab “Add & Delete” when it finds the data it then clears the contents of that entire row.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved