Excel Office Pro 2007 Dropbox Workbook Open/Close Error

I have 2 Workbooks located in the same Dropbox folder. One of the Workbooks has a VPA program with an Open Event. In the Open Event, the VPA program can neither Open/Close the 2nd Workbook nor address the Workbook Sheets in commands. Since the Workbooks are located in a DropBox folder, they cannot be addressed like non-DropBox Workbooks (e.g., C:\users\valued customer\DropBox). I have no problem addressing Sheets in the Workbook that contains the VPA program.
jdsorrellAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

twohawksCommented:
Perhaps someone has a more appropriate solution, but a (not so pretty) alternative may be to relocate the file to a non-dropbox folder, then create a hardlink to it in the folder linked to your dropbox.

I am not sure if that will work, but theoretically it should assuming the dropbox folder is located on the same hard drive as the folder with the original, and we are not talking about trying to do this over a network.
0
twohawksCommented:
Also, I would (of course) inspect the file's permissions before and after placing into dropbox to investigate any potential discrepencies that may provide other clues to the strange behavior.
0
DALSOMCommented:
Hi,
Try reallocating the dropbox folder to a shorter address name, like c:\dropbox\

Maybe, there is into a folder on my documents or user's folder.

I use dropbox, and use to build macros with vb for excel, and still works flawlessly on dropbox.

Please try,
I hope this help you.

Dalsom.
0
jdsorrellAuthor Commented:
Sorry for not replying. I did not notice the Expert answers. The solution to the problem is the following Excel VBA command:

Workbooks.Open (ThisWorkbook.Path & Application.PathSeparator & "Attendance TablesM.xlsm")

It allows all PCs using DropBox to Open the file.

Thanks,

John
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jdsorrellAuthor Commented:
It is the only posted solution to the problem
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.