Go Back   Webmaster Malaysia Forum » Website Design & Development » Webmaster Tools

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 08-04-2007, 11:01 AM
Senior Webmaster
 
Join Date: Apr 2007
Location: Penang
Posts: 483
Rep Power: 30
yonghs is on a distinguished road
Add many tools to MS Excel

Actually, this is a general Excel add-in that I have written a few years ago... it adds an extra menu to the Excel menu bar.

You can edit text like combining, change case, add/remove characters, remove hyperlinks in all selected cells, save selected range as HTML (and many other tools to mention here)

Hopefully you can use it to make your tasks easier, like managing your users, data etc.

It's not exactly a specific tool for webmasters but it may come in handy.

Get it from http://www.excel-extools.com (i've released it as freeware)


__________________
http://www.jobcity.com.my

Last edited by yonghs; 08-04-2007 at 07:56 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 08-04-2007, 04:12 PM
genzy's Avatar
Nowhere Webmaster
 
Join Date: Aug 2006
Location: Malaysia
Posts: 1,581
Rep Power: 59
genzy is on a distinguished road
Cool! Thanks for sharing. There are also testimonials.

What kind of language you use to write the plug-in?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 08-04-2007, 07:55 PM
Senior Webmaster
 
Join Date: Apr 2007
Location: Penang
Posts: 483
Rep Power: 30
yonghs is on a distinguished road
I use VBA (visual basic for applications) .................. the tools are actually a collection of macros that i wrote and packaged as an add-in.


__________________
http://www.jobcity.com.my
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 11-04-2007, 02:02 PM
iamfreelancer's Avatar
Vibrate your Brain Please
 
Join Date: Sep 2005
Location: in my body lar...
Posts: 1,254
Rep Power: 66
iamfreelancer will become famous soon enough iamfreelancer will become famous soon enough
you didn't list down the features of extools ...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 11-04-2007, 02:42 PM
Senior Webmaster
 
Join Date: Apr 2007
Location: Penang
Posts: 483
Rep Power: 30
yonghs is on a distinguished road
Most of the tools are for general everyday users but I think webmasters may find some of it useful. I use it everyday to help in the organisation and research for my web projects.

Here is the list I copied from the user guide... ... the complete list of the tools/utilities WITH explanation is at http://www.excel-extools.com/extools_user_guide.php :

1. Introduction
2. Favorite Files
3. Favorite Text Clips
4. Delete Empty Cells in Columns
5. Transpose
6. Reverse Order
7. Check for Duplicates
8. Multiple Selection Copy
9. Save Selection as File
10. Save Selection as HTML
11. Save Selection as Picture
12. View
13. Compare Worksheets
14. Create Worksheet Map
15. Sort Sheets
16. Delete Empty Sheets
17. Hide Blank Rows/Columns at End of Sheet
18. Unhide all Hidden Rows/Columns
19. Unhide all Hidden Sheets
20. Remove Hyperlinks on Worksheet
21. Reset Last Cell
22. Save and Backup
23. Close all Saved Workbooks
24. Close and Delete Current Workbook
25. Close all Workbooks Without Saving
26. List all Fonts
27. Clear Recently Used Files List
28. Conditional Select Cells by Value
29. Conditional Select Cells by Format
30. Conditional Select Rows by Value
31. Select Cell with Max Value
32. Select Cell with Min Value
33. Select Last Cell
34. Select Cells with Error
35. Select Used Area
36. Select to Right
37. Select to Bottom
38. Select all Sheets
39. Select all Empty Sheets
40. Text - Case
41. Text - Insert
42. Text - Trim
43. Text - Remove
44. Text - Combine
45. Copy Cell Formula as is
46. Convert Formula to Constant Value
47. Convert Between Absolute and Relative Reference
48. Perform Math Calculation on Selection
49. Unit Converter
50. Round Numbers
51. Convert Percents to Numbers
52. Convert Numbers to Ordinals
53. Convert Numbers to Text
54. Convert Between Roman and Arabic Numbers
55. Insert Random Numbers to Selection
56. Set Subscript/Superscript
57. Word Wrap On/Off
58. Center Vertically
59. Print Multiple Sheets
60. Set File Path as Header/Footer
61. Number of Days Between Two Dates
62. Add Days to a Date
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 11-06-2007, 01:18 PM
New kid on the block
 
Join Date: Jun 2007
Location: Pakistan
Posts: 5
Rep Power: 0
editorshahid is on a distinguished road
nice sharing
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
mcmana nak export excel ke mysql poshberry Website Programming 15 04-06-2004 04:29 PM
can excel VBA 97 be converted to XML? ymhy_80 Website Design 1 26-02-2004 01:15 PM
convert excel vba to webpage ymhy_80 Websites Review and Suggestion 1 20-02-2004 11:50 AM
Excel ke MySQL baddai Website Programming 2 01-11-2003 10:18 AM
transfer excel filr to powerpoint khairudin Mamak Stall 1 21-07-2003 01:16 PM


All times are GMT +8. The time now is 01:31 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0 vBulletin skin by ForumMonkeys.com.


WebmasterMalaysia.com is Proudly Hosted by Exabytes Semi Dedicated Server.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61