When i add a reference to Office COM Library, i to go: References Add Reference Select the COM tab Select Microsoft Office 12.0 Object Library And magically named reference appears: Microsoft.Office.Core The Project.csproj file shows the details of the reference: <COMReference Include="Microsoft.Office.Core"> <Guid>{2DF8D04...
How can I automatically execute an Excel macro each time a value in a particular cell changes? Right now, my working code is: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("H5")) Is Nothing Then Macro End Sub where "H5" is the particular cell being monitored and Macro is the name of the macro....
I was thinking of writing a PHP script that would analyse a CMS'd page's content (i.e. database field) and then auto-generate (X)HTML META description & keyword tags, but as always there's no point reinventing the wheel so I'm wondering if anyone knows of such a beastie? The former I imagine would be something like a relatively straight...
The web shop where I work we do both .Net and PHP/Linux development. We'd like to start automating a lot more of our deployment processes using a common system that can be used for both. What would you recommend as a good common scripting language or automation system (like Ant or Maven) that works well for both .Net and Linux developmen...
I'm using SSIS with SQL Server 2k5 to build a transfer task to copy all of the data from one database to another. This works quite well, except for one problem - the source database will periodically have schema changes (generally just additions like new columns) but the transfer task seems to choke if the two schemas don't match exactly...
Currently I have a bookmarked list of websites that I look for content on, and open them in a new window, in tabs, and search for the string that I want to find. Is there any way to do this programatically, ending up with a browser window containing the results pages of the sites? There's around 20 of them. I'm running Safari 3 on Mac ...
Background Dear friends, I am required to create a java program on a laptop to receive/send CANopen messages. RJ45 is chosen to be the network's physical medium. I am new to CANopen and Java communications programming. Pardon me if I appear to be uninitiated. The truth is, I have been reading up a lot but I still do not know how to get ...
I have being toying with the idea of creating software “Robots” to help on different areas of the development process, repetitive task, automatable task, etc. I have quite a few ideas where to begin. My problem is that I work mostly alone, as a freelancer, and work tends to pill up, and I don’t like to extend or “blow” deadline dates. I ...
Hi, does anyone know how to return a value from a (sql) database into an MSBuild script? I want to get the value into a property so I can pass it to subsequent build tasks. I am fiddling round with something like the following at the moment, but this is returning -1 to indicate the query has executed successfully, whereas what I want is...
Here's what I have: Quarter Sheet Flyer (4 per page) as a PSD or JPG Text file with one entry of text per line. What I want to do: Print out 100 flyers (on 25 pieces of paper) Somehow automate the process of adding the text to the image, either via some scripting language or a Photoshop automated task. Then format the pages to ...
Anyway of invoking the Edit > Advanced > Format Document" VS command automatically when switching away from a document / routinely with a timer / on entering a document? Its really irritating Ctrl+E+D'ing everytime you want to prettify your code. ...
Hello! How is it possible to open FireFox browser by Ruby(for automation script)? I use @browser = RSpecSeleniumHelper.connect_browser('/admin/', '*firefox'), but it doesn't work. ...
In the near future i will get some 2 weeks for moving and improving our development environment at work. We mainly develop one large PHP/MySQL project with 2-10 developers. At the moment we have one dev server, running apache with mod_userdir, each dev has a /public_html folder in his (samba-accessible) home. For VCS and Project Manage...
I am trying to do an automated xml export from an access database using C# and OLE. Everything is working perfectly except that the startup form is shown and won't close without user intervention. Here's what I am doing so far: objAccess = CreateObject("Access.Application"); objAccess.OpenCurrentDatabase("C:\\MYDB.mdb", true); //true ...
What tools are free tools are available for testing WebServices that are behind NTLM2 authentication. SoapUI Is Excellent tool with all functionality that I need, however, it doesn't support NTLMv2. If someone has a way of making that work, please provide solution. ...
This is my problem. I have a program that has to run in a TTY, cygwin provides this TTY. When I redirect stdIn the program fails because it does not have a TTY. I cannot modify this program, and need some way of automating it. How can I grab the cmd.exe window and send it data and make it think the user is typing it? I'm using C#, I ...
Hi i want to test my datagridview validation with the windows.automation. the problem is i dont know how i can do this can someone give me a hand with this? ...
I use Excel via COM automation (in c#), but it seems that the problem has no control over what version of excel is started on the box - we use both Excel 9 and Excel 11 and one specific set of spreadsheets requires excel 9 else they wont work. I included the excel 9 com references but on another persons machine excel 11 started. How can...
Hello, Does anyone know of a way i can extract all jpg images from a pdf file? I am currently using Acrobat and i have a file that contains about 1500 photos that i need to extract but doing them one at a time would be much too time consuming. Any ideas? Thanks. ...
We're currently doing some Word automation, and want to be able to insert a Style Separator into a Range object. We've found how to do it with the Selection object (InsertStyleSeparator) but can't seem to figure out how to do that with Range objects. Does anyone know how to make that work? Relevant links I've found so far: Style Separ...