vba

Hello! I am looking for a support to have a VBA code as mentioned in the thread. Is there anybody who can help? Sub Test_CreateZipFile() CreateZipFile "D:\MyFiles\t\", "d:\myfiles\Test_CreateZipFile.zip" End Sub 'https://exceloffthegrid.com/vba-cod-to-zip-unzip/ Sub...

Hi all, I'm working on a macro where I have to swap around some rows on a sheet. So I've added some grouping labels in column B, loop though my 150 rows and move blocks in a certain order. Moving means: cut and paste at the top. Roughly speaking, this is what I'm doing (option Explicit is on)...

Hi, I want to move 2 worksheets from one workbook to opened 10 other workbooks with one click, is there any solution? EDIT: I want to replace two old sheets (has same name as new sheets). Now I delete in every workbooks two sheets and then for each workbook copy two new sheets. ### Copy...

I have a table in a file (that I'll call my Working file, for the purposes of this question) which lists out services and has an on/off selection for each service, similar to the below: ServiceOn/Off ABC1 DEF0 GHI0 JKL1 MNO1 I have a macro that runs through this list - If the...

Hi, Hoping someone can help me out here. I am trying to loop through the worksheets called PP-RF*, read the contents in Column A and then copy the record to a named sheet. This code loops through the worksheet names: I am having trouble with the copying of the record to the named sheet...

Hi Experts Need some help. Can there be some VBA to go to home tab? Thanks a lot 🙏

I have a VBA that works ALMOST how I want it to work. The code below works, only thing is, after saving the file ANOTHER save as dialog box opens. I don't want a second save as dialog box to pop up AFTER the file has already been saved in whatever file type they picked. Private Sub...

It seems that Autocomplete text in excel works only in the same current page of excel sheet while when I go down to a new page, it doesn't work I works on a daily list of tasts where I need to assign a team member in front of each task and as the team names are almost the same people so I need...

Row 'I' is a dynamically changing column, Row 'H' looks to see if the value of column 'I' has already been listed in column 'N' and returns "Listed" or "Need To Add" which tells us to add it into column 'N' so the formulas can fill and we can review etc. I am looking for a VBA to take away the...

I send bulk e-mails to the company I work for, and with the e-mails I send, I determine the need lists and classify requests. In the Excel file I use for sending emails, column A contains email addresses, while columns B1:G1 contain equipment names, and column H1:H contains notes. For each email...

Hello, I'm trying to create VBA code that converts all current formulas in cells to text values and save the entire sheet to a new XLS file. For this purpose I've used the following VBA code, but it doesn't do what I want. The newly created XLS file still contains formulas in the cells. I...

Hi there! I'm working on a shared Excel tracker used by six team members. Each of us has an individual tab where we log incoming requests, and each request is assigned to a specific team, recorded in column I. Since workload fluctuates, requests for the same team may appear across multiple...

I copied the code below from a site which as you may notice it saves all attachments to newly created folder in my documents. I was wanting to see if someone might could modify it so it only saves attachments from the inbox of another email account I have in my outlook -...

I have found a code and modified it to perform my need which is to cycle the drop down list in a sheet and save the filtered data as PDFs in external folder with the currant date after the file name. but because the curranet date is changable of course, the folder still keeping the last time...

I have an excel vba userform from which I connect to an adodb (ms access), But I am trying to filter on the date (Datum) field. Both via sql statement or the recordset.filter method but neither seems to work. Here is my code: Private Sub UserForm_Initialize() Dim con As Object Dim...

Hello Excel community, I've created an investing spreadsheet to track quarterly and yearly KPIs for companies I own. I'm looking for assistance with a VBA issue I'm encountering. Current Setup Two tabs: Quarterly and Yearly Each tab has charts that display KPI data over time VBA scripts for...

Hi, I have a sales report I want our clients to fill out. When they tell us the product # they sold I also wan them to tell us what that product is using a drop down the the next cell. However I know some of them with just copy and paste the data in which will remove the drop down if done by...

Hi all, Hopefully you can help. Im continuing on from another colleague. I have forms at work that need locking once you put your name at the end of each line, then depending on type of job will need same for block or blocks of cells on same form. The codes i have are (for for 1 column &...

I have an excel userform where I can search for and create new database entries in an ms access table. But when I try to edit existing entries it gives me an error that the object doesn't support this action. here is my code so far: Private Sub EditButton_Click() Dim con As Object...

I have a worksheet with a drop down list in "B2" to filter the data and I have a code to save the viewed information in the sheet as PDF to external forlder "D:\Desktop\Daily Tasks" and to name the file based on cell value in "C2" My drop down list has only 5 items (NH01,NH03,NH04,NH05,NH06)...