Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
file names
When I use the SaveAs function as follows:
ActiveWorkbook.SaveAs Filename:="H:\A\B\Sept 10 2003 \Sept10-1.xls", AccessMode:=xlShared ....when I open Sept10-1.xls, it says that it is shared, but when I use: ActiveWorkbook.SaveAs Filename:="Sept10-1.xls", AccessMode:=xlShared ....when I open Sept10-1.xls, it doesn't say that it is shared. How do I get it so that it saves to the current directory without having to type in all that information? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file names | Excel Worksheet Functions | |||
Open Excel file get error with file names that have spaces in the | Setting up and Configuration of Excel | |||
file names | Excel Worksheet Functions | |||
EXCEL97 FILE NAMES TRUNCATED TO THE FIRST LETTER IN THE FILE NAME | New Users to Excel | |||
File Names | Excel Worksheet Functions |