It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a file in a Confluence file share page using Excel VBA?

I already have an Excel spreadsheet that has VBA code to extract page data and create a file in a local folder of my choosing - and that works fine.

What I want to do is to create that same file, and write to it, using VBA within this same spreadsheet, but directly onto our Confluence Fileshare (not Jira).

For local file creation it is simple, with just a few lines of code

 

Has anybody done this and can share the VBA code please? Or suggest how I should do it?

At present, I will have to manually upload my locally created files to the fileshare

1 answer

0 votes

Just to clarify are you trying to write to a Confluence page using VBA?

Davin_Studer Community Leader Dec 12, 2019

Or are you trying to write to a shared folder on your Confluence server? I'm just a bit confused because there are no fileshares on Confluence Cloud. So, I'm not totally sure which you are trying to do.

Apologies - fileshare was just a general term.

 

I mean to be able to create a file and write to it on the fly in a shared folder - so that others can then read it.

Same as I can do to my local laptop/PC drive (but then have to upload to that same shared folder so they can read it)

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

52 views 2 4
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you