I have a code in VBA that I've always used to open Internet Explorer, copy the information on an specific website and than paste in a cell. The issue now is tha
I don't understand some parts in the following code: For i = 2 To UBound(a, 1) txt = Join$(Array(a(i, 3), a(i, 4)), Chr(2)) If Not dic.exist
The context is that I have a boatload of data dictionaries for various data bases strewn across multiple Word document files. Those files hav
Is it necessary to develop an interrupt mechanism for IDEA?
I want to insert an if statement in a cell through vba which includes double quotes. Here is my code: Worksheets("Sheet1").Range("A1").Value = "=IF(Sheet1!B1=
I want to move files to created folders. I got a mismatch error every time. The aim is to create a folder named after the file prefix if it doesn't exist and co
My goal is to add a icon to my toolbar in the quick access section. I wish this code could look at the file that is open, check if the file name contains or rat
I have a data structure (array) in Access - 6 columns and 10 rows. I'm trying to write to a range in Excel ie B3:G12. I'm getting tied up in loops, literally. F
My goal is to put the current week number in the subject of outgoing mail. Below gives me this week + 1. I used to have 2016, now have 365. Problem is still her
I have a table that contains the file path, when the button is clicked the macro will display an image according to the url path. Here is my code (sourch : Link
I'm looking for help with some VBA Excel code to do some merging of various sheets into a workbook and during the copy perform some worksheet functions (e.g.).
I'm trying to merge these 2 codes together. I'm very new to VBA and I can't figure out if it is even possible. I know I can't have the number change before the
Having UDF that extracts the words in sentences that have any colored character. The code is working but too slow. I tested the code at only 300 rows and it too
This block of code was working fine but I deleted some lines above Find() that broke it. Any ideas? Sub CopySheet() Dim TotalRow As Integer
I have a vba script that copies and paste data from one workbook to the other. The data that is being pasted over are wrapped text. I need my vba script to take
How can I loop through a set of variables which are numbered consecutively (Bay1, Bay2, Bay3, etc.)? I have 10 variables and I need to examine
I have multiple Excel workbooks some having multiple worksheets. I'm trying to export the duplicates across the workbooks into a new workbook using Column A of
I want to create issues in Jira based on Outlook emails received using VBA. However, when setting the assignee/reporter via the REST API it appears that users c
I have a document saved on SharePoint that documents testing. Once testing has been completed I would like to move the tests (entire row) to a separate sheet to
I'm trying to delete all duplicate rows based on Column B and leave only the unique rows. It will leave one of the duplicate entries. I tried with > 1 and =