vba

  1. S

    VBA Code to ZIP a folder with the structure (Subfolders) but only PDF's files

    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...
  2. Rijnsent

    Macro speed - copy/paste rows

    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)...
  3. M

    VBA

    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...
  4. M

    Opening files from SharePoint using VBA breaking/running incredibly slowly

    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...
  5. J

    Copy and paste rows with a criteria

    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...
  6. SanjayGMusafir

    VBA to go to Home Tab

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

    BeforeSave VBA Save As Dialog Help

    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...
  8. Ramadan

    VBA to Autocomplete text in the same column

    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...
  9. P

    VBA Check list and paste values not found in list

    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...
  10. B

    Is there any way to processing the data in the mail to Excell

    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...
  11. D

    Vba to create a new excel file and convert all cell formulas to text

    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...
  12. J

    Dynamic Email Generation via VBA - Extracting & Sending Data Across Multiple Sheets

    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...
  13. B

    Outlook VBA Macro Saving Attachments

    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 -...
  14. Ramadan

    Override the last saved sheet as paf file

    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...
  15. D

    Excel vba userform trying to filter ado recordset

    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...
  16. M

    VBA Help: Automatically Update Chart Series for New Time Periods in Investing Spreadsheet

    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...
  17. J

    Drop Down that can have data pasted into it without losing the drop down

    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...
  18. D

    Locking of cells after not working

    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 &...
  19. D

    Excel userform edit database table

    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...
  20. Ramadan

    VBA to Navigate Drop Down List and Save page as PDF

    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)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top