Skip to main content
T
touy8662371
Participant
September 27, 2018
Answered

Excel VBA To Turn Off PDF Layers

  • September 27, 2018
  • 1 reply
  • 1939 views

Hello,

Background - I have a couple PDF floorplans with close to 100 cubicles and due to internal staff turnover, it needs to be updated often.  I was able to use Excel vba to dynamically update the cublicle assignments, but since the floorplans were plotted with all the layers, including dimensions, fixtures to plumbing, the drawings are very clutter.

My question - is it possible to turn layers on/off with VBA.  Something like AvDoc.Lyaers("xxx").visible = false

Thanks.

This topic has been closed for replies.
Correct answer Bernd Alheit

You can use a user folder. Info about this for version XI:

Where did the Priveledged JavaScript folder go in XI? This is the folder in X that is used for custom JavaScripts (Java…

1 reply

Bernd Alheit
Community Expert
Bernd AlheitCommunity Expert
Community Expert
September 27, 2018

You can use Visual Basic - Javascript bridge.

T
touy8662371Author
Participant
September 27, 2018

You mean using the JSObject?  I thought about that, but I have a couple problems.  I don't have write access to the Adobe folder and I don't appear to have a "user" folder.  Will it work if I use my user folder instead and where should I create the user foler for Acrobat DC?

My app folder is:

C/Program Files (x86)/Adobe/Acrobat DC/Acrobat/JavaScripts

Bernd Alheit
Community Expert
Bernd AlheitCommunity ExpertCorrect answer
Community Expert
September 27, 2018

You can use a user folder. Info about this for version XI:

Where did the Priveledged JavaScript folder go in XI? This is the folder in X that is used for custom JavaScripts (Java…

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices