Adding an attachment with VBA adds "%20" instead of spaces in the filename.

[coveredinbutter]

HI There,

I have some VBA code to grab an excel file and add it to a new e-mail:

.Attachments.Add varShifBiddingPath & "\Proxys" & "\" & varName1 & varName2 & ".xlsm"

This works as expected, opening a new message in outlook with an attachment named "WCC Chat - Full Time.xlsm".

I now have a second PC, and when I run the same macro the attachment is named "WCC%20Chat%20-%20Part%20Time.xlsm".

Since this is a new PC, I'm thinking it must a setting in Outlook that needs to be adjusted?

Any ideas?

Thanks in advance.

 

[6StringJazzer]

Please show all of your code. The issue may not on the line you showed.

What is varShifBiddingPath ?

As you may know, %20 is used in a URL if a file name has spaces, because spaces are not allowed in a URL. So somewhere along the line your file string is getting encoded as a URL. But I don't think Outlook will do that automatically in the VBA.

 

[coveredinbutter]

Please show all of your code. The issue may not on the line you showed.

What is varShifBiddingPath ?

As you may know, %20 is used in a URL if a file name has spaces, because spaces are not allowed in a URL. So somewhere along the line your file string is getting encoded as a URL. But I don't think Outlook will do that automatically in the VBA.

varShifBiddingPath = ThisWorkbook.path

It's a folder on my desktop. Works fine on 1 PC, but not another.

 

[6StringJazzer]

On the PC where it doesn't work, what is the value of ThisWorkbook.path? If it is in a OneDrive folder it is going to come back as a URL.

 

[coveredinbutter]

On the PC where it doesn't work, what is the value of ThisWorkbook.path? If it is in a OneDrive folder it is going to come back as a URL.

It's actually the same folder, on the desktop on both machines. So the sheet is in a folder on the desktop and grabbing the attachment from a sub-folder called "Proxys"

 

[6StringJazzer]

I'm looking for a very specific answer. Please execute the code on the machine with the problem and provide the actual string that is the full path of ThisWorkbook.Path.

I also asked to see all the code.