Link to home
Start Free TrialLog in
Avatar of jdsorrell
jdsorrellFlag for United States of America

asked on

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.
Avatar of twohawks
twohawks
Flag of United States of America image

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.
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.
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.
ASKER CERTIFIED SOLUTION
Avatar of jdsorrell
jdsorrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jdsorrell

ASKER

It is the only posted solution to the problem