Open existing snapshot file from access

G

Guest

Does anyone have any code on how to open an existing .snp file from an Access
form?

I have a form that will search for certain files within several folders. The
files are are .xls, .doc, or .snp. Once the files are located (which i've
been able to do), I need to allow the user to select one and open it by
clicking a button. I've got the xls and doc files being opened using code
but can't seem to manage the code to open the snp files.

Here is the xls version of code.

ElseIf strExt = "xls" Then
Set appXL = CreateObject("Excel.Application")
Set wrkFile = appXL.Workbooks
wrkFile.Open strFileName

With appXL
.Visible = True
.UserControl = True
.WindowState = xlMaximized
End With



How can I do this with snp files......Can anyone help?

Thanks....
 
S

SA

Pam:

Look up the Shell command in the help file. You'd call

Shell("%PathOfTheSnapShotViewer.exe% PathToTheFile, vbNormalFocus)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top