Search:
Type: Posts; User: tahi.laci
Search:
Search took 0.02 seconds.
-
I would like to make a program which solves for an unknown in an equation, which seems easy to do on paper, but I have no idea how to make the computer do it.
Here's an example: I start with a...
-
I've just realised that I got type mismatch because i used both " and # now it's ok. Although it assumes the date is in American format when I put it this way:
SetDTPTime chld, #9/7/2013#i.e. in...
-
I'm don't get it. Could you upload a workbook which you have already set up this way?
-
I can use this code to disable printing on a macro eanabled workbook:
Private Sub workbook_BeforePrint(Cancel As Boolean)
Cancel = True
MsgBox "You cannot print this workbook"
End Sub
...
-
I got type mismatch after putting "#".
I may have done it incorrectly, but changing LT to ST didn't work for me. In excel 0 = 00/01/1900, and I know in some systems 0 = 30/12/1899. Assuming mine...
-
I'm sorry I didn't read your post properly. When I looked at DTM_SETSYSTEMTIME I assumed it only changes the system time. Since then I tried and it worked, without the reliability issues associated...
-
Changing system time doesn't work this time as this program doesn't get it's date from windows. The handle is "ctrl1". This one didn't work:
Call SendMessage(ctrl1, WM_SETTEXT, 0&, "01/01/2010")...
-
I have an external app which is not a Microsoft product and I want to automate using it. I've already used sendmesage successfully to control various UI elements, like this one for pressing a button ...
-
You may be right about bringing it to the top. About not finding the handle I was not completely clear. Knowing the handle of the main window is enough for simulating mouse click with mouse_event (I...
-
I've been doing a lot of automation lately. In some cases I can't avoid using simulated mouse clicks. Unfortunately at my workplace there are programs which randomly pop up to steal the focus and...
-
Thanks for the info. I'll just continue with what I've been doing so far. I believe that being able to send controls to other applications is useful anyway.
-
Select menubar item with sendmessage
Assuming you have a "New text document.txt" open this program will choose the "File" -> "Save As" menu. Please note: Instead of giving the name of the menu you...
-
I suspect that this program was made in VB because there are ThunderRT6 classnames in it. Eg.: instead of Class: Button, it has Class: ThunderRT6CommandButton. Once it has also returned an error...
-
Thanks for mentioning that. I usually just search these declarations on the internet and I never really go through them. If the incorrect declaration ever caused a problem I'd never find it. I...
-
Enumerate windows
Only use it on an empty worksheet. It gives you classnames, windowtitles, subwindows and handles in a format where the hierarchy is clear. I know spy++ can do this and more, but...
-
Write into notepad
Note: in theory this works with other editable fields like textboxes for passwords.
Option Explicit
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA"...
-
Close window
Option Explicit
Private Declare Function PostMessage Lib "user32" _
Alias "PostMessageA" (ByVal hWnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long...
-
Click a button
Option Explicit
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare...
-
This is the first question for which I can give a satisfactory answer. Yeah!
-
Thanks. After ticking "Trust access to the VBA project object model" in the macro settings of the trust center I learned what I wanted. (it was 7.00)
-
This should be easy. I use MS office 2010 and I didn't download any upgrade, but I just can't find it.
-
I used sendmessage to double-click on the combobox, which fires the Click event. I'm sure this is not the "official" solution, but it works and I believe it's reliable.
Option Explicit...
-
On the cmb.text line I get the "Variable not defined." error. If I leave that part out the code does the same as it used to.
-
I changed the variable name from "combobox", and &O0 to 0&. The result is still the same. If I put .hwnd after the variable name in sendmessage I get "Invalid Qualifier" error.
-
REI need to use the "Save As" dialog box to save a file on the Desktop. (Windows XP) To do that I made this code to change value of the combobox on the top combobox to "desktop". When I run it, the...
|
Click Here to Expand Forum to Full Width
|