Referring to files in same folder as workbook in VBA

[Adnan_razaq]

Hi,

I'm trying to put piece of VBA code together to attach some PDF files in outlook and send out.

However, I sometimes work from my personal laptop and my business laptop. How can I code something like this

.Attachments.Add "C:\Users\arazaq\Documents\Black\PDF Reports\Demo PDF\UK FTSE 100 Equity.pdf"

So that if I open the workbook on a another machine I would not need to to re-map the location of the PDF files to be attached. The PDF files are stored in the same folder as the workbook

Many Thanks in advance

 

[Norie]

You can get the path to the workbook the code is in using ThisWorkbook.Path.

 

[Adnan_razaq]

just tried this and it failed

.Attachments.Add "ThisWorkbook.Path.\PDF Reports\Demo PDF\UK FTSE 100 Equity.pdf"

Thanks

 

[Adnan_razaq]

also attempted this

.Attachments.Add "ThisWorkbook.Path\UK FTSE 100 Equity.pdf"

 

[RoryA]

It would be:

.Attachments.Add ThisWorkbook.Path & "\PDF Reports\Demo PDF\UK FTSE 100 Equity.pdf"

 

[Norie]

I usually go for something like this.

.Attachments.Add ThisWorkbook.Path & Application.PathSeparator & "UK FTSE 100 Equity.pdf"