Posted to microsoft.public.excel.programming

Arnie

external usenet poster

Posts: 65

SendKeys

can anyone help i am using

SendKeys "C:\Documents and Settings\Fred_Bloggs\My
Documents\Folder1\Folder2\AnyThing.txt{Enter}", Wait:=True

however i want anyone to use this so i want to get rid of "Fred_Bloggs"

i tried

SendKeys Thisworkbook.Path & "\Folder2\AnyThing.txt{Enter}", Wait:=True

but its not happy any ideas?

Thanks
Arnie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sendkeys	[email protected]	Excel Programming	3	September 27th 08 03:26 PM
SendKeys	ankur	Excel Programming	5	December 31st 06 12:15 AM
SendKeys in VBA	John	Excel Programming	1	June 24th 05 05:46 PM
SendKeys?	CMK	Excel Programming	2	February 23rd 05 12:03 AM
Sendkeys	GB[_3_]	Excel Programming	0	September 16th 03 10:39 PM

All times are GMT +1. The time now is 02:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us