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
How can one collapse multiple rows of data such that it matches with its unique id. The data set is dynamically loaded from web. It is sorted by date so that ea
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
Suppose we have an excel spreadsheet that looks like: StatusCount FirstName LastName ID 1 Tod Mahones 122145 0 Tod Maho
How to extract / filter an inventory list (in range B3:C7) based on a lookup list with partial strings (in range F2:F3)? I know that if the filtering strings w
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 want to export to excel but filter search doesn't work when I select range date and export the result is all data before filtering, public function download_e
My dataset looks like this: I am looking for a formula to add to the column "Status" to do the following: If Name = "A" and Project = "TT" and Number > 5, w
First, environment: Excel Version 1905 (Build 11629.20246 Click-To-Run) Connected to Office 365 ProPlus Windows 10 Enterprise 10.0.16299 Build 16299 I've bee
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 the author of an Excel add-in that loads data from an internal api. What I want to do is avoid having many users run the StreamingInvocations concurrently
I am the author of an Excel add-in that loads data from an internal api. What I want to do is avoid having many users run the StreamingInvocations concurrently
Currently working on a robot where I want to download an excel file from a system, copy paste the contents of the excel file to a word file as an embedded excel
In the Microsoft graph REST API docs, it shows how to call a function from an excel sheet. https://graph.microsoft.com/v1.0/me/drive/root:/boo
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