Solved

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

Posted on 2013-06-20
3
650 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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now