Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
MS Word VBA Beginners

VBA to open or save Word document Protected or Encrypted with password

February 05, 2023
Kumarapush

Use this VBA code to password protect or unprotect the Word document while openening the file. This macro also handles readonly protection, Write protection etc., right within the code itself.

HTML / Javascript C Programming C++ PHP Programming Python R VB6 VBA Beginners Web Enhancements

Regular Expressions – I

February 05, 2023
Hitesh Kumar

A regular expression (shortened as regex) is an extremely useful way of matching common patterns and texts such as emails, phone numbers, URLs etc. almost all programming languages have a regular expressions library. It is widely used in text editors also to find patterns and replace string patterns that we specify in the […]

VBA Array Collection Data Type Dictionary VBA Beginners

VBA – Add Items to Array – Dynamic Resize without erasing data

February 05, 2023
Kumarapush

How to add new item to existing array? In VBA, an array is always an fixed size of data values. If you have to add new item, then size of the field also has to be changed. Lets see an example: Consider you have an array like the below one: […]

Worksheet Excel VBA Macro VBA Beginners

Rearrange Excel Sheets in Custom or Alphabetic Order with VBA

February 05, 2023
Kumarapush
0

Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order of the Sheet Names Lets get the code. VBA Code – Arrange Sheets in Custom Order To make the below code work, You […]

Excel VBA Beginners

How To Type Subscript in Excel – Superscript Options – Excel VBA Code

February 05, 2023
Kumarapush
0

How to type a subscript in Excel. Also learn to type a superscript for a part of text. This page also has macro code to convert a part of text in Excel to be subscript, superscript or strikethrough

Excel VBA Beginners

Excel VBA – Convert Column Letter to Number

February 05, 2023
Kumarapush
0

Get Excel VBA code to convert Column Letter to number. The Formula & Excel vba code will get column alphabet letter & return the Column number as value.

Excel VBA Beginners

Excel VBA – Convert Column Number to English Alphabet Letter

February 05, 2023
Kumarapush
0

Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.

Excel Excel VBA Macro VBA Beginners

Excel VBA – Copy Workbook – Active or External

February 05, 2023
Kumarapush
0

Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.

Excel Data Type VBA Array VBA Beginners

Excel VBA – Convert Range To Array – 2 Dimentional

February 05, 2023
Kumarapush

Get Excel VBA Convert a Range to Array code in a Excel Workbook. And also write the array value to a worksheet range. Learn how to use of Resize & Transpose functions.

Excel VBA Macro Excel Outlook Integration VBA Beginners

Send Email from Excel with Attachment using vba

February 05, 2023
Kumarapush
0

How to Automate Emails From Excel? Get macro to send email from Excel & email Excel file as attachment using VBA. In this page, you will learn and get code for 2 different things. Be it a professional Organization announcement, Promotional offer or a Valentine greeting email, these codes will […]

Posts navigation

1 2 3 Next
Excel VBA Macro Tricks
  • How to use Excel VBA Telnet To Autorun Commands?
  • Android ICS File Viewer – Calendar file View in Exce;
  • How To Speed Up Excel VBA Macro Execution Time – Optimize?
  • How To Sort by Color in Excel?
  • VBA Option Explicit Not Working – Solved
  • Create ListView in VBA at Runtime
  • Login to Facebook, Twitter, Google+ in IE from Excel
  • Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
  • Excel Sheet Protection Check
  • Convert CSV to Vcard File – Download Converter App
  • Enable Cut/Copy/Insert/Delete Options in Excel Right Click
  • VBA to Create Email List using Excel – Distribution List
  • Run Macro When Cell Value Changes or Range VBA
  • Import Mail IDs from Outlook Email to Excel
  • Launch List of Application – Batch Execution
MS Word Tricks
  • Find Synonym for Selected Text using MS Word VBA
  • Password Protect Excel 2010 & 2007
  • Word Mail Merge as Mass E-mail Marketing Services
  • Best Free Online PDF to Word or Excel Converter
  • Excel VBA Get Username – 6 Easy Ways using Macro
VBA Beginners Tricks
  • VBA – Add Items to Array – Dynamic Resize without erasing data
  • VBA Code – Create Index of Worksheets – with Links to each Sheet
  • Search for Value in Table using Beyond Vlookup
  • Making SORT More Simple and Faster in Excel with Advanced Options
  • How To Subtract in Excel?
  • Bulk Excel VBA Send Email with Attachments – 2 Multiple recipients
  • GB Whatsapp Features – Easy Download Steps
  • Excel VBA For each cell in Range – Direct method
  • Excel VBA Send Email at Specific Time – Outlook Delayed Delivery
  • How to Save Web Page as PDF File – No Plugins Required
  • Excel vba send email with attachments using Outlook App Mass Bulk email
    Bulk Excel VBA Send Email with Attachments – 2 Multiple recipients
    Get Excel vba send email with attachment code that uses Outlook app already installed. Send bulk emails to multiple recipients with different email.
  • GB Whatsapp Features Smartphone Messaging App Download page
    GB Whatsapp Features – Easy Download Steps
    Learn GB WhatsApp features compared to the original WhatsApp app. It offers enhanced security, privacy settings, customizations & more
  • Excel VBA Loop for each cell in Range of Worksheet
    Excel VBA For each cell in Range – Direct method
    Learn how to loop in Excel VBA for each cell in range of a worksheet. Also get its row, column numbers and values with the loop.
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved