| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make sure file is in correct folder??
I'm new to this VBA thing, doing OK, but I'm getting lost here.
I'm working on a project that will be distributed to "newbies" to put it nicely. I know they will probably move the excel file around from it's intended location. In the application it creates a new version of itself for each new week. I want to guarantee that new version is created in the My Documents/Inventory folder. I tried using CurDir to find out the current directory, it returns My Documents every time, unless I manually do a File/Save As & then it reports the proper My Documents/Inventory. I just need to check the current directory, see if it's the My Doc/Inv & if not, save it there, possibly creating the directory if they screwed it up! & to add to the fun, this will be running on W98/2000/XP Thanks! -- Lee www.raising-cain.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To make the excel file in shared folder to be editable by every us | Excel Worksheet Functions | |||
| Not updating Files from correct folder | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| HOW DO I MAKE FILE FOLDER LABELS FROM EXCEL | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
Threaded Mode
