Solved

VBA using ShellExecute to Open a flowchart file

Posted on 2013-11-11
3
424 Views
Last Modified: 2013-11-15
I have a client who uses RRFlow software to create flowcharts. I have an Access application that permits the saving of paths to various file types to be related to specific pieces of equipment, for example.

From within the application I have an On Double-click to permit the user to view associated documents from within the application.

For example:

Equipment ABS

* C:\.....\ABS.doc
* C:\.....\ABS.xls
* C:\.....\ABS.pdf
* C:\.....\ABS.txt

etc...

When the user double-clicks the record my code opens the file in its native application.

I use the ShellExecute funtion and it works great -- however -- I am having a problem with the flowchart file type with an extension of .flo.

Does anyone have any ideas?
0
Comment
Question by:Ei0914
  • 2
3 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 500 total points
ID: 39639582
Also try Application.Hyperlink YourFile.flo

This (either, Ithink) should work -- assuming that you have the default application is set correctly for files with that extension.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39639590
This shows you how to set the default application for a file type in Windows 7.  The exact steps will differ based on your operating system:
http://windows.microsoft.com/en-us/windows7/change-the-program-that-opens-a-type-of-file
0
 

Author Closing Comment

by:Ei0914
ID: 39652178
As always, thanks!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 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

27 Experts available now in Live!

Get 1:1 Help Now