Hi all
I'm a beginner in vba and I admit my lack of culture. On the other hand I really want to try... Brief
I would like to understand how to retrieve one or more custom properties of a solid file for the registered after an excel but I would like to see if this excel is read-only before.... HELP ME ...
Thank you
Hello
I won't be able to help you with the macro, but your need corresponds to a living tool called INTEGRATION of the MyCADtools suite of tools. With this tool you can, among other things, generate reports on files by extracting custom properties.
With this you will save yourself hours of focusing a macro! :-)
Hello
The easiest way to get help with a macro is to post your code (if possible in a TXT file) explaining the goal you want to achieve.
To find out if a file is read-only:
If GetAttr("c:\test.xls") And vbReadOnly Then
MsgBox "File is Read-only"
Else
MsgBox "File is not Read-only"
end if
Oops, I feel like I'm off topic. My proposal does not allow you to write directly to an existing file.
On the other hand, you should be more precise in your request: when do you run this macro, write to yourself in a single file, what do you do if your Excel file is read-only,...
Hello
I don't know if you have the PDM with Solid if yes no need for macro to retrieve custom properties in excel or word.
Gilles