Website folder access via macro Excel

Hi all,

I would like to allow my Excel macro to save a pdf file in my website folder - so my page showing a pdf file gets updated automatically.

Any way to do this?

Many thanks,
Seb

Hi,

Normally, if you map the website filesystem to a network drive in Windows, from your machine’s perspective it will behave as a normal drive.

This means if you map, let’s say, https://your-site.web.cern.ch/_webdav/ to drive letter X:\, you should be able to use a path starting from X:\ in your Word macro to save or read files from your site.

If this is not the case and your Word macro refuses to work with mapped network drives, you can always have an aux folder in your machine, and write a script that does the copy/move. In Powershell or Batch files you can use commands that copy files to and from network drives without problems.

Just my two cents!

1 Like