file properties

  1. E

    Make file properties visible on an encrypted xlsb document

    I have an encrypted xlsb file that I would like to allow file properties to be visible when the file is closed. My IT department would like to use the "Comments" value to store a value that can be read by other systems without opening the file. I tried running the code shown below which I...
  2. M

    VBA List Files in Folder with Author & Last Saved by Properties

    Help Pretty please.;) My brain hurts and I still can't get the right code.:confused: :mad: I need VBA to return file author and last saved by. Here is the current code: Option Explicit 'the first row with data Const ROW_FIRST As Integer = 2, TFNameCol As Integer = 9, TFCountCol As Integer =...
  3. K

    Set File Property of File With Password

    Hi, I have an Excel Tool that opens several spreadsheets in several folders and adds comments in the file's properties (looping via InputWB.BuiltinDocumentProperties.Item ("Comments")). The problem is, whenever I encounter files with Password To Open or Password To Modify. Right now, I...
  4. W

    Viewing hidden files

    I'm distributing a number of USB devices containing a lot of files and reports which people require regular access to, basically to save printing so much out and havign all the information to hand on such a small object. The USB device will autorun and show a html file which develops into an...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top