application objects

  1. L

    How to use VBA to detect and click "buttons" in third party applications?

    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...
  2. R

    Given the HWND values for several application windows, how to use vba to return each window as an object?

    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...
  3. S

    Dynamic Shell Function

    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...
  4. S

    VBA for Editing Text File

    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...
  5. N

    Override methods in transient worksheet

    <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...
  6. D

    Can one access independent Application objects by macro?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top