Solved

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

Posted on 2013-06-20
3
681 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
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 …

630 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