[YMCS/YDMP Free Trial Program]Yealink would like to offer Free Trial Program of Yealink device management service for our current eligible customers. You can see the details below.

Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Phonebook generation tool VBA permissions problem
Author Message
Ken_Protecht Offline
Junior Member

Posts: 3
Joined: Feb 2015
Reputation: 0
Post: #26
RE: Phonebook generation tool VBA permissions problem
(01-24-2015 08:19 AM)Les Firth Wrote:  There are possibly two problems here.

The Yealink Phonebook Generation Tool opens in Excel 2010 and 2013 ok.

When either of the buttons is pressed, you get the "Permission to use object denied message" or "Compile error in hidden module ??1".

First, you need "Microsoft XML, v3.0" reference in VBA to resolve DOMDocument. (From Excel, Alt-F11 to open the VBA editor, then Tools, References, locate and tick "Microsoft XML, v3.0".)

The problem then is that the Excel macros save to the C:\ drive. In some environments, the user does not have write permissions to C:\. Easiest solution would be to find a PC that allows you to write to the C:\ as default.

Yealink may consider adding support for a variable on the PhoneBook tab in which the user can specify a path.

Hope this helps

I'm getting the Compile error in hidden module ??1 problem. Microsoft help suggests that this is due to trying to run 32-bit code in the hidden module on 64-bit Excel. Les, have you used the tool with 64-bit Excel? I looked for Tools > References but that is greyed out, possibly because it's a click to run Office installation.

Yealink, why such a horrible tool? And only for Windows. Why can't you distribute something written in say Python to convert CSV to XML which would work on more platforms?
02-09-2015 09:03 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Post Reply 

Messages In This Thread
RE: Phonebook generation tool VBA permissions problem - Ken_Protecht - 02-09-2015 09:03 AM

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Configuration Generator Tool Abzorb 1 1,892 12-05-2023 08:28 PM
Last Post: ATICT
  Where is the Config Encryption Tool? Clevelander 1 3,835 10-19-2021 02:56 PM
Last Post: kapetrosyan
  LDAP "problem" softnetvoip 1 4,015 09-30-2021 05:07 PM
Last Post: softnetvoip
  Problem with LDAP hausrocker 0 4,790 03-24-2021 08:28 PM
Last Post: hausrocker
  Modern Yealink Phonebook Generation Tool rgranholm 2 10,539 04-30-2020 09:03 PM
Last Post: rgranholm
  Remote PhoneBook format for several models aralmeida 2 7,586 10-01-2019 04:20 PM
Last Post: aralmeida
  Configuration Generator Tool telepathinc 16 58,612 09-15-2017 02:50 PM
Last Post: Sardar
  Abc problem Niksea 7 21,738 06-23-2017 07:30 AM
Last Post: Niksea
  Phone history and miss call problem ClearBoth 2 12,792 04-06-2017 09:16 AM
Last Post: Lucia_Yealink
  T26 phonebook sveldhuis 0 5,528 08-05-2016 05:46 PM
Last Post: sveldhuis

Forum Jump:

User(s) browsing this thread: 1 Guest(s)

Contact Us   Yealink   Return to Top   Return to Content   Lite (Archive) Mode   RSS Syndication