I have a macro which has a digital certificate. When the macro runs i want to somehow readin the expiration date of the certificate and make sure its still valid before running the macro.
View 6 RepliesI want to add digital certificate in my XL2000 file. i created self certificate and add in the file but when i save that file give me a following error
" There was a Problem with digital certificate. VBA Could not be signed. The signature will be discarded."
I want to add Digital Certificate or sign in my file.
I have a spreadsheet with macro's in and everytime the user opens it that annoying security box opens and asks to allow/disable macro's. I believe it is due to a digital certificate. How to i obtain one, and if i do get one will it stop thie popup occuring for other users on different computers or just me????
View 2 Replies View RelatedI've digitally signed a macro in Excel, where I'm sending mail from using outlook, but I can't seem to get Outlook to recognise the certificate in outlook, even though both programs have my name as a trusted publisher...... so still getting the "A program is automatically trying to send mail on your behalf" Pop up.
How to get outlook to recognise the certificate on the macro that I'm running from excel?
The main issue being it is sending roughly 50 separate emails, and to wait five seconds and manually have to click 'yes' for each one is not really desirable!
I have an excel program that I want to set an expiration date on it, such as 30 days from the first time it's opened. After 30 days, activeworkbook.close
View 13 Replies View RelatedI have looked through your forums the last few hours. I have found similar code to what I'm looking for... but not quite.
I have a date in B2 (10-May-07)
I have an expiration date in C2 (10-May-08)
I want D3 to show months to expiration first (in this case 7)
Then I want it to highlight in yellow 90 days out
Then I want it to highlight in orange 60 days out
Then I want it to highlight in red 30 days out
I use Excel 2007, however I want the code to work with 2003.
I wonder if there is a possibility of the expiration date is in a cell, and that the file is not self-exclude, either block until just change the date in the cell.
Code:
Private Sub Workbook_Open()'If Date
I am charged with building a predictive model that can find items in a hospital inventory that will expire before they are used. The idea is simple: if I use an item every week, this item has an expiration date of 50 weeks from now, and I have 60 on the shelf, then I will likely expire 10 of the items.
The complexity is that there are multiple expiration dates. So, I want be able to look down a list of 3000 items, find the multiple entries of expiration dates, and isolate them based on criteria (select, for example, the first chronologically expiration date).
I need to extract the credit card expiration date from a cell. For example
1111 1111 1111 1111 1/17 code 1111
I was able to get the /17 using =MID(C77,FIND("/",C77),4)
However, I can't get the "1" before the /.
I have created a qualification tracking spreadsheet to track when qualifications are coming due. Each cell may have a different date based on when that employee initially got that qualification. I want the cell that the initial qualification date is typed in to turn "red" after 180days, "orange" after 120 days and "yellow" after 90 days. I have a formula that does close to what I need, but it changes the cell next to it in color.
That code is as follows: =AND(A1<>"",Today()>=A1+90,B1="")
I have attached the sheet, what I am trying to do. Basically columns B-E and rows 2-35 are the ones that need the formatting.
Streiffs_Weapons_Warfare_Qual Tracker.xls
I created a Self Certificate for one of my macros. I have a previous macro for which I want to assign the Self Certificate.
View 9 Replies View Relatedway to put multiple digital signatures on an excel spread sheet. Like, routing a spread sheet for approval.
View 9 Replies View RelatedI have a workbook that is on a share drive. Me and two other users modify the content of this sheet on a daily basis. We don't want to have to click "enable macros" each time we open the workbook. I digitally signed it. Then I went to Becky's office and had her install my certificate. She did, then we made some changes and it gave her this message, "You have modified a signed project. You do not have the correct key to sign this project the signature will be discarded."
View 5 Replies View RelatedI'm trying to apply the digital signature automatically to excel files(.xls,.xlt)(from Excel VBA editor-->Tools-->digital signature--->Apply signature(i need to apply this settings through code)).
scenarios:
1. I could apply digital signature for .exe,.dll,.cab files through VB6 code(using capicom dll) and also i can achieve this to Word document by using signature object.But this object not supporting in Excel.
2. I tried also like this, Recrod a macro--->Apply digital signature from VBA Editor (tools-->digital Signature) but no code has been generated.Again i tried this in another way like, Record macro-->Tools(from Excel)-->Options-->Security-->Digital Signatures--->Add.but here also i couldn't achieve this.
3. i tried using Application object like executing menus through code(Application. commandbars("Tools").controls("Options").controls("security")) here also i strucked up.
I've verisign digital certificate with pfx file.....
Can someone confirm that the Microsoft Self Certification (digital signature) for VBA in Excel would not solve the problem of the prompt screen. In other words, unless the user has selected your profile as acceptable, the prompt screen will still appear? To not get the prompt screen, I have to get it appoved by Verisign, but they are not free.
View 9 Replies View RelatedI have a user form that when a command button is clicked it enters the data from the from into coloums a,b,c,etc. I have code to do this but I want to add code to add a static date in coloum B based on if coloum A had data entered from the form. I need the date not to change to current date when the file is reopened. I am trying to elimate a date text box in the form. I have a link to the file http://www.box.net/shared/zdtsjv0qos
View 7 Replies View RelatedI have QC checklist with a cell at the bottom for the user's initials. We have 8 users, and I would like to create a way that each user can enter their pin and have their initials come up in the cell. Ideally, there would be no way to the other users to know each other's pins or find out in the spreadsheet. Do you think it is do-able using VBA and how they would approach this?
View 1 Replies View RelatedI would like to use Excel as a measurement device. I have an inexpensive digital microscope that will store sequentially numbered pictures at the click of a button. I am then going to import the most recent picture into Excel and place a grid of transparent rectangles over the picture to serve as my ruler. Would it be possible to continuous update the Excel workbook with the output from the digital microscope?
View 7 Replies View RelatedI work in a HR department and I'm trying to create a spreadsheet to track the amount of extra-duty hours each worker has. For every extra hour they work today, they can use this hour next time.
Screen Shot 2014-03-31 at 9.25.22 pm.png
This is my current spreadsheetCredit hours means hours added to their 'account'.Debit means hours taken out.Hours will expire in X days if not utilised.Right now, each worker has their own spreadsheet in the same workbook.I have about 25 workers.Is this the best way to manage this?How can I create a 'bank account' system to track their hours?
hourstracking.xlsx
I have a large document control register and it is updated daily and posted to a cloud for many people to access. It is very time consuming to constantly jump in and out and highlight and unhighlight as many things as there are and keeping track of which items that need to be unhighlighted. The thing I'm trying to figure out is if there is a formula for this...If i change any cell in a row I want the row to highlight itself entirely, but after 24 hours I want the highlight to expire. Is there a formula or function I can use to make this happen?
View 4 Replies View RelatedI have a vba code for an excel spreadsheet that lets me know when a particular persons' certification is about to expire (within 31 days). However what I cannot figure out is how to make this work with more than one expiration date ( additional columns containing other certification dates). I keep getting errors when trying to add additional columns to check ( I do admit that my VBA coding is atrocious at best).
Ultimately what I would like to achieve is a list of names with expiration dates alongside popping up when opening, but maybe I am asking too much?
I need to set up a conditional formatting formula to show when a certificate of approval is within 90 days of expiring and when it actually has expired.
The conditional formatting is in column A and the expiration date is in column I.
I have an excel file connected to a digital reader. Values are inputted to cells. What I can't figure out is the formula to automatically insert the values into the desired cells.
In short. First value goes to A1, 2nd value goes to B1. There's a formula (=A1-B1) in C1. The 3rd value from the reader should go to A2. The 4th value to B2. The 5th value to A3 and so on. I believe that I should be putting a formula into B1,2,3..n. What I can't figure out is that formula.
I am new at excel and have very limited experience. I have a employee training database, with employees (in column A2:A54) and the certification names (in row A1:AS1) that I must generate a monthly report on employees that are expiring within the current month. The cells are already conditionally formatted to change colors for one month prior to expiration date, current month of expiration date, and past the expiration date.
I am manually gathering the data then adding it to another sheet. In the mist of trying to gather data, I am missing and/or overlooking information. I wanted to know if there is a way to automatically generate a report based on the expiration dates that would pull the employees name and which certification is expiring or expired, preferable both. I have tried reading threads and applying advanced filters but due to the number of certifications it is not functional to do it this way.
I have attached a sample of the spreadsheet : ETD.xlsx
I'm sent a file every day where column A contains a month & year but in "general" format.
For example;
Column A, starting with cell A1 with the next date in A2, etc
Jan15
Feb15
Mar15
Apr15
Is there a way through a formula or macro that I can use in order to run through all the dates in this column to make sure that the next cell down is always the month after the cell above it? The dates go all the way through to 2018 in the above format.
I have a sheet(Sample.xlsx) in which weekly data is collected and this is done by using the VBA code(Present in Copy 1 and Copy 2 button in Master US.xlsm) written by me. But in my code, it inserts a new after asking two parameters, i.e. line range(i.e. row no for eg A64) and date. I want it to automatically search row containing last date and inserts row below it and this needs to be implemented in "Insert Automatically" and "Insert Date" button using VBA code in Master US.xlsm sheet.I dont have problem with second paramenter.
Logic i want to use :
Itergation of whole page
{
If (col A<>Date)&& col A=Average(i.e. contains average word)
then
inserts row above that row
And then ask for date to enter using date variable.
then inserts row above that row containing last week data in col A.
}
"Insert Automatically" in Master US.xlsm sheet is the button which takes system date and implements the above logic.
"Insert Date" in Master US.xlsm sheet is the button which ask for only date and implements the above logic.
Sheets attached.
Master US.xlsm
Sample.xlsx
How to check cell from a " DATE" column has todays date or not?
View 9 Replies View RelatedI have a spreadsheet where we track our contractor's Worker's Comp and General Liability insurance certificate expiration dates. I want the expiration date to highlight in red if it is expired and to highlight in orange if it will expire within 30 days or less.
I have attached a testing sheet similar to what I'm working on. The F column has the dates that need to highlight. I have MS Excel 2010.
I manage a number if individuals in the Army and as such, track their annual training requirements. Some requirements are semi-annual, annual, quadrennial, etc...
I have a spreadsheet to track the dates that the requirement was last completed (attached). I would like to use conditional formatting to turn dates that are within 30 days of being due (or blank) RED and dates that are between 31 days and 60 days of being due YELLOW.
I am using Excel MAC 2011.
I am trying to use conditional formatting to calculate when the date in the top column gets within 60 days from expiring to turn yellow, 30 days from expiring to turn orange and when it expires to turn red. The dates that are listed from row 5 down are when the classes were taken. the expiration date will be based on row 3. Some are annual,3 years and 5 years, etc. I am using Excel 2010....
View 10 Replies View Related