Open Any File

[JoneZ]

I am a newbie. But i am sure this must be possible...

Can i get autoit to open any file i like without saying what program needs to open it?

When you click on a file you dont have to know what program should open it. The OS already knows because the file type has been assigned to that application.

I know that the following works.

$LocationAndApplication2OpenWithEXE = "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
$ItemLocationAndNameToOpen=@WorkingDir &"\FFT\school_FFT_DB_SCH.mdb"
Run('"' & $LocationAndApplication2OpenWithEXE & '" "' & $ItemLocationAndNameToOpen & '"')

Or the very simple example in the help file

Run("Notepad.exe", "", @SW_MAXIMIZE)

.. But is there a way not to say the program and just specify the file?

I want to open word, access and excel files. But if the autoit is run on a machine with a different version of office i'd have to code all the locations of the various versions of office.

Is there a way to solve this

Thanks in advance

[/dev/null]

.. But is there a way not to say the program and just specify the file?

I want to open word, access and excel files. But if the autoit is run on a machine with a different version of office i'd have to code all the locations of the various versions of office.

Is there a way to solve this

Try this:

Run(@ComSpec & ' /c start ' & $filename, '', @SW_HIDE)

start knows most of the file associations.

Cheers

Kurt

Edited August 2, 2006 by /dev/null

[Don N]

You could search for the excel/access/word exe's on the local computer. Then enter

<exe> <filename> at the command prompt

This method will only require you to know the name of the executables which should be standard.

[BigDod]

#include <Process.au3>
_RunDos("start d:\autoit\smurf.tif")

[JoneZ]

Thanks for your help.

It works fine for text files. But i'm now trying to open an access database. And nothing happens. No error or anything.

I've tried both

$filename = @WorkingDir &"\FFT\database.mdb"
Run(@ComSpec & ' /c start ' & $filename, '', @SW_HIDE)

And...

_RunDos("start H:\Autoit\FFT\database.mdb")

Any ideas?

Thanks for the help so far

[nfwu]

$filename = @ScriptDir &"\FFT\database.mdb"
$CodeName = RegRead("HKEY_CLASSES_ROOT\.mdb", "")
$thingtorun = RegRead("HKEY_CLASSES_ROOT\"&$CodeName&"\shell\Open\command", "")
$thingtorun = StringReplace($thingtorun, "%1", $filename)
Run($thingtorun)

#)

[/dev/null]

It works fine for text files. But i'm now trying to open an access database. And nothing happens. No error or anything.

Any ideas?

Three things:

1.) is M$ Access installed on your system?

2.) what happens if you double click a *.mdb file?

3.) what happens if you run the start command manually?

Cheers

Kurt

[nfwu]

Another thing.

I noticed that you are using @WorkingDir. Did you mean @ScriptDir?

#)

[JoneZ]

Thanks for that i'll give it a try.

Just looked in the help file and yes @ScriptDir is what i need to use.

Thanks for picking up on that

Cheers

Jonez

[JoneZ]

Three things:

1.) is M$ Access installed on your system?

2.) what happens if you double click a *.mdb file?

3.) what happens if you run the start command manually?

Cheers

Kurt

1) Yes of course. I'm lame at Autoit but i'm not that lame

2) If i double click a *.mdb file it open in Access

3) If you mean do a Start> Run > Type the path to the file and click ok. Then that opens the file in Access too.

Cheers

Jonez

[JoneZ]

$filename = @ScriptDir &"\FFT\database.mdb"
$CodeName = RegRead("HKEY_CLASSES_ROOT\.mdb", "")
$thingtorun = RegRead("HKEY_CLASSES_ROOT\"&$CodeName&"\shell\Open\command", "")
$thingtorun = StringReplace($thingtorun, "%1", $filename)
Run($thingtorun)

#)

Coool! That opens the file! Thanks for that.

Any ideas why my other code doesnt work?

I was trying to do it as simply as possible and that works fine for text files and even word *.doc files.

Cheers

[JoneZ]

$filename = @ScriptDir &"\FFT\database.mdb"
$CodeName = RegRead("HKEY_CLASSES_ROOT\.mdb", "")
$thingtorun = RegRead("HKEY_CLASSES_ROOT\"&$CodeName&"\shell\Open\command", "")
$thingtorun = StringReplace($thingtorun, "%1", $filename)
Run($thingtorun)

#)

As i said that works fine for *.mdb files.

If i wanted to open a word document would i just do.

$filename = @ScriptDir &"\FFT\document.doc"
$CodeName = RegRead("HKEY_CLASSES_ROOT\.doc", "")
$thingtorun = RegRead("HKEY_CLASSES_ROOT\"&$CodeName&"\shell\Open\command", "")
$thingtorun = StringReplace($thingtorun, "%1", $filename)
Run($thingtorun)

This opens Word but the file doesnt open at all.

Cheers for the help

[/dev/null]

1) Yes of course. I'm lame at Autoit but i'm not that lame

well, we do have some really "strange" people on this forum. I thought it's better to eliminate the obvious problems first

2) If i double click a *.mdb file it open in Access

What's the output of:

assoc | find "mdb"

and

ftype | find "access"

3) If you mean do a Start> Run > Type the path to the file and click ok. Then that opens the file in Access too.

Actually no. Start > Run > cmd.exe and then "start H:\Autoit\FFT\database.mdb".

Cheers

Kurt

Edited August 7, 2006 by /dev/null

[nfwu]

Try this:

Func _OpenFile($extention, $file)
   $CodeName = RegRead("HKEY_CLASSES_ROOT\"&$extention, "")
   $thingtorun = RegRead("HKEY_CLASSES_ROOT\"&$CodeName&"\shell\Open\command", "")
   $thingtorun = StringReplace($thingtorun, "%1", $file)
   If Not @extended Then $thingtorun = $thingtorun & " " & $file
   Run($thingtorun)
EndFunc

May fail on certain types of files, as I only taken into account one of the ways inwhich assosiations are stored.

_OpenFile(".doc", @ScriptDir &"\FFT\document.doc")

#)