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

Trending Now

Social Media Whatsapp

New Update – Very useful for Whatsapp Web Users

Android Whatsapp

Send WhatsApp without Saving Number in Contact

Android YouTube Youtube

How to share Youtube video link with start time? – Android/PC

Android Android SmartPhone Whatsapp

Bluestacks – Best Android Emulator – to install Whatsapp

Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

May 14, 2022
Kumarapush
MS Word VBA Beginners

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

May 14, 2022
Kumarapush
Excel VBA Macro

VBA Get Numbers with in a String

May 14, 2022
Kumarapush
Excel Excel VBA Macro VBA Array

VBA – Find number of Dimensions in an Array

May 14, 2022
Kumarapush
April 17, 2022

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

April 6, 2022

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

April 1, 2022

VBA Get Numbers with in a String

November 21, 2021

VBA – Find number of Dimensions in an Array

Browser Chrome Firefox IE Opera Safari

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

May 14, 2022
Kumarapush
Android Browser

New Android Update – View/Send SMS messages from any PC Web browser

May 14, 2022
Kumarapush
Android YouTube Youtube

How to share Youtube video link with start time? – Android/PC

May 14, 2022
Kumarapush
Google Adsense

[Proven] Increase Blog Revenue – with or without Adsense

May 14, 2022
Kumarapush
Network Security
February 3, 2021

Wired Equivalent Privacy (WEP)

Network Security System Control
January 27, 2021

Honeypot : Trap for Hackers

Security System Control Windows
February 3, 2020

Windows 10 Free Upgrade from Windows 7,8

Security Whatsapp
January 24, 2020

How to activate WhatsApp Dark Mode & Fingerprint Lock?

IP Address Network Security System Control
January 1, 2020

What is my IP Address?

Excel Excel VBA Macro Folder Operations Security
January 1, 2020

VBA get Path to Default Temporary folder

Outlook Macro Tricks

  • Export Outlook Calendar – To Excel – Vba Outlook Appointment
  • [Outlook VBA] Select Appointments/Meetings Invites in Inbox
  • This Tiny VBA Can Send Email to All contacts in Your Outlook
  • VBA Macro – Choose Outlook Email Account – To Send Mass Mail
  • Outlook Vba to create Email with Attachment
  • Software Downloads From Our App Store – Try Free & Buy
  • Excel VBA – Attach Inline Image – To Outlook Email body
  • Excel VBA Create New Workbook – With Name – Copy Save Close
  • How to remove Signature from Outlook Email using VBA code?
  • Convert CSV to Vcard File – Download Converter App
  • Save Outlook Mail Attachment to Local Folder
  • VBA Msgbox with Yes No Cancel Options
  • Outlook Archive Email – Move Email To PST – VBA Macro
Outlook Macro

Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads

May 14, 2022
Kumarapush
130

Tips on How to Export Outlook Emails to Excel, from Menu follow these steps. Learn to AutoArchive, Export Emails from Outlook to Excel VBA with these tricks

Android Excel Excel VBA Macro vCard (VCF) VCF To Excel

VCF to Excel Converter – VBA Code to Read vCard File

May 14, 2022
Kumarapush
5

Convert VCF To Excel – Convert contacts in VCARD to Excel with this app – Supports VCF file from Android, iPhone & Outlook & export VCF to Xls with ease. A Free Excel VBA Application Code. No installation required. Reads each contact detail from VCF file and export each to XLS format.

Android Excel vCard (VCF)

Excel To VCF Converter – 81,000+ Downloaded – Excel To Vcard App

May 14, 2022
Kumarapush
85

Excel to VCF converter: Get Excel to VCard converter built using VBA. Create Vcard file using contact in Excel. VCF is supported in Android, iPhone & Outlook. VCF file generated can be imported to Android, iPhone & Outlook contacts

Excel VBA Macro Web Scraping

Excel VBA html Table import – Export Web Table to Worksheet

May 14, 2022
Kumarapush
17

Export HTML table to Excel VBA. This code can also be used a Best Data Mining Tool. When Web query did not work, Use the option explained in this article to import Web page Table with just Excel VBA and process the Tags as explained in this quick reference Tutorial.

Excel Excel VBA Macro Network Web Scraping

VBA Code – To extract data – From website to Excel Macro

May 14, 2022
Kumarapush
6

Get VBA to extract data from Website to Excel. With this Web scraping Excel vba code you can import HTML data of any website & then parse it using IE DOM objects. Excel Data Mining Tool with VBA Code.

Excel Excel VBA Macro Outlook Integration

Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook

May 14, 2022
Kumarapush
12

Send Email from Excel VBA to Multiple recipients using Outlook. Learn how to send bulk Email from Outlook using Excel VBA to multiple recipients. Mass Email

Browser Chrome Firefox IE Opera Safari

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

May 14, 2022
Kumarapush

Use this easy trick to save the Web page to PDF file. It is a straight forward method that enables to save whole website page into single PDF file.

Error Handling Excel Formula Tricks NA

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

May 14, 2022
Kumarapush

How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.

Cricket CSK IPL IPL Sports

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

May 14, 2022
Pooja
0

Here is how the Net Run Rate is calcualted in Cricket matches. This run rate calculation formula is applcable to IPL, T20 & Oneday tournaments.

Excel OutLook

Outlook VBA – Sort Emails by Date – in a Folder

May 14, 2022
Kumarapush

Get Outlook vba code to sort emamils by date in the inbox or in any folder. This code can sort the emails by oldest first/newest firlst as per your choice.

Social Media Whatsapp

New Update – Very useful for Whatsapp Web Users

May 14, 2022
Kumarapush

Learn how to use Whatsapp Web without keeping your smartphone online with the latest update from Whatsapp team itself.

Dropdown Excel

How to remove Drop down list in Excel?

May 14, 2022
Kumarapush

Learn how to remove a drop down list in Excel using these simple steps. This trick is a quick shortcut just by using copy paste method.

Excel

How to create drop down list in Google sheets?

May 14, 2022
Kumarapush

Learn how to create a drop down list in Google spreadsheet using the built in Data validation option, just similar to the MS Excel dropdown lists.

Excel VBA Macro Worksheet

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

May 14, 2022
Kumarapush

Learn VBA to unhide all sheets in a Excel workbook. This code sets visibility property of sheet to unhide even the very hidden sheets.

Excel Keyboard Shortcut VB6

VBA Userform – Escape key to Close – Unload form

May 14, 2022
Kumarapush

Learn how to close a vba userform with escape key. Map command button to Exit or Close a Userform with Escape key.

MS Word VBA Beginners

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

May 14, 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.

Posts navigation

1 2 … 49 Next

The news you may have missed

May 10, 2022

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

May 2, 2022

Outlook VBA – Sort Emails by Date – in a Folder

April 24, 2022

How to remove Drop down list in Excel?

April 24, 2022

How to create drop down list in Google sheets?

April 17, 2022

VBA Unhide all Sheets in Excel or with their Name – VeryHidden Worksheets

April 8, 2022

VBA Userform – Escape key to Close – Unload form

  • 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 14, 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 14, 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 14, 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 14, 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 14, 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 14, 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 14, 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 14, 2022
Kumarapush

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

Copyright All rights reserved