jdsorrell
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It is the only posted solution to the problem
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.