vba

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

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

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

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

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

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?

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

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

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

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

I have a macro to save the workbook into pdf that is currently "running" but deleting a sheet that I do not want deleted. Here are the steps of the macro. 1. Make the necessary tabs visible. - Works 2. Unprotect workbook. - Works 3. Create a copy of a tab for each varation of a value in a drop...

Hello everyone, I am trying to add a new measures using VBA to my power pivot data model. Unfortunately I keep getting this run time error 438. I am using windows microsoft 365. Below you can find the whole code. I have colored red the part of the code that is giving me the previously mentioned...

The function is to put an 'X' on the row within that column when the keyword matches what is in column A. I have this working for column 'E' but I would like to apply it to columns F-K as well with the same function. Any suggestions are appreciated! Thank you in advance! Private Sub...

I have the following element that is the 4th element on a nav bar within a website: <a href="#step3" data-toggle="tab" data-bind="click: function(){ viewModel.GetRequiredDocuments(viewModel.xxxx); viewModel.xxxx(); }" aria-expanded="true">Documents</a> I am able to select the element. I...

Hi, i am never created my own VBA before. However, i needed to make XML file from my excel data. I want to have some condition such as ignoring empty row, ignoring character such as / - @ #. The VBA also only processing data from certain row until certain row dynamically with the last row is the...

Hallo Zusammen, da unsere Firme leider noch sehr viele alte Worddateien im einsatz hat, welche aber oft nicht richtig Laden etc. Es funktioniert in Excel teoretisch genauso, weshalb ich hoffe ihr könnt mir helfen. habe folgendes Macro erstellt um doc. in docx. umzuwandeln. Dieses Macro...

Good day. I have a functional Excel knowledge; however, is very new to task automations. Essentially, I want to automate the following process using Windows Scheduler and Excel Macros: - Open Excel - Open PERSONAL.XLSB - Open latest file in the specified path - Run Macro called...

Hello dear excel-lers, I have a workbook that helps me to record people's phone attendance on weekly basis. Each sheet is a list with names and timeslots. Users then are expected to choose from a drop-down menu 1 of 3 options (1-office, 2-home office, 3-formation). There is also a formula that...

I have a worksheet that only receive updates from other sheet with filter formula, no manual entry at all occurs in this sheet and I need a code to add the current date Now() in cell "C3" as soon as the sheet receive any update from the source sheet .. I have a code but it insert the date based...

Hello, I am trying to unzip a file for folder based on Cell Range. For Example Cell Range A1: have my file name (xyztestfile.zip). I am new to VbA and need help