How to open files from dropbox share

**mbroxholme** · 03-16-2013, 09:37 AM

Hi there

I have a macro which opens .doc .docx and .txt files.... I've tested this on my local drive using the activesheet path to find the files. The file I want to open are in a folder called 'September' off of where the activesheet is. This is all working well locally.

However I actually need this to run from a dropbox file share, when I run it from there it just opens word but can't open the first file.... Any ideas how I can get this to run from a dropbox file share? At first I thought it might be because the file has spaces in it but I copied this file locally and it run fine locally from my D drive etc.

Here is part of my macro

Please Login or Register  to view this content.

Many thanks in advance.

Marie

**mbroxholme** · 03-16-2013, 09:49 AM

Actually when I step through the macro it skips over Set myDoc and goes to the end of the macro so that's why it's not opening the docx file. I don't think it's actually seeing that bit of code... not sure why...

**arlu1201** · 03-16-2013, 10:40 AM

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.