I am using PBWIN 7.02 and I am using CURDIR$ to get the path to a data file I want to open in EXCEL via SHELL. The problem is if there is a space in the name of the folder, EXCEL stops checking the string and then fails to open the file. Here is the code I am using to get the drive and path:
' Get the current drive
DIM s$
s$ = CURDIR$
workingdrv$ = LEFT$(s$,1)
' Get the Program Path from s$
progpath$ = s$+"\"
Here is the code I am using to to SHELL to EXCEL:
SHELL(excelpath$+"EXCEL.EXE" + " " + progpath$+"MktgExp.csv")
Besides telling me not to use spaces in folder names, is there something more I can do?
Thanks.
Manny
' Get the current drive
DIM s$
s$ = CURDIR$
workingdrv$ = LEFT$(s$,1)
' Get the Program Path from s$
progpath$ = s$+"\"
Here is the code I am using to to SHELL to EXCEL:
SHELL(excelpath$+"EXCEL.EXE" + " " + progpath$+"MktgExp.csv")
Besides telling me not to use spaces in folder names, is there something more I can do?
Thanks.
Manny
Comment