I want to specify a word plus a date in a cell. Sub CurrentTestCell() With Range("i2") .Value = ("Test") And Date .NumberFormat = "mmmm yyyy" End
A 'pptx' format file should be able to export to a 'svg' file or some 'svg' files (just one slide to one 'svg' file) in the latest version of PowerPoint(the fun
I am trying to compare two cells in a table: The column "MR" is calculated using the formula =ABS([@Value]-A1) to determine the moving range
I am writing a program in the Worksheet_SelectionChange event to better understand the worksheet events, how it is fired and such. My program takes the string i
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