View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vijay Kotian Vijay Kotian is offline
external usenet poster
 
Posts: 75
Default Combine several macros

I have created several macros for one of my assignement, In which i have
specified a directory (e.g. K:\JPP\FCH). In all my macros i have used this
path for processing. If the path is changed, then I need to go to all macros
and individually change the path. Is there any alternative so that if i
change path at one place all macros get updated OR assign path address to a
variable and assign this variable to all macros once, so that in future only
at one place the path needs to be updated. How this can be done?