I copy a range and paste into Outlook email with signature. I want to reflect the range in center of body of email. Dim OutApp As Object Dim OutMail As Object D
In Excel sheet Products, in a table named Products I've example data. I want to copy the three leftmost columns to the clipboard, next save it's contents to fil
I am not able to take the reference from column AB and AC given in sheet ("UPDATER") to sheet("Historical_vol"), can anyone please confirm what am i doing wrong
I have an existing Excel file I need to work with. It contains a line graph where measurement results are plotted. All the referencing is done via names. The gr
i am trying to scrape date from https://www.jjfox.co.uk/aj-fernandez-bellas-artes-maduro.html using Json parser with the following code. the code does not howev
I would like to get the current week number. I tried this: MsgBox (Format(Now, "ww", vbMonday)) The result: 3 But it has to be 2 Where is my mistake?
Long ago I had a macro that would open some workbooks, do some fiddling, then close - all fully automated, called from the commandline so I could batch file it
I am trying to split a string and create a loop for going through the Cell I Want Only This Code Results Column Wise I want A Row Wise Insert
I have a little problem, thanks for whatever help you might bring :) my goal : i want to create a vba function that receives an address and returns the gps coor
I am trying to automate a work task using excel VBA. I can't seem to get all the source code. I created this simple code to test it. dim IE as object Dim S as S
I want to open a pdf according to the codes in a table that changes daily from the archive with thousands of files. It has to search in two ways. Search by BA22
I am trying to save attachments from an email. I get the error message Outlook cannot perform this action on this type of attachment Using Debug.Print outAtta
I'm struggling with data validation for the range of cells in a For loop. I want to use a custom formula with COUNTIF to check for unique values. I found exampl
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,