View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RST RST is offline
external usenet poster
 
Posts: 6
Default Revision Number for an Add-In

I am trying to reference the Revision Number of an Excel Add-In using VBA to
determine if the user has the latest version of the Add-In installed. I
figured the best way would be to use a Scripting.FileSystemObject to get to
it, but I'm having a little trouble. Here's what I have:

Dim fs, f
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(vPath & "\AddIn.xla")

I've tried several different ways to get to the Revision number...such as:
vRevNo = f.RevisionNumber

But that didn't seem to work. Does anyone know how to tap into this field
easily? Thanks.