|
-
Jun 2nd, 2006, 06:24 AM
#1
Thread Starter
New Member
[RESOLVED] Send keys and quotation marks
Hi,
I am trying to "find and replace all " double quotes in a text
file(notepad) from Excel. I have used the shell command to open file in notepad but the sendkeys ^H does not seem to open the "find and replace " splash. Below was my last effort of code. I'll appreciate any insights.
Thanks
V
SendKeys ("^H")
objShell.AppActivate "Replace"
Application.Wait (Now + TimeValue("0:00:07"))
SendKeys ("+2")
Application.Wait (Now + TimeValue("0:00:07"))
SendKeys ("%A")
SendKeys ("^S")
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|