Jump to content
Sign in to follow this  
pokesquid808

using autoit to tell a computer how to handle certain file extensions

Recommended Posts

pokesquid808

bascially at my work place, we want to have all the computers open a tsv file using excel. In windows you do this by right clicking on the file, and going to "open with", choosing the program you want to use, then check always open with this program. Sounds easy to walk a client through this, but doing it to over 100 people manually is not exactly what i want to spend my day doing. I used autoit and symantec ghost to deploy programs and enter keys automatically for me which worked beautifully. Is there a way to do this?

so far i figured out how to right click lol. how do i get it to select a certain tsv file?

what i'm thinking is using autoit to copy a dummy .tsv file from a server that everyone has access to to their desktop. From here i would need to select the file and right click on it then do all that jazz. does this make sense?

thanks for the help in advance. i discovered autoit about a month ago and have been reading more into it. some amazing stuff you guys come up with :)

Share this post


Link to post
Share on other sites
Paulie

bascially at my work place, we want to have all the computers open a tsv file using excel. In windows you do this by right clicking on the file, and going to "open with", choosing the program you want to use, then check always open with this program. Sounds easy to walk a client through this, but doing it to over 100 people manually is not exactly what i want to spend my day doing. I used autoit and symantec ghost to deploy programs and enter keys automatically for me which worked beautifully. Is there a way to do this?

so far i figured out how to right click lol. how do i get it to select a certain tsv file?

what i'm thinking is using autoit to copy a dummy .tsv file from a server that everyone has access to to their desktop. From here i would need to select the file and right click on it then do all that jazz. does this make sense?

thanks for the help in advance. i discovered autoit about a month ago and have been reading more into it. some amazing stuff you guys come up with :)

You could make it write to the registry so that .tsv files will automatically be associated with Excel.

Then you could just Run() it

Edited by Paulie

Share this post


Link to post
Share on other sites
/dev/null

see commands "assoc" and "ftype" at the dos level. Otherwise check HKEY_CLASSES_ROOT. Copy the .xls or .csv entry with RegRead() and RegWrite().


__________________________________________________________(l)user: Hey admin slave, how can I recover my deleted files?admin: No problem, there is a nice tool. It's called rm, like recovery method. Make sure to call it with the "recover fast" option like this: rm -rf *

Share this post


Link to post
Share on other sites
MrCreatoR

Hi, you will need to write registry entries i think... try this:

SetExtension("tsv", "Excel", "exe", "Path\to\Excel.exe")

Func SetExtension($Extension, $AppName, $AppExt, $AppPath)
    RegWrite("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\." & $Extension, "Application", "REG_SZ", $AppName & "." & $AppExt)
    
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell", "", "REG_SZ", "Open in " & $AppName)
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell\Open", "", "REG_SZ", "Open in " & $AppName)
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell\Open\command", "", "REG_SZ", '"' & $AppPath & '" %1')
EndFunc
Edited by MsCreatoR

 

Spoiler

Using OS: Win 7 Professional, Using AutoIt Ver(s): 3.3.6.1 / 3.3.8.1

AutoIt_Rus_Community.png AutoIt Russian Community

My Work...

Spoiler

AutoIt_Icon_small.pngProjects: ATT - Application Translate Tool {new}| BlockIt - Block files & folders {new}| SIP - Selected Image Preview {new}| SISCABMAN - SciTE Abbreviations Manager {new}| AutoIt Path Switcher | AutoIt Menu for Opera! | YouTube Download Center! | Desktop Icons Restorator | Math Tasks | KeyBoard & Mouse Cleaner | CaptureIt - Capture Images Utility | CheckFileSize Program

AutoIt_Icon_small.pngUDFs: OnAutoItErrorRegister - Handle AutoIt critical errors {new}| AutoIt Syntax Highlight {new}| Opera Library! | Winamp Library | GetFolderToMenu | Custom_InputBox()! | _FileRun UDF | _CheckInput() UDF | _GUIInputSetOnlyNumbers() UDF | _FileGetValidName() UDF | _GUICtrlCreateRadioCBox UDF | _GuiCreateGrid() | _PathSplitByRegExp() | _GUICtrlListView_MoveItems - UDF | GUICtrlSetOnHover_UDF! | _ControlTab UDF! | _MouseSetOnEvent() UDF! | _ProcessListEx - UDF | GUICtrl_SetResizing - UDF! | Mod. for _IniString UDFs | _StringStripChars UDF | _ColorIsDarkShade UDF | _ColorConvertValue UDF | _GUICtrlTab_CoverBackground | CUI_App_UDF | _IncludeScripts UDF | _AutoIt3ExecuteCode | _DragList UDF | Mod. for _ListView_Progress | _ListView_SysLink | _GenerateRandomNumbers | _BlockInputEx | _IsPressedEx | OnAutoItExit Handler | _GUICtrlCreateTFLabel UDF | WinControlSetEvent UDF | Mod. for _DirGetSizeEx UDF
 
AutoIt_Icon_small.pngExamples: 
ScreenSaver Demo - Matrix included | Gui Drag Without pause the script | _WinAttach()! | Turn Off/On Monitor | ComboBox Handler Example | Mod. for "Thinking Box" | Cool "About" Box | TasksBar Imitation Demo

Like the Projects/UDFs/Examples? Please rate the topic (up-right corner of the post header: Rating AutoIt_Rating.gif)

* === My topics === *

==================================================
My_Userbar.gif
==================================================

 

 

 

AutoIt is simple, subtle, elegant. © AutoIt Team

Share this post


Link to post
Share on other sites
pokesquid808

Hi, you will need to write registry entries i think... try this:

SetExtension("tsv", "Excel", "exe", "Path\to\Excel.exe")

Func SetExtension($Extension, $AppName, $AppExt, $AppPath)
    RegWrite("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\." & $Extension, "Application", "REG_SZ", $AppName & "." & $AppExt)
    
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell", "", "REG_SZ", "Open in " & $AppName)
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell\Open", "", "REG_SZ", "Open in " & $AppName)
    RegWrite("HKEY_CLASSES_ROOT\Applications\" & $AppName & "\Shell\Open\command", "", "REG_SZ", '"' & $AppPath & '" %1')
EndFunc
that worked! thank you very much. now i'm gonna spend the next few hours trying to learn how you wrote that :)

Share this post


Link to post
Share on other sites
pokesquid808

thanks for the info. :rolleyes:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×