automation

How do you place a textbox object over a specific Cell when automating Excel?

We are automating Excel using VB.Net, and trying to place multiple lines of text on an Excel worksheet that we can set to not print. Between these we would have printable reports. We can do this if we add textbox objects, and set the print object setting to false. (If you have another way, please direct me) The code to add a textbox is:...

What is cURL good for ?

What's the single best use you've put cURL to ? ...

How do I copy a file to a remote server in python using scp or ssh?

I have a text file on my local machine that is generated by a python script run daily in cron. I would like to add a bit of code to have that file sent securely to my server over ssh. Help. ...

Is there a way to dynamically load a properties file in NAnt?

I want to load a different properties file based upon one variable. Basically, if doing a dev build use this properties file, if doing a test build use this other properties file, and if doing a production build use yet a third properties file. ...

PHP Deployment to windows/unix servers

We have various php projects developed on windows (xampp) that need to be deployed to a mix of linux/windows servers. We've used capistrano in the past to deploy from windows to the linux servers, but recent changes in architecture and windows servers left the old config not working. The recipe works fine for the linux deployment, but ...

How do you extract macros programmatically from OpenOffice.org Writer document using .NET?

How do you extract the Macro code from an OpenOffice.org Writer document using the .NET API? I got an answer to the "Office 2007" version of this question, but we are evaluating OpenOffice as an alternative -- if anyone has any experience with this, any tips or resources would be appreciated. ...

CScript/WScript Prevent an error from being blocking

Currently, WScript pops up message box when there is a script error. These scripts are called by other processes, and are ran on a server, so there is nobody to dismiss the error box. What I'd like is for the error message to be dumped to STDOUT, and execution to return the calling process. Popping as a MSGBox just hangs the entire thi...

Automated Unit Testing with JavaScript

I'm trying to incorporate some JavaScript unit testing into my automated build process. Currently JSUnit works well with JUnit, but it seems to be abandonware and lacks good support for AJAX, debugging, and timeouts. Has anyone had any luck automating (with ANT) a unit testing library such as YUI test, JQuery's QUnit, or jQUnit (http...

IE Automation Book or Resource?? using MSHTML/ShDocVw VB.Net

Can anyone recommend a book or a website that explains Internet Explorer Automation using VB.NET? I understand that mshtml and ShDocVw.dll can do this, but I need a resource that will explain it to me. I want to read/write values as well as click buttons. The only book I have come across so far is .Net Test Automation Recipes. Is this t...

Best AutoHotKey macros?

Hi, I use AutoHotKey for Windows macros. Most commonly I use it to define hotkeys that start/focus particular apps, and one to send an instant email message into my ToDo list. I also have an emergency one that kills all of my big memory-hogging apps (Outlook, Firefox, etc). So, does anyone have any good AHK macros to share? ...

What's the best automation or scripting tool to automate repetitive tasks with applications?

I realise you can script Microsoft Office apps, but I'm looking for something more general that I can apply to other apps, such as Adobe Acrobat, web browsers and other apps with no scripting ability. I've used AutoIt but it's a bit clunky, especially when trying to debug why a script fails or stalls. Also, getting the timing of actions...

Automate a Ruby Gem install that has input

I am trying to install the ibm_db gem so that I can access DB2 from Ruby. When I try: sudo gem install ibm_db I get the following request for clarification: Select which gem to install for your platform (i486-linux) 1. ibm_db 0.10.0 (ruby) 2. ibm_db 0.10.0 (mswin32) 3. ibm_db 0.9.5 (mswin32) 4. ibm_db 0.9.5 (ruby) 5. Skip this...

Any automated tool for silverlight xap deployment with web services?

Does anyone know of any tools, or even good processes for deploying Web Services and Silverlight applications that rely on those, and have it be able to automatically change the web services url and port nunbers in the config files automatically? right now I am always finding myself having to change the web service config on the server ...

How to create a zip file in the same format as the Finder's "Compress" menu item?

On Mac OS X, you can create a zip archive from the Finder by selecting some files and selecting "Compress" from the contextual menu or the File menu. Unfortunately, the resulting file is not identical to the archive created by the zip command (with the default options). This distinction matters to at least one service operated by Apple...

How do you automate some routine actions for improving productivity?

Every morning, after logging into your machine, you do a variety of routine stuffs. The list can include stuffs like opening/checking your email clients, rss readers, launching visual studio, running some business apps, typing some replies, getting latest version from Source Control, compiling, connecting to a different domain etc. To a ...

Tools for automated GUI testing (on Windows)?

Does anyone have tools to recommend for automated testing of GUI applications on Windows? The tools must be language-independent and thus should be able to interact with any GUI, regardless of implementation language. In other words, I'm looking for something that can be scripted to press buttons, select menu items, check checkboxes, e...

Flash Charts and Graphs exported for use in PDF reports - automation

I want to put beautiful charts in a report that is available via html and pdf. I'd prefer to use just one API and that all processing occur server-side. I want to embed Flash charts in the html version of reports. I want to embed a static image (preferably vector-based format) in the pdf version. What is the best way to accomplish thi...

Automated Test Framework - Windows CE

Hello, Looking for a way to drive a Compact Framework app running on a CE device. All we basically need is to be able to write little scripts that press buttons and click on things. Anyone know of such a tool or it best to just hack one up ourselves? ...

Is there an Application to Create Regular Expression Out of Text by Selecting Wanted Area?

Hey, I hope this is programmer-related question. I'm in the hobby business of C# programming. For my own purposes I need to parse html files and the best idea is..regular expression. As many found out, it's quite time consuming to learn them and thus I'm quite interested if you know about some application that would be able to take inpu...

What do you use to deploy your Web Applications?

We're looking to automate our deployment of Web Applications, particularly when going from local development to a remote server. Our current stack is LAMP remotely, MAMP locally, but I'm interested in general what people are using for this task regardless of their environment? ...