Jump to content

VBScript logic to AutoIt - Please Help


Recommended Posts

Hi Guys,

I have written a code in VB Script, but i wanted to use AutoIt to deliver my project. Please help me,
I have a folder which contains, few *.txt, *.xml files.
My requirement is:
1. To get the Parent Folder Path. (e.g. C:temp)
2. After Getting the Parent folder, i want to get the Path of the .txt and .xml files present in the Parent Folder (e.g. C:tempSample.txt)

 
I can do this in VBScript using objWMIService.ExecQuery

Can we do the same in AutoIt, am new to AutoIt... Please Help.

My VBScript for doing the above requirement.

'***************GET PARENT FOLDER PATH *******************
If fso.FileExists(WScript.Arguments(0)) Then
Set objFile = fso.GetFile(WScript.Arguments(0))
ReqFolder = objfile.ParentFolder
End If
'***************GET PARENT FOLDER PATH *******************

strComputer = "."

Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!" & strComputer & "rootcimv2")
    
Set FileList = objWMIService.ExecQuery ("ASSOCIATORS OF {Win32_Directory.Name=" & "'" & ReqFolder & "'" & "} where ResultClass = CIM_DataFile")
For Each objFile In FileList

 

 '******************Looking for TXT file ***************************
      If objFile.Extension = "txt" Then
        txtname = objFile.Drive & objFile.Path & objFile.FileName & "." & "TXT"
      End If
 '******************Looking for TXT file ***************************

Please help me with AutoIt for above requirement.

 

Cheers,

Mohan

Link to comment
Share on other sites

_FileListToArray

If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Link to comment
Share on other sites

Allow me to expand on BrewMan's response.  A UDF included with AutoIt will allow you to find files in a given directory.  Check out the _FileListToArray function.

To answer your question, yes you can easily convert the VBS code you provided to work in AutoIt.  Do a search on the forum for convert VBS to AU3 for a lot of examples, but I would recommend using the UDF above as it would be (potentially) significantly faster.

 

edit: just another note.  The vbs could also use a more efficient method (FileSystemObject) than using WMI (especially if only the local machine is being searched); but that's another lesson.  ;)

Edited by spudw2k
Link to comment
Share on other sites

Welcome mohan93 - If you get stuck at any point, with AutoIt coding, then provide that AutoIt code here, and you should get plenty of help to continue to your goal.

Make sure brain is in gear before opening mouth!
Remember, what is not said, can be just as important as what is said.

Spoiler

What is the Secret Key? Life is like a Donut

If I put effort into communication, I expect you to read properly & fully, or just not comment.
Ignoring those who try to divert conversation with irrelevancies.
If I'm intent on insulting you or being rude, I will be obvious, not ambiguous about it.
I'm only big and bad, to those who have an over-active imagination.

I may have the Artistic Liesense ;) to disagree with you. TheSaint's Toolbox (be advised many downloads are not working due to ISP screwup with my storage)

userbar.png

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...