I am working on a vba macro to parse large xml files. Initially, i made use of DOM parser but due to memory leak the system hangs and that could not solve my pr
I was wondering if there is a way to add the Reply arrow to a selected mail in Outlook via VBA. The background is that we process a selected mail via VBA and cr
I am trying to copy a whole pdf document into excel using the following code. The code works perfectly except for the paste part, when it gives me the following
I am trying to insert 2 different ranges "x" amount of times based on the input from the user. The user chooses how many mounts they need "D22" and a range is c
'This code generates files that cannot be opened Sub DownloadPicturestoFile() Dim FileUrl As String Dim objXmlHttpReq As Object Dim objStream As Object Dim Nam
I have an input text file(Line size and column size varies). I want to convert it into document with the same format(same length as in text file, not to span to
In my vba code right now the goal is to add a plus and minus button every time the add button is pressed. As you can see in the gif when the user presses add a
I have a VBA script that copies and paste data from one workbook to another, but I would like to get my script so when I click run, windows explorer window open
I have a Excel file containing data for simulations. Each row is a simulation and contains data that i want to copy and paste into another software at a specifi
I've been stuck with this code for MS Word. My task is to change every spacebar in document with a random word from array. I mean to put random word in document
I currently have this code : Sub FilterRows() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Sheets(ws).Range("A1").AutoFilter
I am trying to save a workbook with the value from a cell as the file name. This code will save it as a specific file name, ActiveSheet.SaveAs FileName:="C:\Des
I have working code that requests information from a website. When I send the file to another PC and run the code, I get: "Run-time error'91': Object variable
I track our writers' monthly payments, and have created a workbook with a worksheet including a summary of each writer's pay. The sheet includes a vlookup that
I need to edit an old Access form. When a person enters information into a form field, a number associated to a name is found through a SQL SELECT statement. "S
I have active sheet open (Sheet1). I want to pick a value from C column then go through each workbook and within each workbook there are many sheets. If that va
I have a tab called "Overview" where it asks me for the name of a project. Once I write the project name, I want a macro to grab the project name, create a new
I am trying to learn EXCEL VBA. One of the tasks I am stuck with is how to verify textbox1.text is valid excel formula. I tried Worksheetfunction.isfunction(use
I am trying to extract data from different sheets in a summary sheet. The referencing does not work. Sub Summary_LPI() Dim wkSht As Worksheet, wsC As Workshe
I want to replace a repeating year of dates in a column. I started with a nested for loop in a single module, then I changed the code to be used for each sheet