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

May 18, 2022
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.

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

Regular Expressions – I

May 18, 2022
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 […]

Collection Data Type Dictionary VBA Array VBA Beginners

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

May 18, 2022
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: […]

Excel VBA Macro VBA Beginners Worksheet

Rearrange Excel Sheets in Custom or Alphabetic Order with VBA

May 18, 2022
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

May 18, 2022
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

May 18, 2022
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

May 18, 2022
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

May 18, 2022
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.

Data Type Excel VBA Array VBA Beginners

Excel VBA – Convert Range To Array – 2 Dimentional

May 18, 2022
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 Excel VBA Macro Outlook Integration VBA Beginners

Send Email from Excel with Attachment using vba

May 18, 2022
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

  • Excel Convert – Number To Date – VBA Date Format
  • VBA Msgbox with Yes No Cancel Options
  • Mortgage Calculator – Loan EMI Scheduler – in Excel
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • JSON Parser – Convert JSON To CSV – Excel VBA Macro
  • Excel VBA Delete Folder if Exists
  • VBScript Extract Data – Xmlhttp Web Scrape – Parse HTML
  • Excel VBA – Get RGB Color of Cell – Change Background
  • How to do Spell Check in Excel?
  • How to open VBA in Excel – Macro code editor?
  • VBA Code – To extract data – From website to Excel Macro
  • VBA Macro Import – Read XML File into Excel – 5 Easy Tips
  • Excel VBA Color Index List – Worksheet Interior Font – Colour Codes
  • How To – Connect Excel To Access – Database Using VBA
  • Lock a Folder – In Windows – Excel Folder Lock Code

MS Word Tricks

  • How to Convert Docx to PDF – VBA Save Word as PDF
  • Excel VBA Get Username – Windows Current User Name – File Author
  • Find Synonym for Selected Text using MS Word VBA
  • Password Protect Excel 2010 & 2007
  • Word Mail Merge as Mass E-mail Marketing Services

VBA Beginners Tricks

  • VBA Macro Import – Read XML File into Excel – 5 Easy Tips
  • Send Email from Excel with Attachment using vba
  • How To Subtract in Excel?
  • Excel VBA – Import Data from another Workbook – 4 Easy Ways
  • #N/A Error In Excel – Generate, Analyze & Exclude
  • How to Save Web Page as PDF File – No Plugins Required
  • How to Replace #N/A in Excel with 0 or blank – using Formula?
  • Net Run Rate Calculation in IPL, T20 & One day Cricket – Formula
  • Outlook VBA – Sort Emails by Date – in a Folder
  • New Update – Very useful for Whatsapp Web Users
Error Handling Excel Formula Tricks NA

How to Replace #N/A in Excel with 0 or blank – using Formula?

May 18, 2022
Kumarapush

How to Replace #N/A error in Excel Formula & Vlookup? In many of the Excel

Excel OutLook

Outlook VBA – Sort Emails by Date – in a Folder

May 18, 2022
Kumarapush

VBA Code to Sort Outlook Emails by Date In Outlook app, when you are viewing

Dropdown Excel

How to remove Drop down list in Excel?

May 18, 2022
Kumarapush

Delete a Drop down data valition list in Excel A drop down list in Excel

Excel

How to create drop down list in Google sheets?

May 18, 2022
Kumarapush

Add Google Sheets Drop Down List Here are the steps to create a drop down

Browser Chrome Firefox IE Opera Safari

How to Save Web Page as PDF File – No Plugins Required

May 18, 2022
Kumarapush

Save Web Page as PDF from Chrome, Edge or Firefox? This method of saving a

Error Handling Excel Formula Tricks NA

How to Replace #N/A in Excel with 0 or blank – using Formula?

May 18, 2022
Kumarapush

How to Replace #N/A error in Excel Formula & Vlookup? In many of the Excel

Cricket CSK IPL IPL Sports

Net Run Rate Calculation in IPL, T20 & One day Cricket – Formula

May 18, 2022
Pooja

How to Calculate Net Run Rate (NRR) - IPL Points Table? The direct formula to

Excel OutLook

Outlook VBA – Sort Emails by Date – in a Folder

May 18, 2022
Kumarapush

VBA Code to Sort Outlook Emails by Date In Outlook app, when you are viewing

Copyright All rights reserved