code & vba

Hello, Newbie in VBA here. The scenario is that I have files in .csv format, I run them though a Query and get the expected results. So far so good. I then want to copy the sheets from the current workbook to a new workbook with the same name but the .xlsx extension. I am able to extract the...

can someone make this code efficient This code is meant to compare the revision between two workbooks Sub Compare_Revision_MCC7021() 'makes sure the button is only pushed when it is meant to be. simple check on the tab either side to make sure its the lastest Rev, and not the first'...

I have a master file and a Data Folder that contains workbooks with the same format. I also have a VBA code inside the master file that is able to copy the first sheet of all the selected workbook Sub Merge_Files_First_Sheet_Only() 'Merges all files in a folder to a main file...

Hello everyone, I want to create a master file to consolidate 1 sheet from 10 different files. For example, the name of the sheet I want : FREE, the names of the different files : Europe / America / Africa. So I copy the sheet Free from Europe / America / Africa and paste them into one master...

Hi, so I have a code that I got from my friend (Thank you for it) but it seems that the code needs a tweak as the data that I required to through the datasheets was also copied horizontally and copied the header of the table. The code itself mentions that if the data on the grey-colored cell is...

Hi, I totally new at VBA Macro and I just got the task from my work to do some. There are 2 commands that I need to solve: 1. I need to merge / copy as value only the first sheet of every workbook 2. The next thing is that I need to sum for specific cells of the worksheet, whenever I need to...

Hi guys, I need a VBA code that will resave my workbook on my desktop (regardless of user) and switch to xlsx format (macros disabled), and rename the workbook with text and a date pulled from a cell value (BC2). Below is the code I have so far but it does not seem to work (error shown in image...

Hi all, I'm writing a macro that takes a master file, takes a list of sales people, and for each sales person (RSL) creates individual copies of the master file and edits them so that they only see their own data. I've gotten everything to work but the only thing I haven't figured out is how to...

Dear Sirs, Can any one help me with writing a VBA the code, I need to rename all files & Documents inside the sub folders a with serial Text - numbers, Example : Inside the Admin Letter folder there is three documents (Scan 15, Scan 16, ID) I need the code to rename all these documents as this...

Hi guys, i need some help with word VBA. I have text in a bullet point form on my word doc and i would like to have certain things be done, when i run a macro. I am fairly new to VBA, therefore struggling with the coding aspect. Here is the text in m word doc: Tsla is up by 23% as compared...

Hi Everyone Im looking to copy data from multiple pdf files on loop to an excel sheet (Sheet 1). I want to copy all the information on the pdf and paste it into cell A1 and then cycle through the rest of the pdfs in the folder replacing the data from the previous cycle. Any help would be...

Hello, Im looking to extract data from copied data...

The "error": The code: Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double Application.ScreenUpdating = False Sheets("Calculation_Sheet").Visible = True ActiveWorkbook.Sheets("calculation_sheet").Activate Note: P666, P709, P710 and P713 are global variables...

Private Sub UserForm_Initialize() Call CallTime_Msg lb_hello.Caption = msg lb_tec.Caption = Tec End Sub Sub CallTime_Msg() Dim mHour As Integer Dim msg As String mHour = hour(Now) If mHour < 12 Then msg = "Good Morning" ElseIf mHour < 18 Then msg = "Good Afternoon" Else msg =...

I have a macro that I have assigned to a button which looks at a certain range of cells formatting, and upon clicking on the button, it copies the cell formatting of the range, and copies it to another range on the same page and also other cell selections on another sheet. I also have some VBA...

I have a search bar/box which basically looks up Column A for the string that is searched, then if the string is there it is it filtered on that column and a 1 is added to Column J on that row. If the string is not in column A then Column B is searched and the same process as above happens...

I am trying to make a code that makes the program write data in a specific excel spreadsheet according to the value of the variable "MachineName" declared as public What happens is that the program does not allow me to do it because an error is detected on line 96 The error: The code...

I have a list box on my VBA form with a list of U.S. States. The person filling out the form will select states they wish to be licensed in for work. Following their selection and submitting the form I want the states they have selected to appear in 5 predetermined categories with a "," between...

Good evening, Please see the attached image or youtube video link below. I would like to know how to create multiple functions if one of the switch images is selected. For examples, if Switch 1 is off + Switch 2 is on, certain outcome happens if switch 1 is on + Switch 2 is off, a different...

I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...