So sorry if this has been asked before, I have a need to save down each email I send into a local folder (These are then archived each month) and I have been us
I am trying find e-mail that matches body text and sender. Each day I check if 300/400 emails were already sent. I need to iterate through more than 4500 emai
I'm having some problems with some pieces of code that I've Frankenstein'd from the web. I have a Word document that uses a command button to run a piece of cod
I'm currently using a code to update a file with a loop running through multiple sheets. Up until now, the code ran smoothly. On today's run, I encountered "run
I have a list where I have to copy date in each row in another worksheet and Save it as PDF Data is in each row in "Instruction" tab, that need to be copied in
What can be happening that slows down Excel to a crawl, sometimes for a minute or two, sometimes for hours, and its workload is spread across calls to DoEvents?
When opening Excel it looks for an add-in that I have removed from the file folder. It gives me the message that it can't find it, of course,
I have sheet with same data in adjacent cells,I could to merge same cells on column A. now I need to merge or combine adjacent same cells beside merged cells on
The following Single line of executable code; .. Works on my work PC (Win10 Pro 21H1) .. Crashes on my home laptop (Win 10 Pro 21H1) Exact same version of Excel
I want to run this in loop by taking two variables for example i and j. Suppose i for sheet 1 and 2 and j for Sheet 3 until I dont reach the e
I have an Excel file containing thousands of rows. There are ID, Planned End Date, and End Date columns. All IDs need to have at least one sam
Im new to VBA, and i have something i dont understand now. I've been trying to copy Worksheets by only copying Cells with a specific colour in a cell below. I w
I would like to write a dataframe to an existing .xlsm file which already has content. Write pandas dataframe to xlsm file (Excel with Macros enabled) describes
Basically, I hoping to achieve 2 things here. I want to know if there is a way to make this multiple criteria IF statement shorter/more effici
I am trying to map a SharePoint document library so I can parse it with a FileSystemObject. Here is my code ... Dim objNetwork As Object Set objNetwork =
I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data sho
I would like to use cell values on Sheet 4 to select and export Sheet 1, Sheet 2, and Sheet 3 as one PDF file. For example, if Sheet 4's A1=1, A2=1, and A3=0,
I want to set a table autofit in Catia drawing. But I can't find any command. I'm looking forward to getting some guidance. Thanks [] There is my simple code. D
I have 2 worksheets (Input & Record), I just want to copy some data from "Input" to "Record", it worked but if I protect "Record".... Paste method of Worksh
New in VBA, did tried different examples available on the web but can't make it work as my string only increment by 1 & subsequent executions, the string st