First off just wanted to thank this forum for existing. Two months ago I was an excel newbie and now been doing some pretty complex things from reading up on here!

I have an excel sheet which calculates a bunch of variables for quoting purposes, and then the macro auto-generates a word document with changing values which works perfectly. The issue I ran into was getting multiple images in the header so it looks pretty so I decided to open a preset word template file versus creating a new one each time. This worked perfectly as I'd hope on windows.

Dim objword
Dim objDoc
Dim objSelection
Set objword = CreateObject("Word.Application")
Set objDoc = objword.Documents.Open("C:\QuoteTemplate\QuoteTemplate.docx")
objword.Visible = True


However a coworker with a Mac tried to use it and has some problems. I first dealt with the ActiveX issues by using form controls and informing him to use the manual macro run via Developer > Macros which bypasses the button, but the issue is that obviously Macs do not have a C: drive. Does anyone know how I could do this? I was thinking about having the template file on an external drive/usb stick but even then I think the naming process is different.

TL;DR I need a way of opening a preset word file on both windows and mac to write to. Is there any directory that looks the same from both operating systems. Or is there a way of looking just in the same folder which the excel file is contained versus having to start with the drives. So that no matter what folder your excel file is in, as long as the word template is in the same one it will work (I wouldn't think so as computers generally don't think that way but one can hope)

Let me know,

Smooth