Could someone please tell me how to indicate current path in VBA when using
Excel? When I record a macro usinly excel, for example in haveing anothe
workbook open, it always includes the full path. What I want is for the
Workbook to be opened in the current directory, so I can move this directory
to other computers and have it the macro work without having to change paths
at each new machine. I tried ./, but that didn't work for me.
Ross