-
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...
-
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 [......
-
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...
-
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...
-
If you create regular Word reports from Excel, how would you like to be able to produce each report with just one click, instead of manually copying and pasting all the tables and charts from Excel to Word? I've written an Excel utility to do this automatically. The principle is quite simple - the...