Excel Name Manager (JavaScript edition)

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Excel Name Manager (JavaScript edition)

Post by Jan Karel Pieterse »

Do you use range names, but are sometimes forced to use Excel on-line? I have good news for you! As of today, you can install my free Name Manager add-in and use it in Excel on-line to create, edit and manage range names! See https://jkp-ads.com/excel-name-manager-js.asp
name-manager-js02.png
You do not have the required permissions to view the files attached to this post.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Name Manager (JavaScript edition)

Post by HansV »

Thanks! :thumbup:
Best wishes,
Hans

User avatar
StuartR
Administrator
Posts: 12612
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: Excel Name Manager (JavaScript edition)

Post by StuartR »

Thank you
StuartR


User avatar
BobH
UraniumLounger
Posts: 9293
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Excel Name Manager (JavaScript edition)

Post by BobH »

I'm having trouble extracting these files.

I open the .ZIP file, select all the files, choose extract, provide the pathname I want them to extract to, then click OK. The process appears to complete, but when I look at the destination location there are no files. Strangely, when I repeat the process, a panel appears asking if I want to replace existing files. After replying 'yes to all' the process completes again; yet there are not files listed in that directory when I display it.

I know that at 81 I'm old and losing a step or three, but I can't figure this one out. :hairout:

:cheers: :chocciebar: :thankyou:
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Name Manager (JavaScript edition)

Post by HansV »

Bob, the version mentioned in this thread does not come in a zip file. Did you download the Name Manager add-in for the desktop version of Excel from Name Manager: Range names made easy?
Best wishes,
Hans

User avatar
BobH
UraniumLounger
Posts: 9293
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Excel Name Manager (JavaScript edition)

Post by BobH »

Yes, Hans, I think did download from that link.
Name Manager.PNG
When I click the hotlink, I get a popup listing files and the first one is named namemanager2007.zip which I downloaded.

I tried to capture the pop-up menu using both ScreenPresso and Snipping Tool but was unsuccesful.
You do not have the required permissions to view the files attached to this post.
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Excel Name Manager (JavaScript edition)

Post by Jan Karel Pieterse »

Hi Bob,

You downloaded the vba version, which is the most feature rich version. To install, unpack that zip file to any folder. Then right click the Excel files in that folder one by one and choose properties. Check the unblock box. After that, open the setup tool and press the button
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Excel Name Manager (JavaScript edition)

Post by HansV »

To unpack, you can try dragging the files from the zip file to the folder of your preference.
Best wishes,
Hans

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Excel Name Manager (JavaScript edition)

Post by Jan Karel Pieterse »

Please note that I've updated the tool today. You can get the update by clicking that big red N, and then pressing Control+F5.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com