JohnApr 113 minWorking with files and folders in VBAWorking with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler
JohnNov 9, 20233 minGet extended properties for a fileIt'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?
JohnSep 22, 20231 minAddIn AssistantNeed help with installing an AddIn in Excel, Word, PowerPoint or Outlook? Get the AddIn Assistant!
JohnAug 10, 20224 minLet the user choose a single fileA 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,...
JohnMar 4, 20229 minInstalling and updating Add-insInstalling and updating an Add-in for an Office application is not difficult. Honest, it's not. But the right steps have to be performed...
JohnFeb 22, 20221 minJoin two parts of a file or folder pathNOTE: this post and the code it contains is still valid, however, it has been superseded by the 'Working with files and folders in VBA'...