application objects

Dear all, I am an advanced VBA user as far as using it on the default Microsoft office applications is concerned. But currently I am writing a macro where it would be very beneficial to know how to control third party applications from VBA. Up till now I was quite successful using the Sendkeys...

I use an API, run in excel, that returns: Parent window handles, classes and text. for ANY excel, non-Excel/non-office app. 'source: http://www.markrowlinson.co.uk/articles.php?id=4 The handle (HWND), 'text' and 'class' variables enable the identification of each Application window...

Hi, got my code all set up but require a dynamic shell function when calling notepad. Currently it is as below (which works fine): Call Shell("notepad C:\Users\Shudarstaran.Neel\Desktop\DummyTest.xml", vbNormalFocus) I would like it to be dynamic and work like below...

Hi all, Quite new to VBA but would be very grateful if someone could help me with the below. I can't figure out the code I need in order to go into a text file, remove lines 10, 11,12, 13 & 14 in the text file. I've seen threads with the find and replace in a text file but cant use these as...

<tbody> Hi, I am developing a VBA for Excel application which uses transient worksheets to collect data from users before writing the data back to master spreadsheets. My application opens an instance of excel with a workbook and worksheet using the following code: Dim xlsInstance As Object...

Can one access a spreadsheet created by an internet export, from within an existing Excel spreadsheet, without first "touching" the newly created spreadsheet? By way of explanation: I am running Excel 2007 under Windows 7. I have an Excel spreadsheet in which I collect weather data as a...