program

Hi All, I am sorry for repeating this question, as I had posted it in another thread. My question is: I have a Listbox, in which the PDf files of a folder is listed. Below is a program to merge PDFs. I want this program to take the contents of this Listbox and combine them into one. Request...

I use an 'Uploader' to take data from excel to interface and fill in fields in a program I use. My workbook contains several of these 'Uploaders' and the program requires the sheet to be named "Uploader". Obviously my workbook can't contain more than 1 sheet named "Uploader" so the vba below...

I have a spreadsheet containing 4000+ lines of data created in Excel 2003 and am using the same Excel program to maintain the data on a windows 10 HP computer. In the spreadsheet there is a column containing Time eg (1024 0916 1533) and want to change this format to 10:24 09:16 15:33. I have...

I'm having issue with a macro that I never used to have issues with. The code goes through the Header/Footer of each worksheet within the workbook and updates it with three lines in the Left Header: Company Name Program Effective Date It also adds in a logo that we use in the right footer and...

Hi, I have spent two days googling and searching old threads to no avail so I'm posting here in hopes that someone can help. I'm trying to automate 2 vlookups using VBA. I will receive reports daily where will we have to do vlookups to pull the advisor name and program name. So I have 2...

Hi Experts, I have searched the site and others but I can't seem to find a way to do what I am trying to do. - I have a Macro that runs another Program and needs to run one by one down the Excel file. - The Macro runs the file fine, but the Program writes back to Excel values that I need for...

Hi guys, I look forward to your help. I need to override cell data. for example, I currently export information from a program to excel. The program info states -22 but i want a macro to change it to Fro. I also need this for other numbers. I will get something like this: -22 -22 18 15 1 18...

I have an interactive dashboard that updates every time I select a new program from a drop down list. I would like to pdf the 170ish reports for each program so that I can email them out. Can I write code that cycles thru the drop down list and pdfs each report and names it by the unique...

I have a database export of item prices i want to import into another estimating program. This program requires the item prices to be in a named cell. I have a unique name in column A and want to create a named cell in column D with that name. Problem is i have 3000 rows and dont want to go...

Hi guys, I had an old program which look in folders and converting word from say 93 to 2010, and then deleted the old files. When I open Word it was in the Add in. When it was finished it printed a page of all the files it had converted Then they had a computer upgrade and all my old programs...

Hello everyone My name is A.MaurizioI am writing to you as I would have a problem that apparently seems easy, but in reality it is not.The problem is This: On an Excel Sheet In Column (B2: B20) I need to enter the hour in this way "hh: mm" but the problem is that not everyone working in my...

I have a table of data that holds admission and discharge dates to multiple residences for multiple individuals. Looks like this: Unique ID Person ID Program ID Admit Date Discharge date 1 001 9999 1/1/2017 6/1/2017 2 001...

I had a good working VBA program to copy in order and sum things up. I wanted to make my program even better after the client worked with it a bit so I changed some small stuff and tryed to run the macro. It came back with an error on the next line For Each cell In newven.Range ("G:G") If...

My office needs to get a list of what everyone is running on their computers. "appwiz.cpl" I don't really want to look at screen shots and count each program. Looking for a starting point to pull this information using VB. Thanks for the help

Hello!! Here's a raw data sample: <tbody> Date Program Phase 1/1/18 Circle PRM 1/2/18 Circle P2 1/3/18 Circle P3 1/1/18 Square PRM 1/2/18 Square P1MT 1/3/18 Square P2 1/1/18 Triangle P3 </tbody> I'd like Excel to find the last entry for a given Program (Column B) then...

Hello! :smile: How would I edit this code to reference a dynamic range instead of a specific table? I tried modifying what Record Macro gave me, but did not have any success. Any assistance would be greatly appreciated! Sheets.Add ActiveSheet.Name = "In Program Pivot" Dim tri As...

Hi all, Scenario: a vb.net Program is currently reading some informations from a workbook open in the Application. This may take some seconds. Is it now possible to detect in vba that this currently happens. Thanks Peter

I'm not even sure how to ask this. I am creating a calculator for a loyalty points program. According to the program rules, a company gets a certain amount of points for every year it participates in the program, but loses two points each time it does not. I used the formula above within...

Hello everyone! Tab 1 called "Component Matrix" I have a list of all my components vertically in Column C --> C5:C11 I have a list of all my programs in column F4:J4 See below for what I mean - This table represents a usage matrix. Program 2 has 1 of each of the following components - 1...

Hi, I have a macro that connects to a DB2 database and returns a recordset that I complete subsequent actions with. I have found that longer queries are causing excel to stall - giving me the 'this program is not responding' and forcing me to restart excel. I have played around with the command...