View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Justin Philips Justin Philips is offline
external usenet poster
 
Posts: 32
Default Saving Files into a Folder

I need to figure out how to programatically change the path name when
saving or to save to a folder using a macro. We use ID numbers to
access our computers and they show up in the path when we save ("My
Documents\ID number\folder..."). I want to know how I can just use
the last part of the path and let the reset default or something so
that the ID number for whoever uses the program doesn't matter. Any
other suggestions are welcome.