Skip to content
Primary Menu
  • Officetricks.Com
  • Blog
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Excel
  • Social Media
File Operations Tricks
  • VBA to Delete File in a Folder
  • Excel VBA Rename File – Without opening the File – 2 Easy Ways
  • VBA – Find My Documents, Desktop & System Folder Path
  • Excel VBA Delete Folder if Exists
  • How to Convert Docx to PDF – VBA Save Word as PDF
  • Excel VBA Get File Extension – 2 Simple Methods
  • Excel vba Add Date Time Stamp to File Name
  • How to Zip File or Folder using VBA Code – Excel Macro?
  • Add Time Stamp to Notepad Text File
  • Excel VBA List Files in Folder – Dir in Shell
  • Removing Empty Folder is Now Easy – Get Folder List with Size
  • PHP Check If File Exists in a Folder path – in 2 Easy ways
  • How to Zip Directory using Python? – Archive folder
  • Is Excel File already open in VBA – By Another User
  • Excel Vba Save a Copy of Workbook with TimeStamp
Data Type Tricks
  • VBA Array Initialize Values – Split string to array
  • VBA – Create Array from Excel Range – 1 Dimension
  • LET( ) Function in Excel
  • Excel VBA – Loop thru all Keys & Items in Dictionary
  • Excel VBA – Convert Range To Array – 2 Dimentional
Excel VBA Macro Tricks
  • How to get Computer MAC Address using Excel VBA?
  • Excel VBA – Folder Operation – Exists, Create, Copy, Delete Directory
  • Safe Password Manager – Secure All Your Passwords
  • VCF to Excel Converter – Best Apps – 4 Easy Methods
  • How to Delete Blank Rows in Excel – Remove Empty Rows – 3 Easy Tips
File Operations Data Type Excel VBA Macro

VBA to Change File Encoding ANSI to UTF8 – Text to Unicode

August 20, 2025
Kumarapush

Get VBA code to convert .Txt ANSI encoding to UTF8 Unicode format. ALso learn how to do UTF convertion using built in function in text editors.

Windows System Control

How to hide icons in desktop in Windows 10?

August 20, 2025
Kumarapush

Learn how to hide desktop icons in Windows 10 during a screen presentation or recording for a office meeting or live demo etc.,

Windows System Control

Free Windows 10 to Windows 11 Upgrade – Preview version

August 20, 2025
Kumarapush

Learn how to upgrade Windows 10 to Windows 11 using these simple steps and by opting in to Insider program. This is the safest method to upgrade your windows PC

Windows System Control Weather

Windows 10 Remove Weather from Taskbar

August 20, 2025
Kumarapush

In Windows 10 weather forecast widget in taskbar is available by default. Learn how to remove weather from taskbar in Windows 10 using these steps.

Android Android SmartPhone Whatsapp

Bluestacks Whatsapp – Android Emulator – Easy Download

August 20, 2025
Kumarapush
0

Get download link for Bluestacks whatsapp – a Android emulator for windows PC. Using this app, you will be able to test your APK file.

Windows System Control

Turn on Windows 10 Taskbar Search Box – Quick Shortcut

August 20, 2025
Kumarapush

Learn how to enable a Taskbar search box in Windows 10 using simple option. This searchbox or icon will reduce loads of work for you.

Cmd Prompt Login Accounts/Username System Control

How to Find Current Username – in DOS, Linux & Mac OS?

August 20, 2025
Kumarapush

CLI – Command line function to find the current logged in active username in DOS, Linux & MacOS. The same functions or command works in all these different operating systems

Excel VBA Macro Excel

How to open VBA in Excel – Macro code editor?

August 20, 2025
Kumarapush

Learn how to open VBA code in Excel. Get different options to open Excel macro code as per steps explained in this article.

Excel

Get Sheet Object Caption and Codename

August 20, 2025
Kumarapush

Get Excel worksheet caption & name (or Object name or Codename) using VBA Macro. This is a readonly property and cannot be renamed using code without giving access to VBA Project Model.

Python

Convert Python to Exe – Easy Compile in 2 Mins

August 20, 2025
Kumarapush

Convert Python to Exe file using this compiler module with these simple steps. It takes roughly 2 mins to compile a Py to Exe with PyInstaller

Posts pagination

Previous 1 … 4 5 6 … 50 Next

The news you may have missed

January 3, 2023

Excel VBA For each cell in Range – Direct method

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

November 16, 2021

VBA Combo box Add Items – from Excel Range or Array

  • 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