View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike C Mike C is offline
external usenet poster
 
Posts: 25
Default Finding Current Path

Im creating a program that is pulling information from the cd it is located
on. I am running into trouble with the fact that people have differnt names
for their cd drives. I need my program to be able to tell which drive it is
in. I've tryed the CurDir and it only will give the path that i had originaly
on my computer instead of the present one. I know this is an easy fix but im
stuck. Also is there any way to run a macro upon opening of the program
instead of having to click on a button?