I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data sho
I would like to use cell values on Sheet 4 to select and export Sheet 1, Sheet 2, and Sheet 3 as one PDF file. For example, if Sheet 4's A1=1, A2=1, and A3=0,
I want to set a table autofit in Catia drawing. But I can't find any command. I'm looking forward to getting some guidance. Thanks [] There is my simple code. D
I have 2 worksheets (Input & Record), I just want to copy some data from "Input" to "Record", it worked but if I protect "Record".... Paste method of Worksh
New in VBA, did tried different examples available on the web but can't make it work as my string only increment by 1 & subsequent executions, the string st
Could someone please help me to mask the password entered to the input box generated using the below code. I will be using Office 365 ProPlus. Option Explicit P
I have a script to iterate through my calendar events that day and produce in a separate email a list in the following format: Event 1: Subject: When: Attendees
I have two separate error handlers. Both look for if two separate workbooks are open. Sub ErrHandler() wbsource_name=ThisWorkbook.Worksheets("Sheet1").Range
1. What I'm Trying To Do I have a folder with 84 Word documents (.docx). Every document contains a table of identical layout (some of the documents span across
The code below uses FSO to read a file containing information such as version, date and file path on a local network, and download a file according to local fil
I tried many approaches from last few hours but no luck. Somebody please help me. group_dt = pt.PivotFields('Created') group_dt.LabelRange.Group(Start=True, End
I would like to get the email address from the true contact that is sending the mailItem. I don't want the on behalf email address. Is there a way to do that? O
I found the code below which works nicely and I think I can repurpose it for my needs, but does not include the precipitation. I'm relatively new to HTML so hav
I'm attempting to open a dot .eml file stored locally and access the attachments file name with a excel macro. I've gathered some code that does the job but not
I have VBA code by which I send mails with specific string body. I need this code to paste specific range(B2:F13) from sheet "MAIN" to mail body with its format
In my table (Range("A3:K9999")) there's one column E (E3:E9999), which contains drop down lists. My goal is to have the bg color changed in the whole table line
I'm trying to write a program that updates a Word document's metadata with content control boxes. The Excel document then loops through a directory that holds t
I am trying to find out how to identify the current group level of a range in office-script. Based on the documentation I was only able to find the group or ung
I am working on a VBA Module for an interactive PowerPoint. Specifically, I would like a text box to display the current time and update every second (like a li
I'm trying to find the Xpath for this HTMLcode: (Copied XPATH) /html/body/hub-menu//section-header//hubmenu-wrapper/div/search-customers//input [Picture af the