How to open a excel file in confluence in edit mode from a excel file on my PC(with the help of VBA)

Question

Hi,

I have a excel file stored on confluence with data that needs to be updated now and then.

I want to be able to open the excel file stored on confluence in edit mode and add data to the file.

The data that shall be entered comes from another excel file stored on my PC and contains a macro. I want to be able to open the file with the following VBA code(or similar):

ThisWorkbook.FollowHyperlink ("url-to-my-excel-file-in-edit-mode")

Unfortenately am I not able to find url that opens the file in edit mode.

Is there a way to solve this issue?

Regards

Andrej

Andrej Verem · Answer

Yes that is correct but I want to be able trigger the "edit" button from a script on my PC. For example, the script opens a url which then opens the file in edit mode (or something similar). I am trying to avoid the step of going to confluence and pressing the button manually.

Brant Schroeder · Answer

@Andrej Verem Welcome to the Atlassian community

The only way I know of to open an excel file and launch the excel application is to open the documents using Atlassian's office connector.  https://confluence.atlassian.com/doc/edit-in-office-using-the-office-connector-170493096.html