Solved

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

Posted on 2013-06-20
3
663 Views
Last Modified: 2013-06-26
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
Comment
Question by:Kelvin4
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Visio_Guy earned 500 total points
ID: 39265516
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
 

Author Comment

by:Kelvin4
ID: 39265784
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
 

Author Closing Comment

by:Kelvin4
ID: 39277296
Thanks for excellent advice.
Am gathering resources to test in excel and Visio

Kelvin
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (http://www.experts-exchange.com/Microsoft/Applications/M…
The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question