top of page
Blog posts
Search
The ":Zone.Identifier:$DATA" alternate data stream (ADS)
The ":Zone.Identifier:$DATA" alternate data stream (ADS) ... unblocking files that have the "Mark of the web"
Mar 43 min read
Â
Â


Reading, writing and deleting alternate data streams (ADS)
How to read, write and delete the alternate data streams (ADS) for a file or folder using VBA code?
Mar 33 min read
Â
Â


Getting the alternate data streams (ADS) for a file or folder
How to get a list of the alternate data streams (ADS) for a file or folder using VBA code?
Mar 23 min read
Â
Â


Setting file / folder attributes
Setting file / folder attributes using the SetFileAttributes Windows API Function
Jan 82 min read
Â
Â


Getting file / folder attributes
Getting file / folder attributes using the GetFileAttributes Windows API Function
Jan 72 min read
Â
Â


Dynamically loading a DLL "on-the-fly"
Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.
Oct 2, 202410 min read
Â
Â


Working with files and folders in VBA
Working with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler
Apr 11, 20244 min read
Â
Â


Get extended properties for a file
It's fairly straight-forward to get the basic properties for a file, but how do you get the extended properties for a file with VBA?
Nov 9, 20233 min read
Â
Â


AddIn Assistant
Need help with installing an AddIn in Excel, Word, PowerPoint or Outlook? Get the AddIn Assistant!
Sep 22, 20231 min read
Â
Â


Let the user choose a single file
A common requirement for VBA macros is to let the user choose a file, often the file will have some data that the macro is to work with,...
Aug 10, 20224 min read
Â
Â


Articles: Blog2
bottom of page