Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hii...
My VBA code generates a new excel sheet based on a existing excel template and saves the new excel sheet in a location desired by the user. The path where the excel sheet in saved is contained in the variable "fName" Now, i try to open the excel application directly using, Shell "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE " & FName, vbMaximizedFocus As long as the location is c:\xxx.xls or C:\test\xxx.xls (i.e) without any spaces.. i dont have any problems. But when the user saves it in his "my documents", the FName would be, "C:\Documents and Settings\user\Desktop\xxx.xls" now, it considers C:\Documents.xls as seperate path, and.xls as a seperate path and Settings\user\Desktop\xxx.xls as a seperate path. how do i resolve this....??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing entire woorkbook | Excel Discussion (Misc queries) | |||
Woorkbook toolbar | Excel Discussion (Misc queries) | |||
How do I create a backup woorkbook in Excel 2003. | Excel Discussion (Misc queries) | |||
woorkbook | Excel Worksheet Functions | |||
Close Open Woorkbook and Quit Excel | Excel Programming |