Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 700
  • Last Modified:

Change file extensions and file icons for a specific excel and visio project

In 'projectX', an excel projectX file (.xlsm)  creates specific visio projectX files (.vsd/.vsdm) through vba automation (under Windows-7).

The excel and visio projectX files are therefore distinctive from all other excel and visio files on my PC. I want to give them distinctive and filterable file extensions and distinctive file icons.  

I use VBA, and IcoFX to customise .ico icons for Excel ribbonX buttons. I have no experience in changing the window's 7 registry settings, though am willing to follow simple instructions.

in http://www.howtogeek.com/howto/12383/change-a-file-types-icon-in-windows-7/
I see that a utility: File Types Manager from NirSoft, enables me the do this without changing the Window's 7 registry.

What method would you recommend; are there 'gotchas' I need to know about?

Thanks, Kelvin
0
Kelvin4
Asked:
Kelvin4
  • 2
1 Solution
 
Visio_GuyCommented:
I wonder if you could just use the File Properties to check for your special documents, instead of changing file extensions.

For example, select a Visio file, then type Alt + Enter (or right-click and choose Properties). On the Details tab, you've got fields for Title, Subject, Tags, Categories, Comments, etc.

You can read these properties without actually opening the files, which makes filtering, pre-checking, etc. easier and faster. I'm sure you can set these properties via VBA from within Visio and Excel.

Does that sound interesting?
0
 
Kelvin4Author Commented:
Thanks - your response is an eye-opener.

Chip Pearson has a section which contains code for automating the BuiltIn and Custom document properties.

So my attention moves to the capacity of a customised property to hold information.

- how many text characters can it hold?
- eg: Do people store delimited text files in customised file 'propertyA', so they can read/get it and convert it via Split(PropertyAvalue, ";") into an array from which data can be parsed?

My visio files contain 20-40 drawing items, each with an item code of some 20 characters (as each code contains several bits of info).

If I could store:
- the item codes of drawings in a visio file in the custom file property of that visio file...
If I could acces:
- the path of each Visio file from its file LOCATION property, and the file name, then ...

would I be close to making a catalogue of all my visio items, the visio files that hold them, and their their path locations?

Further:
- if the position of visio files were changed, I could avoid misplacing a drawing - by using the properties above (for files tagged as belonging to projectX) to search for the  lost visio drawing?

That expresses my apparent needs:
Could I suggest you leave me to find the VBA code for the automation, and perhaps use this question to give me some FIRST POINTERS to the potential and limitations of file properties for this type of job?

Many thanks
Kelvin
0
 
Kelvin4Author Commented:
Thanks for excellent advice.
Am gathering resources to test in excel and Visio

Kelvin
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now