Category "vba"

How to get the locally formatted price out of these web pages

Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home

Excel Workbook overloading with memory when closing

I have a workbook that is about 8mb with about 20 different API calls (via formula in cells) using a 3rd party service. Everytime I try to close the workbook,

Return Excel VBA Macro OneDrive Local Path - Possible Lead

I have a spreadsheet that many people need to access (on sharepoint), for a few reasons, we need to do this locally (synced). however, there are constantly prob

How to copy column from last column N number of times?

I currently have the following code, which was made by a lovely member here Sub YearsNumberReduction() Dim LastCol As Long Dim DelCnt As Integer DelCnt = Sheet

Powerpoint VBA Select Folder of images, place those images on slides

How can I make the second set of code reference the selection made in the first set, instead of the hard coded location it currently uses? these two sets do exa

Have watches set automatically in VBA editor [duplicate]

I've been learning all the nifty tools I have to debug in the VBA editor for excel, but I can't figure out if there's a way to have watches st

File exists through Dir() validation, yet it doesn't get attached on mailing macro

I have a macro that can send multiple mails with attachments to an specific user, this had no problem when I sent 1 file to 1 user, but I modified it so it loop

is there a way to build a macro that won't duplicate data

I used code from the following article https://docs.microsoft.com/en-us/office/vba/api/excel.range.copy to partially accomplish my goal but I have a few more qu

Draft emails with email signature

i am trying to send emails through excel and keep the email signature i am able to either save .body as text withough the image or insert the image through .HTM

Use VBA to @-Mentions a user in a Threaded Comment in excel

I added a UserForm into my file so comments can be added to a cell (that way I can update the data on other cells when a comment is added and someone is mention

I have to convert excel rows into individual text files and the text files should be UTF-8 encoded

I am using this code to convert rows to individual text files. Sub SaveWorksheet() Dim MyWorkbook As Workbook Dim MyDataWorksheet As Worksheet Set MyWorkbook =

Excel VBA code error type mismatch using worksheetfunction to find duplicates

I get a Type Mismatch Error "13" with the below code. Can anyone assist with where I'm going wrong with my VBA syntax and use of variables. If Applicat

Intermittent "Run-time error '1004' PasteSpecial method of Range class failed

I have a macro that intermittently throws a run-time error when doing a PasteSpecial. Most times it runs through to completion without failing, but sometimes i

Excel macro to insert certain characters into column

Im currently using this. while this works for now. Im looking to add code that allows me replace everything in that column. Not just limited to only replacing t

Can't figure out how to make ".EntireRow.Delete" delete a Cell in another worksheet [closed]

I can't make this work. I've tried everything! .EntireRow.Delete has so far only worked when i used .Select to choose cell 33,2 but due to wha

How to use an entry in a vba textbox as the "Link Location" within the hyperlink formula?

I'm still reasonably new to VBA and I'm trying my best to learn, but this one has stumped me. I have a Userform where one of the textboxes is for a user to ente

Searching olFolderSentMail by domain of email address with VBA

I want to find mail in the olFolderSentMail folder, using the domains of the email addresses, with VBA. When I make an advanced filter in Outlook, the result co

Mirror worksheet between two workbooks

What I am trying to achieve is as follows, I have "Workbook A" and "Workbook B", within Workbook B there is a worksheet "SheetB2" which I would like to be inclu

Export to PDF and Prompt User for Folder Path and File Name to Save

I can't figure out how to prompt the user for a folder path and the save name. Below is the code I have gotten to work. Sub PrintToPDF ThisWorkbook.Sheets("Sh

Shortest Flow Layout Solver

I have a routing sequence for a set of machines on an assembly line. Each route has to go through the entire line (that is, if you only run the first and second