Search results for query: *

I have an order worksheet that engineers choose parts from. The Vendor name is called out in cell H5. There are other worksheets with the names of the vendors on the tabs for each sheet. I would like to program a button that would look down through the front master sheet and sort the items that...

I have an order worksheet that engineers choose parts from. The Vendor name is called out in cell H5. There are other worksheets with the names of the vendors on the tabs for each sheet. I would like to program a button that would look down through the front master sheet and sort the items that...

I have a spreadsheet that I need to find rows with values entered by an input box. If the value is found, then delete the row. I want to be able to enter wildcards so that any value containing the text will result in deletion of the row. I used snippets I found on the web to get started, but I...

I have a spreadsheet that lists motors with HP and options like brakes and VFD. I need to look at the horsepower, and the VFD option and select a type of drive to use. The HP is in cell B9, the VFD option (which says "Yes" or "No") is in cell C9, the type of drive used will go in cell H9. The...

I have a column of values in I3 that I need to check the sum until I reach a threshold of 24.5 (full load amps). If the value exceeds 24.5 the cell J3 (branch number) needs to increment by the value of the previous cell in the row above plus 1. The first row will always start at 1. So if rows...

I have some VBA code that takes field values from an excel worksheet and dumps them into a table in Access. I need to check if the record in the table exists first, and if it does than only update it. If it does not then add a new record. Here is the code I have so far. Sub UpdateMasterDb()...

I need some help with a spreadsheet. I am trying to set up a sheet that will calculate union overtime grrrrrrrr! Anyway, this is how it was explained to me. "For example, if they worked a 12 hour day…it would be 8 hours @ regular time, 2 hours @ overtime and 2 hours @ double time. That's Monday...

I am saving data from a master worksheet in excel into a database with only one table on the before close event of the worksheet. One of the fields that I am saving to in the database is supposed to be a hyperlink that opens the saved worksheet if you click on it. But it is not working. The...

Hi, I have some code in a spreadsheet on the before close event that asks the user with a vbyes/no msgbox if they would like to update the master database. If they select yes then I run a routine to take data from the worksheet and append a new record into my database. If they select no then I...

I have a master spreadsheet that estimators use on a daily basis. I would like to be able to update a master database of all the quote activity. On my spreadsheet now, I have a button that writes to another spreadsheet and updates to the last used row, the date, estimator name, project number...

I have an outlook macro written that creates tasks from emails, that is used by several of my coworkers in the office. Recently one of the geniuses in IT "ghosted" a coworkers machine and reinstalled Microsoft Office. He lost all the code for the macros that was there. I had to cut and paste...

I have been trying to write some code to store an excel file onto a network drive with limited success. Could someone look this over and tell me where I am going wrong? Thanks Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim sProjNum As String Dim ThisFile As...

Hi all, I am trying to save a file to a directory that I don't always know what the name will be. I am trying to build a string and use wildcards to fill in the remainder of the directory name and I'm not getting the result I need. Could someone take a look and see if they could help? Thanks for...

I would like to be able to define the "target" as an individual cell, and not "any" cell on the worksheet. I want some code to run only when a certain cell changes. Can someone help me define this?

I want to have the save as dialog open up with the filename populated with a filename built from the contents of several cells, and a default path. Should I put this in the beforesave event? or the beforeclose event? This is the code that I was trying to use, and not having the best results...

I need a procedure to loop through the emails in my inbox and check for a line of text in the subject. Could anyone point me to a code snippet that shows how to do this with VBA in outlook?

I have a coworker that cannot get the code to work on his machine that works on mine. The problem seems to be with the GetFirst method not pointing to the latest email in his in box in outlook. Here is the code that runs: ' for automatic syntax highlighting see faq102-6487 Option Explicit...

I don't know if you are all aware of this or not, so just thought that I would share it. Just in case. If you do not have the support for the scroll wheel on your mouse for the VB/VBA IDE, check out this article which explains how to add it in...

I have some code that creates a new task in outlook when an email comes in that meets a certain criteria. That part of the code works fine. However If I receive an invitation for a meeting notification (is this now an calendar item?) then I get a type mismatch error in my code. Any ideas...

How can I find a line of text in an incoming email and delete it from the body of the email?