automation

QTP for Flash - any recommendations for a useful plugin?

hi I am using QTP and need to test a flash application. I found 3 plugins for this purpose: Adobe's actionscript, Experitest's SeeTest and Riatest. Adobe's was heay duty learning and i gave up...can anyone recommend one otfthe other options? or provide additional options? ...

Excel VBA: automating copying ranges from different workbooks into one final destination sheet?

I'm going to be generating some graphs from a lot of data located in multiple workbooks. The data is formatted exactly the same in all workbooks and reside in folders all at the same level. I'm going to be bringing parts (ranges) of the data into one final workbook where I'll generate my graphs from. This made me think that this sort of...

automatic installation of common magento extensions at project kickoff

There are some Magento Connect extensions that I find myself installing every time I create a new project, such as Fontis_Recaptcha, Mass_Product_Relater, HM_DeveloperToolbar, ModuleCreator, Alanstormdotcom_Layoutviewer, etc. What's on your list? Does anyone know of a capability to automate the installation of a base set of modules? I...

excel automation c#

I am trying to create excel order form which will have price and qty columns and customer will put the values in the qty column and excel will update order cost column. problem i am facing right now is that number of columns in excel file is changing i.e. user can select multiple columns. so price column location is different every time ...

using a PLUG-IN to exisitng testing framework or using FULL FRAMEWORK - which do you recommend?

Say you have a huge automation project and are using a certain testing framework, say -JUnit for most of the automation. However you typically get stuck with automating the flash part of the the application . Now you can usually select several tools for that issue only. on the one hand tehre are tools that are standalone and include all ...

How to determine the session id on remote machine for usage with psexec -i using script/powershell/... ?

Hello, I am in need of a script or powershell command that will be able to determine the session id of a specific logged in user on remote machine, to be later used as parameter to the psexec -i execution of remote gui process on that session of that user on the remote machine. So far i managed to use psexec \\remoteMachine -u user -p...

How can I use an ITypeInfo pointer to get the name of the type?

Should be a simple question, but searching the documentation is driving me nuts. Suppose I have an ITypeInfo pointer for a coclass or an interface. How do I get the name of that class or interface? ...

Matlab GUI Automation?

Lets say someone made a Matlab GUI using GUIDE. Now I want to use that code in a programmatic environment - that is no human-in-the-loop. What's the easiest way for me to "script" the human interactions with the GUI so as to manipulate the various controls in the appropriate sequence to make the tool crunch my numbers and get its results...

How to automate repetitive actions in pdf and Irfan view

I am doing some repetitive actions in pdf (like Document -> Crop Pages -> select top bottom etc and in irfanview (File -> Batch Conversion -> Advanced -> Load Settings etc) Can someone please suggest what is the best way for automating it. (Too boring to do it manually :( ) ...

Excel graphs: how can I update the series for multiple graphs in one go?

I have 5 graphs on a tab refering to Sheet ABC. I am duplicationg the tab with the graphs and then making this new set refer to Sheet DEF. The series ranges are exactly the same, it's just the name of the tab that changes. It's taking a while to go through all the series and replcaing the ABC with DEF. I tried a find and replace and it...

Splitting word file into multiple smaller word files using OLE Automation from java

Hi there, I have been using OLE automation from java to access methods for word. I managed to do the following using the OLE automation: Open word document template file. Mail merge the word document template with a csv datasource file. Save mail merged file to a new word document file. What i need to do now is to be able to open the...

How to know the background color of the ms word document using C#

Hi everybody, I'm using C# office (word) automation by Microsoft Office 12.0 Object Library. And I opened a "1.doc" file and I need to check if this file has a background color or not. Note: I mean the background color applied by the following steps: Open MS Word 2003, and open a document. Go to : Format menu -> Background and choose...

How to programmatically move windows taskbar (take two)

Hello. First of all, i know there is a similarly phrased question in SO, but it hasn't been answered properly, and most of the discussion around it fell unto the "you shouldn't be doing that". So lets start by the basics. Why this is needed. I work on a company that handed out a few dozen tablet netbooks to our workers. As you know, n...

dsofile wrong pagecount

Hi, I am using dsofile.dll to get pagecount from word documents, all I need at this point is pagecount and only Word documents at this time. For some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore I'm in need of a solution or a different approach. Word automation is a last resort as it is considered ...

Running Windows UI automation tasks which are stored in a database

I am storing a list of links to resources such as documents to be opened by Windows applications as well as web pages in a database and need to know how to open them in Windows. For some webpages it will be achieved by passing parameters to a web browser process or executing the document and letting Windows decide what is the best appli...

Good java library for Windows application automation

I am looking for a best way to trigger windows application automation from Java application. So far I have been using Groovy and Scriptom library to access COM native interface. It is rather straight forward approach, but does not scale well (writing configuration for each of application, reading brilliant COM documentations, testing, te...

Reuse existing AutoCAD instance with vbscript

I am using the following vbscript to automate AutoCAD Dim acadObj WScript.Timeout = 30000' set acadObj = GetObject(,"Autocad.Application")' If Err.Number <> 0 Then Set acadObj = CreateObject("Autocad.Application") aCadObj.Documents.Item(0).Close(false) End If acadObj.Visible = true Err.Clear() What it should do i...

HOw do I suppress the VIsual Basic "Macros are Disabled" Dialog that shows when opening a word doc in C#

I have a really annoying problem. I am openign a word document via c# / COM Interop (Word 2007). I want to prevent the Macros from Running as some of them may crash (older files with missing bookmarks etc.). So I run the following code to suppress all the dialogs that may pop up: Word.ApplicationClass wordApplication = new Word.Appli...

Excel Macro: is it possible to find Row heights and Column widths of a worksheet?

Is there any way of finding the height of the ROWS from 1 to 50, and the width of the COLUMNS from A to Z in an Excel sheet without manually clicking and writing down the answer? Thanks Michael. ...

Best approach for passing passwords to command line applications

What do you thing it will be the optimal method of passing passwords to different applications. Giving the password as a command line argument is not acceptable because this will be visible in logs - especially in an automation system. At this moment I'm considering two possibilities: providing the password in a file or temporary setti...