| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path string has spaces
This code does NOT work for me:
v = Shell("C:\bin\wordpad.exe c:\files\Jan 2021\dat\readme.rtf") The error message says "Unable to open c:\files\Jan" I guess the space character after "Jan" is what causes the problem. Does anyone have any suggestions on how to fix this without renaming the folders? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Path string has spaces
"Tatsujin" wrote in message
This code does NOT work for me: v = Shell("C:\bin\wordpad.exe c:\files\Jan 2021\dat\readme.rtf") The error message says "Unable to open c:\files\Jan" I guess the space character after "Jan" is what causes the problem. Does anyone have any suggestions on how to fix this without renaming the folders? Try surrounding the path with double quotes - v = Shell("C:\bin\wordpad.exe ""c:\files\Jan 2021\dat\readme.rtf""") Peter T |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Path string has spaces
On Wednesday, January 6, 2021 at 2:37:47 AM UTC-7, Peter T wrote:
Try surrounding the path with double quotes - v = Shell("C:\bin\wordpad.exe ""c:\files\Jan 2021\dat\readme.rtf""") Peter T Yes, that worked. Thanks you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find String in another string - only between spaces | Excel Worksheet Functions | |||
| Value between two spaces in a String | Excel Programming | |||
| Removing Spaces from string | Excel Worksheet Functions | |||
| Open File with Spaces in Path | Excel Programming | |||
| counting spaces in a string | Excel Programming | |||
Linear Mode
