vba

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

I have a workbook that I need to select rows that have cells numbered in one worksheet, import them into another worksheet, sort them based on a value in one column, The first worksheet can be 150 rows long and would look like the table below (with data in columns C through O too)...

Hello all, Need some assistance. BACKGROUND: Every month a New Customer Report generates and new customers get added to the bottom of the Excel sheet. I manipulate the report some and send out to staff. I want to automate this and what I am struggling with is the code top copy and paste NEW...

I simply need to change the font of a row after the table last row + 2rows for cells from ("A: M") but I don't know how to write that in VBA code ... I have a code to Addnewrow and I wrote the last section in the below code but unfortunately wrong any sugesstion please Sub Addnewrow() Dim...

Hello, I'm looking for a way to get the name of a Form Controls Spin Button on a Worksheet, not in a Form. I'm working on a macro that builds a calendar, and I'm having to delete the button manually each time I want to clear everything and test my code. I'm trying to avoid deleting all...

I have created a userform with 3 buttons, "Save as .XLSM", "Save as .PDF" and "Cancel" What I would like is for this command box to pop up when we go to save the document (click on save as > browse) The buttons work just fine every time someone hits Save as .PDF. BUT, it will only work once...

https://stackoverflow.com/questions/79338433/the-vba-code-slows-down-the-worksheet-needs-to-be-faster?noredirect=1#comment139908100_79338433

In my line of work, virtually every company uses some combination and variation of VBA tools that essentially links Excel & Word documents to produce ±100 page report deliverables. Most of this is done through VBA tools either made by 3rd party technology solution providers, and some are...