[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

VBA using ShellExecute to Open a flowchart file

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
Eileen Murphy
Asked:
Eileen Murphy
  • 2
2 Solutions
 
mbizupCommented:
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
 
mbizupCommented:
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
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
As always, thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now