Search results for query: *

I've got a script in QTP which uses vbscript and opens an Access instance (2010 in most instances, but a couple machines are using 2003) then uses opencurrentdatabase to open my database in exclusive mode in order to execute a vba macro. I explicitly have set the default opening mode on the...

Hi, My CI environment uses TeamCity for automatic execution of new builds. It allows for a set of radiators to be created as a display of how the built jobs are running. It's built using a standard output from its external status feed, but from what I can find it should be fairly free to...

I've been known to collect a few pics of these where I see them: Dr Who drives a Merc? Bought by an ex-partner perhaps? For a judge? Or maybe a repeat offender? Not so easy to see - but this taxi cab plate reads T11P ME... A plate in case you weren't sure what the car was? This plate...

For the hardware and 2nd hard disk, go into Control Panels and run the Add Hardware wizard, which should detect and install drivers for your "missing" hardware. If you've created a new profile with the original username, I'm afraid I can't think of any way to retrieve the older one as it will...

Hi, I posted details of a problem in the VBScript forum, and it has occurred to me I might have found more help here - so rather than repost the whole thing (which is attempting to create a chart via VBScript using OWC and setting the chart colours as I see fit), I thought I'd post a link to it...

Suppose nothing comes back from the query... then there would be no objItems in colItems and so the object couldn't be set as there would be no items in colItems - this may cause that error? ^^^Guesswork by the way... Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you...

Hi, I've spent a fair old while hunting for solutions to this - the majority of what I can find appears to be ASP or .NET related and I've done what I can with it, but I seem to have hit an impasse. I have a series of scripts that create pie charts using the Google charts API. However for a...

Friend of mine has asked this: Anyone have any ideas? TIA Dave Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me For all your testing needs: Forum1393

filetxt1.WriteLine( Now & vbTab & Input ) Should do it... Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me For all your testing needs: Forum1393

Thanks PHV, that hint got me onto a solution... Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me For all your testing needs: Forum1393

Hi, I'm performing some automated testing on a Portal application, and have hit a problem with dialog boxes for adding attachments to a note facility within the app. The tool I am using to do the automation is unable to interact with the dialog boxes, and it's too late to start again with...

Can't you use the FileSystemObject to create an instance of a new Excel.Application and tell it to load the file directly? Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me For all your testing needs: Forum1393

The easiest method is to install QTP on the application (target) machine. Then you have a number of options to kick it off remotely - through Quality Centre/TestDirector, or you can write a VBScript that can be used to create a QTP Instance and execute a test. Cheers, Dave "Yes, I'll stop...

Depends on the web app in question - sometimes it's not advisable at all. Can you give further details of what you are automating, and perhaps I could be more specific... Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me...

The object in the recorded script uses whatever heirarchy was assigned to it. For example a dialog under my application's main screen has an OK and a Cancel button. But if I place the objects directly under the application's main screen in the repository then that's what the script uses. But...

Thanks - I'll try that! Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me For all your testing needs: Forum1393

I have a RIGHT JOIN that returns me the correct number of rows. Can I use this within an existing query? The query (and syntax error returned) below select ba.ACCOUNTNUMBER, pp.CATALOGUEPRODUCTID from ccsowner.bsbbillingaccount ba, ccsowner.bsbportfolioproduct pp Where rownum < 1000...

You want QTP essentially to control a remote PC session? Have you tried recording it on the QTP machine and then starting the remote session, and activating the application you want to run? Cheers, Dave "Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the...

If, according to the first error this line is Line 40: Set objUser = GetObject("CN=" & objExcel.Cells(intRow,3 & intRow,2).Value & "," & strDomain) then Line 13 isn't even displayed in the code you've given. Can you identify which line of code you are getting the error in please? Cheers, Dave...

Looking at your code, it seems ok. I have it working just fine with this: 'Option Explicit 'On Error Resume next Dim objNetwork Dim objFso Dim objFolder Dim FromShare Set objFso = CreateObject("Scripting.FileSystemObject") Set objNetwork = CreateObject("Wscript.Network") FromShare =...