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

Add Time Stamp to Notepad Text File

November 25, 2024
Kumarapush

How to add Date Time stamp in Notepad File There are 2 ways to do this. First one is manual & the other is automatic. 1. Press F5 will insert current date & time 2. Type .LOG as first line of notepad file. (case-sensitive) What is the difference between these […]

File Operations Excel

Excel VBA Get File Extension – 2 Simple Methods

November 25, 2024
Kumarapush

Using Excel VBA get File extension from file name using this simple macro code. The code extracts the File extension using VBA File system object.

Date Functions File Operations

Excel vba Add Date Time Stamp to File Name

November 25, 2024
Kumarapush

Save File with Date Time Stamp In Excel vba we can create new file or save the current workbook with different name. In that case, sometimes we add date, time or both at end of file. This way, the file names will be unique & also the file versioning can […]

Excel Color Excel VBA Macro

How to do Spell Check in Excel?

November 25, 2024
Kumarapush

How to spell check in Excel? Easy steps to invoke checkspelling module in Excel cell, range, worksheet or word thru menu and VBA Macro,

Duplicates Color Excel

Highlight Duplicate Values in Excel with Color

November 25, 2024
Kumarapush

Learn how to highlight duplicate values in Excel using the conditional formatting. Also the formula to find duplicate entries in a Excel range.

Duplicates AutoFilter Excel VBA Macro

Excel VBA Remove Duplicates Values

November 25, 2024
Kumarapush

Get code in Excel VBA to Remove Duplicate values from Worksheet Range or Column etc., This code uses the Excel’s built in Remove duplicates option

Web Scraping Excel VBA Macro Network Security

How to Web Scrape with VBA using IE & Parse HTML?

November 25, 2024
Kumarapush
0

Get VBA code to web scrape using IE & then parse HTML data from website. The extracted website data is Parsed within Excel VBA code itself.

Color Conditional Formatting Excel Formula Tricks

How to make every other Row or Column shaded in Excel?

November 25, 2024
Kumarapush
0

Learn how to make every other row shaded in excel. Alternate Rows/Columns background color can be set using conditional formatting, VBA & by inserting table

Network Excel VBA Macro System Control

How to get Computer MAC Address using Excel VBA?

November 25, 2024
Kumarapush

Get VBA Code to find the MAC address for a computer. This VBA code will list the MAC Address of all the network adapters installed in your computer.

Network Excel VBA Macro

List all Network Adapter, MAC , Enable Disable Connection using VBA

November 25, 2024
Kumarapush
0

List all Network adapters in a computer using Excel VBA. Get MAC address, Connection status, Name etc., Disable, Enable, On/OFF any Network adapter.

Posts pagination

Previous 1 … 10 11 12 … 30 Next
Network Tricks
  • Honeypot : Trap for Hackers
  • How to Web Scrape with VBA using IE & Parse HTML?
  • Vba Get Computer Name using environment variable
  • VBA – Check for Active Internet Connection – Network Status
  • How to Automatically pull data from Website into Excel VBA?
  • VBA Get My Public IP Address
  • What is my IP Address?
  • List available Wifi Networks & change Connection
  • Find Local IP Address – VBA Macro Code
  • Excel VBA Hyperlink Follow – URL within Macro
  • How to get Computer MAC Address using Excel VBA?
  • Overview of Data Communications and Networking
  • Wired Equivalent Privacy (WEP)
Date Functions Tricks
  • Printable 2022 Calendar Excel – Month Wise Template
  • Convert Excel String To Date – VBA Date Format
  • Excel Vba Save a Copy of Workbook with TimeStamp
  • Find Last Day of Month – Excel Formula & VBA
  • Get Current Date in Vba
File Operations Tricks
  • Excel vba Add Date Time Stamp to File Name
  • VBA – Find My Documents, Desktop & System Folder Path
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • PHP Check If File Exists in a Folder path – in 2 Easy ways
  • Get List of All Subfolders in a Folder – Excel VBA
  • Creating Folders Using Python: A Simple Guide
  • A Simple Guide to Copying Excel Sheets
  • Retrieve All Files in a Directory using Python
  • Creating Folders in Outlook: A Guide
  • Chandrayaan 3 Live Stream Today – Vikram Lander
  • Creating Folders Using Python: A Simple Guide
    As the world of technology continues to advance, it becomes evident that the ability to manipulate, create, and manage digital spaces is of utmost importance. Python programming language is among the most powerful tools capable of such feats. This exciting exploration commences with an introduction to Python, providing essential knowledge […]
  • A Simple Guide to Copying Excel Sheets
    Navigating the intricate landscape of Microsoft Excel can often seem like a daunting task. This software, with its abundance of features, functions, and commands, requires a keen understanding to fully utilize its potential. Whether you’re an industry expert or a novice user, mastering the art of manipulating Excel sheets is […]
  • Retrieve All Files in a Directory using Python
    In our digitally driven world, where data processing and management are integral to many industries, the ability to work with Python has become an invaluable skill. This language, particularly in relation to file and directory manipulation, grapples with the rapid growth of data and its intricate handling. With its intuitive […]
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
Copyright All rights reserved