• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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.
0
jdsorrell
Asked:
jdsorrell
  • 2
  • 2
1 Solution
 
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
 
jdsorrellAuthor Commented:
It is the only posted solution to the problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now