program

I personally never used this program before in my life. So if anybody can be so kind to summarize what the purpose of this program is for, I'd really appreciate it. Thanks in advance

I created a simple VB program in Excel 2010 that imported 5 fixed width text files and saved the data on 5 separate tabs in a workbook. We recently migrated to Excel 2016 and now the VB program creates a column break whenever there is a column in a text field. Is there some VB code that...

I would like to direct, by way of a MsgBox, the user to select a pull-down cell and obtain a selection and then continue the program operation. How and what VBE coding will accomplish this?

Hello, I have a two excel workbooks, one (Workbook A) which is designed with a macro to pull in info from the other (Workbook B). Recently someone made changes to Workbook A that prevent the linking from occurring, but I do not know what they did. The VBA is identical to the an older version of...

I wrote a program to input a CSV file, slice and dice the data and output a report. The program prompts the user to select a specific CSV file from the files in a fixed folder. The program then saves the file to C:\temp. The program also saves a copy of a schema.ini file from a separate fixed...

I am new to Excel VBA, i am currently making a data entry function and i hope my program has the function that allows program autofill the rest textboxes and check boxes when the users input both "institution name" and "investor name " match the information in the excel worksheet, so the users...

Working with some data and I'm having a tough time working through a formula. Two Individuals: EMP Start End Program Start End Program 123 1/1/16 12/31/16 Program A 9/11/16 12/31/16 Program B 456 1/1/16...

Hello, I am trying to lookup a data from table 1 to table 2 however, the vlookup is not matching locations and picking up the first role it finds: See below: Column A Column B Column C Column D Column E Column F Column G Column H <colgroup><col><col><col><col><col...

I'm looking for the vba to evaluate every cell from BI49 to the last row and if there's an N/A then pop up an error message and exit program. I had a similar request yesterday, but I can't get the syntax right.

I have an foreign language learning program. Simplified a little, on a user form I designate a verb, e.g., “buy” and click “start.” A sub randomly selects a person, e.g., “I”, “you,” or “they,” puts the English in cell (2, 2) and the Italian in cell (3, 2), and then calls a sub named...

Columns A:F have the headers for the summary tool. When I highlight my range, select Subtotal and set the parameters I want in the subtotal control box then, at the bottom of the Subtotal control I un-check the Summary Below Data. When I select Okay to run the program it runs for infinity...

Hi, My Excel has been updated to a newer version recently and some files are now showing up with a blank icon. These files were previously opened through excel and i was able to work with the documents. I have been through the open with which leads me to a window with the following name...

Hi there, I had a project to create a macro which attaches files into outlook and sends an email. What I created works well using Outlook 2013, but my manager who set me the task doesn't use Outlook program, she uses some online version of Outlook.... Is it possible to add/change the VBA code...

Morning All, I need a program that will change the value of a cell within a column based on another cell, for example if the value in column E is less than or equal to 0.75 then change the value in column K to 1. If the program could loop through all the rows in the sheet that would be great...

I have the following code that changes my number formatting to number, when it started as text, but after the program runs, I still have the exclamation point and the green box in the upper left corner of the cells that says numbers formatted as text. Is there a way to get that to stop...

Hello All, I need a Yes or No message box (which reads: "TEST") If I choose Yes, then the program runs. If I choose No, then the program exits, and the program does not run. Thanks for the help excel 2013

Second part is based on the row number of the returned cell value, match other two columns. Maybe an example will make this more clear: From the raw data I want to extract the program name whenever there is no responsible person assigned (cell blank), After I want to be able to match the...

Morning all, I've designed a program to open a workbook on a memory stick however currently it has to be plugged into the E: is there any way for the program to detect which port the memory stick is in? Any help would be appreciated, Thanks in advance

Hi! I have a problem with self-written *.exe program which is working with current directory. When i run it manually, it does fine. but if i try to do it using VBA - the pass to current directory changes (like excel copies it to some directory and run). can someone explain me how excel runs...