×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

DSOfile X file on server

DSOfile X file on server

DSOfile X file on server

(OP)
I'm now having a "little" problem. DSOfile does not work properly with files on server.

I run the macro locally (w2k SP2 with DSOfile installed) and the server (NT4, DSOfile not installed) as the file saved.

The result is: the file as no properties.

So the macro is mapping correctly the file, but it can't read the properties. If I make a copy of the same file to my local disk, the macro's result is correct (the file as properties after all).

Thanks for the help

RE: DSOfile X file on server

My guess would be that DSOFile.dll does not work on NT4, meaning NT4 doesn't allow the properties...?

If you use the NT4 box and right click on the file, do you get the "Custom" tab when you click "Properties"?

If you don't then either NT4 doesn't do Custom Properties or the OS is making those files Read-Only...

I would try it, but I don't have an NT4 box anymore. I only got 2000 and XP

Let me know



Mr. Pickles

RE: DSOfile X file on server

(OP)
After some tests, I think that DSOfile does not work through a network. I have tried to access, from my computer, to a file in other W2K computer with DSOfile installed and the result is the same: the file is detecetd but the macro is unable to open the doc properties, resulting on a empty output.

RE: DSOfile X file on server

macPT,

Post me your code for "pushing" the properties. I use DSOFile.dll to work with files on our server (through the network) every day.

Or, can you check the file from your code to report if it is "Read-Only"?

Mr. Pickles

RE: DSOfile X file on server

(OP)
DetroitPickles,

I'VE GOT IT!
After your message I was really curious about what I might be doing wrong and I found a simple error (isn't it allways like this?).
My code was something like this:
  ....
  workDir = InputBox("working dir")
  ....
  ChDir (workDir)
  ....
  FichDir = Dir(workDir)
  ....
  Set oDocProp = oFilePropReader.GetDocumentProperties_
  FichDir)
  ....

Then I thought that maybe FichDir needed to have the full path. So, before the Set oDocProp line, I put the following:

  FichDir = workDir & FichDir

And voilá! It's working.

Thanks

RE: DSOfile X file on server

(OP)
Sorry, I've made a typing error. the Set instruction is like that:

Set oDocProp = oFilePropReader.GetDocumentProperties(FichDir)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources