Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need to incorporate Browse into VBA application
Hi! You may also find GetOpenFilename useful, example: Private Sub CommandButton1_Click() ChDrive Left(DataFolder, 2) ChDir DataFolder & "\MeasData" DataFileName = Application.GetOpenFilename _ ("Data files (*.dat), *.dat", 1, "DATA") If...- hgb
- Post #9
- Forum: Microsoft: Access Modules (VBA Coding)
-
sendkeys to fast problem
and, DBritter, another thing: You still will often need a little pause between you Sendkeys, so use this routine instead: Private Sub Sk(cmd) Delay 0.2 SendKeys cmd, Wait:=Yes End Sub (I noticed that the "Private" part in Delay was in the wrong line in my previous message...- hgb
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
sendkeys to fast problem
Hello DBritter! I have hade the same problem, and recently I found a useful way to avoid it. Call WindowWait with e.g. App = "Untitled - Notepad" if that's what you are waiting for. Works nicely, but so far I have not been able to find out what the name of an arbitrary active window...- hgb
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
