process

Hi I currently send invoices via email using excel. I use gmail and the process works extremely well. My question is - can I use a similar logic to send text messages? For the email process I reference CDO - is there something similar but for texting from a range of telephone numbers? Many...

Hi guys I need to load an Excel file with a button, then process and modify it and change it to txt or pdf after the changes. Can I do this with VBA?any body can help me plz? :)

I have tried to record a Macro for a repetitive task I do many times per month. I export data, run a pivot table to summarize the data so I can then import it into another file. Here is the video of the process I go through and can not figure out how to make it work. Can anyone help? Is...

Hi All, Not sure where I am going wrong. I have a userform and I want items within the listbox to be removed depending on the value of a textbox in the form. I currently have Private Sub UserForm_Initialize() NameTextBox.Value = Application.UserName With DepartmentListBox .AddItem...

Hello everybody. I have built a hybrid process that engages both Microsoft Excel 2007 and Microsoft Outlook 2007. The process is triggered by an incoming e-mail sent by a specific sender at any hour at minute 15. With VBA instructions set in Outlook, the mail .xls attachment is used to update...

Hi everyone, I have a problem for a userform which uses comboboxes. So basically I have column A with "area" items and column B with "process" items. I don't know how many different items I have in theses columns. But everytime you have an area, you have a process written next to it. I want a...

This code is used 28 times in my project. While it works, lRow appears to slow the process due to my poor development – many of the sheets have had data in cells well below the current used range. Some of the sheets run thru Next rCur over 5000 rows during processing. I believe the process...

Hi is this something I need to learn or these are old excel. I am using excel 2013. In the article below, the author said it is an old feature: "In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts...

Hello! Thank you guys/gals for taking the time to view this post. I am looking at creating a custom generator based on 3 criteria I give it. The first Criteria will lookup in Table_1, Find the corresponding data which will give it the next table link. From there it will use the 2nd piece of...

Hi I'm looking to achieve the following ! I don't know whether to use vlookup, offset, indirect or a combination of 2 have looked and looked and looked !! and can't find a solution similar to what I'm trying to achieve I did see one post similar but it didn't solve it for me :( ok here's what...

Hello all, I'm trying to do a count of records that are "In Process" in column J, but only count once for each PR reference in column Q. For example, there may be 4 "In Process" records, but three have PR1 and one has PR2, so I'd want to count 2 i.e. not count the duplicates. Cheers, Jed

Morning, I have a range of cells that show the inputs and outputs by steps. What I want the formula to do is grab the first input given and then grab the last output from the range. The problem I have is that the process of the output may vary depending on which process it went through...

I have an excel sheet and one column has a series of numbers that make up a barcode for a particular product. My problem is that each of these barcode numbers has forward slashes within them (eg: 123/45/678/910). In order for me to process the numbers I need to remove these characters as my...

Hi All, I'm not sure how to tackle this problem and thought you might have a really simple way of doing this, I'm guessing its a common problem. There is a master excel sheet (Process card log), and 1000's of process cards each one an individual excel document. Currently the user spends a...

Hi, I was wondering if someone can help me please. I have a long list of equipment that requires calibrations on different cycles. Some weekly, monthly, semi-annual, and annual. I request some sort of way to automate the process as far as showing what is due. I would like to attach file...

My spreadsheet captures information about military basic training - the trainee's name, the squadron number, the flight number, start/end dates, etc. A flight can have more than one TI (Training Instructor), so in any given record, there can be TI1, TI2, and TI3, which are listed by last names...

Sorry I am not sure where to begin even asking for help, let alone explaining what I am trying to do. The Process I have a form made on excel that requires both text and numbers. The form has two variations. Form A starts a new Request and can yield multiple tracking#s per request. (seperate...

Hi, Memory has gone blank. Looking for the name of when you alter names in drop down list etc & something you click will circle the now incorrect items. Before it would be say Black Dog but now its White Dog,using this process would circle all the Black Dogs in the sheet. Thanks

Does anybody know a way of programmatically detecting the antivirus status in Outlook? The equivalent of manually, in Outlook, navigating to File > Options > Trust Center > Trust Center Settings > Programmatic Access and checking the Antivirus Status at the bottom (It should read "Valid" but...

I have users that need to disseminate data from files that are downloaded from SharePoint. My program does the job but the popup, "Uploading to SharePoint" slows down the process. When they are running wireless it almost complete stops the process. We do now want anything on SharePoint to be...