i want to select the listitem by hovering the mouse not by clicking.. how to achieve in vba.. i saw a code in a forum using vb.net Private Sub ListView1_MouseMo
I have a script that loops through all the PDFs in a folder and attaches them to an email. However if there are spaces in the pdf names it will replaces this wi
So although Excel not being made to create programs in, I'm completing one. Rest of the workbook works great but facing an issue with a sub which I'm yet to fin
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