View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Duane Reynolds 323310 Duane Reynolds 323310 is offline
external usenet poster
 
Posts: 1
Default Saving to "MyDocuments" on users computer

I am writing a macro i want to be able to save a file to the users "My
Document/expired contracts". Not all users have the same path to My
Documents. Does VBA recognize %user% type commands? What would be the proper
syntax to make this work.
Thanks
Duane Reynolds