Thread: SendKeys
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arnie Arnie is offline
external usenet poster
 
Posts: 65
Default 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