Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Automation (RSS)

Browse by Tags

  • Giving IE the Focus

    Ginger comments: The only thing I can’t do is to get XL to open the existing IE window so I can ’sendkeys’ to do that part. I can only see similar posts for “create.object” related to IE, and nothing for “get.object” (or whatever will work). According to XtremeVBTalk, GetObject doesn't work with IE and you have to [...] Read More...
    Filed under:

  • Printing First Page of Email in Outlook

    I print out my email. No, I'm not one of the Luddites that prints out every email (or has his secretary do it) because he doesn't understand how to work his email machine. My system for organization is loosely based on Getting Things Done and its derivative 43 Folders. Everything I have [...] Read More...
    Filed under:

  • Copy Paste to External Application

    Sometimes I find myself copy-pasting between Excel and another application. In this example, I have a table of three columns: First Name, Last Name, Birth Date. My external application has 3 text boxes, one for each of those values. I can't just copy the 3 cells from Excel and paste them to my App, because they would all [...] Read More...
    Filed under: ,

  • CommandButtons via Visual Basic 6.0

    From Ashton. When I run this code in a VB6 program, it puts an OLEObject on an Excel sheet. Private Sub Command1_Click()         Dim xlApp As Excel.Application         Set xlApp = Excel.Application     xlApp.Visible = True     xlApp.Workbooks.Add         xlApp.ActiveSheet.OLEObjects.Add "Forms.Commandbutton.1"         Set xlApp = Nothing     [...] Read More...
    Filed under:
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.