[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
ClausMoller Offline
Junior Member
**

Posts: 9
Joined: Nov 2013
Reputation: 0
Post: #21
RE: Phonebook generation tool VBA permissions problem
(12-03-2013 11:08 AM)Yealink Support Wrote:  Hi ClausMoller,

Can you upgrade to the latest version of T46G which has fixed some issues?
Then try again?

Now my firmware is updated but i can still not open the remotephonebook
12-03-2013 08:46 PM
Find all posts by this user    like0    dislike0 Quote this message in a reply
pchd Offline
Junior Member
**

Posts: 1
Joined: Apr 2014
Reputation: 0
Post: #22
RE: Phonebook generation tool VBA permissions problem
(11-30-2013 12:41 PM)ccwtech Wrote:  
(10-23-2013 03:59 PM)Yealink Support Wrote:  Hi peterf,

Please refer to the user guide of Yealink Phonebook Generation Tool.
http://www.yealink.com/Upload/T4X/GA/Yea...952205.zip

I can generate a remote phonebook using this tool as user guide.
1. So please save this tool as " Excel Macro-Enabled Workbook " first
2. Then open this Excel Macro-Enabled Workbook tool
3. Enable macro in this tool
4. Then fill the value in the tool
5. click the" Create Remote Phonebook"
6. it will be work

Hope above information can help you.

I am also getting VBA error. Windows 8.1, Office Excel 2013. I've followed Steps 1-6 above.

For me also the VBA error - Windows 8.1 Pro, Excel 2013 (v 15.0.4605.1000 32 bit). I've followed the 6 Steps. But step 5 failed with VBA error "Permission to use object denied"

Edit1 : I test the phone book of ClausMoller (downloaded here), it works perfectly with the embeded web server of a Synology NAS

Edit2 : I tried with Excel 2010 and the file is generated correctly - if I find a way to use Excel 2013 I'll post the solution here

Jacques Dieu
PC SoftWare - BeMyPhone
Belgium
(This post was last modified: 04-20-2014 04:05 AM by pchd.)
04-20-2014 02:48 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Les Firth Offline
Junior Member
**

Posts: 4
Joined: Jan 2015
Reputation: 0
Post: #23
Information RE: Phonebook generation tool VBA permissions problem
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
(This post was last modified: 01-24-2015 08:53 AM by Les Firth.)
01-24-2015 08:19 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
James_Yealink Offline
Administrator
*******

Posts: 1,159
Joined: Aug 2014
Reputation: 8
Post: #24
RE: Phonebook generation tool VBA permissions problem
Hi Les Firth,

Thanks for your share and suggestion. We will add this our FAQ and feedback it to our Programmer.

Regards,
James
(This post was last modified: 01-24-2015 11:45 AM by James_Yealink.)
01-24-2015 11:45 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Les Firth Offline
Junior Member
**

Posts: 4
Joined: Jan 2015
Reputation: 0
Post: #25
RE: Phonebook generation tool VBA permissions problem
Thanks James,

The attached xlsm file (for Excel 2007 and later) provides the support. The VBA code checks for a "Path" name in/at PhoneBook!H3, but does not validate it. Therefore if an incorrect path is specified, you will still get the "Permission to use object denied" message.

Thanks

Les
.zip  Yealink Phonebook Generation Tool.zip (Size: 59.73 KB / Downloads: 294)
01-24-2015 05:44 PM
Find all posts by this user    like0    dislike0 Quote this message in a reply
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
Les Firth Offline
Junior Member
**

Posts: 4
Joined: Jan 2015
Reputation: 0
Post: #27
RE: Phonebook generation tool VBA permissions problem
Hi Ken,

The hidden module issue is because you don't have the password for the macro. There is IMHO no good reason for the password, which is very easy to guess. Until you have the macro password, the VBA Tools, References... option is greyed out.

Please use the file I uploaded on 24-Jan-15. It has no password (sorry yealink), and you can specify a path to use other than C:\. My addition is rather primitive, but works for this very handy utility.

You may or may not then have the "Microsoft XML, 3.0" reference problem, which should be simple to correct.

Good luck.

Les
(This post was last modified: 02-09-2015 10:21 AM by Les Firth.)
02-09-2015 10:19 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Ken_Protecht Offline
Junior Member
**

Posts: 3
Joined: Feb 2015
Reputation: 0
Post: #28
RE: Phonebook generation tool VBA permissions problem
(02-09-2015 10:19 AM)Les Firth Wrote:  Hi Ken,

The hidden module issue is because you don't have the password for the macro. There is IMHO no good reason for the password, which is very easy to guess. Until you have the macro password, the VBA Tools, References... option is greyed out.

Please use the file I uploaded on 24-Jan-15. It has no password (sorry yealink), and you can specify a path to use other than C:\. My addition is rather primitive, but works for this very handy utility.

You may or may not then have the "Microsoft XML, 3.0" reference problem, which should be simple to correct.

Good luck.

Les

Thanks Les,

I can now see the module, but I still have the same permission problem. I checked under Tools > References and Microsoft XML 3.0 is ticked. Any ideas?
02-09-2015 11:25 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Les Firth Offline
Junior Member
**

Posts: 4
Joined: Jan 2015
Reputation: 0
Post: #29
RE: Phonebook generation tool VBA permissions problem
Specify a path you have write access to in cell H3 in the PhoneBook sheet.
02-09-2015 11:32 AM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Ken_Protecht Offline
Junior Member
**

Posts: 3
Joined: Feb 2015
Reputation: 0
Post: #30
RE: Phonebook generation tool VBA permissions problem
(02-09-2015 11:32 AM)Les Firth Wrote:  Specify a path you have write access to in cell H3 in the PhoneBook sheet.

Ah ok, great thanks very much. I also found that I should have a trailing \ on the path.
02-09-2015 12:14 PM
Find all posts by this user    like0    dislike0 Quote this message in a reply
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  Modern Yealink Phonebook Generation Tool rgranholm 2 3,555 04-30-2020 09:03 PM
Last Post: rgranholm
  Remote PhoneBook format for several models aralmeida 2 2,217 10-01-2019 04:20 PM
Last Post: aralmeida
  Configuration Generator Tool telepathinc 16 32,231 09-15-2017 02:50 PM
Last Post: Sardar
  Abc problem Niksea 7 10,207 06-23-2017 07:30 AM
Last Post: Niksea
  Phone history and miss call problem ClearBoth 2 6,501 04-06-2017 09:16 AM
Last Post: Lucia_Yealink
  T26 phonebook sveldhuis 0 2,730 08-05-2016 05:46 PM
Last Post: sveldhuis
  problem with HEADSET T23G Ana 3 5,401 07-05-2016 03:43 PM
Last Post: Yealink_Michael
  Remote ip connection problem riccardoc 0 2,715 07-01-2016 05:12 PM
Last Post: riccardoc
  SIP Port problem secureip 2 4,827 06-29-2016 05:41 AM
Last Post: secureip
  Phonebook Generation Tool for Macs? nestman 2 5,239 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