[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.
https://www.yealink.com/ydmp-freetrial-2020


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
  Modern Yealink Phonebook Generation Tool rgranholm 2 3,527 04-30-2020 09:03 PM
Last Post: rgranholm
  Remote PhoneBook format for several models aralmeida 2 2,207 10-01-2019 04:20 PM
Last Post: aralmeida
  Configuration Generator Tool telepathinc 16 32,155 09-15-2017 02:50 PM
Last Post: Sardar
  Abc problem Niksea 7 10,167 06-23-2017 07:30 AM
Last Post: Niksea
  Phone history and miss call problem ClearBoth 2 6,493 04-06-2017 09:16 AM
Last Post: Lucia_Yealink
  T26 phonebook sveldhuis 0 2,721 08-05-2016 05:46 PM
Last Post: sveldhuis
  problem with HEADSET T23G Ana 3 5,395 07-05-2016 03:43 PM
Last Post: Yealink_Michael
  Remote ip connection problem riccardoc 0 2,709 07-01-2016 05:12 PM
Last Post: riccardoc
  SIP Port problem secureip 2 4,820 06-29-2016 05:41 AM
Last Post: secureip
  Phonebook Generation Tool for Macs? nestman 2 5,235 12-17-2015 04:39 AM
Last Post: jcaruso

Forum Jump:


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

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