In this article I will explain how you can open a word document using VBA. – Opening Word Document: If you are opening a word document from word you can use the code below: Sub main() Documents.Open (“D:TestFolderMain.docx”) End Sub Where “D:TestFolderMain.docx” is the path where the word
In the article Excel VBA, Gradient’s Colors I’ve explained the basics about working with gradient’s color. I’m assuming the reader is familiar with the topics covered in that article. – Gradient Color, Row: In the article Excel VBA, Gradient’s Colors I provided 2 examples for creating gradients with different colors. The examples
If you’ve been reading about custom formatting in Excel you’ve probably stepped on the @ character. So what is it? For input values of the text type the @ character specifies where to put the the text. I will explain this using examples – Example
You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.
This article explains how you can display the result of an Expression in a form control. Consider the table below: We want to create the following form: The form has 4 textboxes: TextBox #1: Displays the value of “Field1” Textbox #2: Displays the value of