vba

  1. 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...
  2. 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...
  3. 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 -...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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 &...
  9. 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...
  10. 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)...
  11. D

    Populate excel listbox with database table

    Hi, I am trying to make an excel userform that connects to an access database. So far I can search and create new database entries from withing excel. But I can't seem to populate my listbox with a selection of my database table. Here is my code for initializing the userform and fill the...
  12. C

    VBA form not being recognised by the code

    Hi All, I've searched this forum and others without success solving this weird problem. It might be an Excel bug, but I'm hoping it's just something I'm doing wrong. My fairly basic spreadsheet has two userforms. One works perfectly well but the other won't even load. It did when I first...
  13. Ramadan

    How to include my email signature in VBA

    I have found a code on the web to send excel file as attachment and modified it to settle my needs but I need your professional help to add my signature image to the email body and to make the email body text to be set as (Right to Left) here is my code and screenshot of my email signature need...
  14. M

    VBA code failing and miscalculating when running high numbers of lines (200+) but ok when doing it line by line

    Hi, Is there any way to help solve this issue. Currently I have a tab called 'BATCH' where I paste all my data. VBA code is written to calculate different versions of premiums by different permutations (code below). Suddenly the VBA miscalculates (so putting 365 values where 30 values should be...
  15. B

    Found a VBA code to rename sheet name as the current date, but now, trying to make this new sheet as the active worksheet.

    Hi everyone I found a VBA code to rename sheet name as the current date, but now, trying to make this new sheet as the active worksheet. Everything works well except for making the newly or existing worksheet the active worksheet. I have tried 2 commands (those rem out and in red), and they...
  16. R

    find last row in column c and fill out column A and B untill last row found in C

    how can I find last row in column c and auto fill out column A and B based by drag down formulas present in row A2 and B2 until last row found in Column C using VBA / Macro?
  17. A

    Detecting when a user has highlighted a row and displaying the contents of that row in another sheet

    Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it? This is an example of the data in sheet2 (where the content...
  18. M

    MSXML2.XMLHTTP very slow windows 11

    The following code is fast in windows 10, but in windows 11 it can take up to a minute to receive stock data. Any ideas? LocalFilePath = folderPath & "/stockData.csv" Application.ScreenUpdating = False Set oReq = CreateObject("MSXML2.XMLHTTP") With oReq .Open...
  19. T

    VBA code wont open new version of Outlook!

    Hi All I have been using the below code to open Outlook and send off an email but since some of the users have updated their outlook, it doesn't work? Dim xOutlookObj As Object Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set...
  20. M

    Updating Conditional formatting using VBA adds in conditions rather than replacing them

    I have a sheet where users will sometimes paste in elements. In doing so they can replace the conditional formatting in either nothing or some other formats. I have some VBA on a button designed to replace the formatting with the "correct" conditional formatting (see below). The issue I am...

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