|
|
!!! VBA Excel problems with file path consisting spaces when sending command to Autocad
I coding VBA excel to send commands Insert blocks to Autocad.
Filename contains block is C:/Tu Tool/Rebar Detailing/Rebar Detail Block/EUROCODE/Type 21/Type 21-D12.dwg
4156257d-e3b2-40b5-931c-9665863a0fa4.png
However autocad interpret the SPACE in file path as Enter in command line?
445f3209-a17b-45b1-82c0-5663859e45fa.png
So have you got any ideas to handle these problems
Much thanks
Re: !!! VBA Excel problems with file path consisting spaces when sending command to Autocad
Surround the path with an additional set of quotes.
If you have a technical question, please find the appropriate forum and ask it there.
You will get a quicker response from your fellow AUGI members than if you sent it to me via a PM or email.
jUSt
Re: !!! VBA Excel problems with file path consisting spaces when sending command to Autocad
That won't work. You have to add the extra quote with either an escape character or a third set of quotes. See the examples below. Also, you either need to use vbLf or vbCrLf. vbCr just issues a carriage return.Originally Posted by Opie
ThisDrawing.SendCommand "_insert" & vbCrLf &"""C:\\some path with spaces\\filename,dwg"""
or
ThisDrawing.SendCommand "_insert" & vbCrLf &""C:\\some path with spaces\\filename,dwg""
Posting Permissions
Reply With Quote