Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sum Based On Criteriya 7 19
Excel file not created as expected 7 46
Question to the line 4 39
Excel Copy Macro down foe each row 4 18
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

919 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

16 Experts available now in Live!

Get 1:1 Help Now