ANmars.com

Excel/VBA expert since Sep 1997 (17 years 1 months)

Social bla bla bla

    Skype Me™!

Tree site map Get this tree

ArPoems - أشعار انمار

    Tue
    Nov 3
    1992
    نسمات في قلبي
    أمس ... في الأمس الذي ذهب هباء دخل شباكي النورس الصغير وقال لي قبل أن أطير " ... لا ...

    Sat
    Nov 28
    1992
    تسع زهور من حديقتي
    أيا أيتها الزهرة البيضاء هل سمعت حديث حبيبتي ؟ عن حبها لي ... عن وردتي؟ أيا أيتها ...

My other sites

next prev

Featured Work ... more

Sun
Sep 9
2012
SpellNumber (954 downloads)

Convert Numbers into English text (521 to Five hundreds twenty one), this one called (SpellNumber) I found online.
And (Num2ArText) that will do the same but in Arabic language , (as 500 to

Added: Sep, 2012 | Created: Jun, 2004
Mon
Jun 20
2011
XLPrgBar (935 downloads)

A simple way to help Excel developers showing the progress of a long operation, what Excel lacks.
What you need to do is copy the form (Frm7) and use the module (mMain) in (XLPrgBar) file into

Added and Created: Jun, 2011
Sun
Oct 14
2012
Match_2nd3rd (908 downloads)

A formula trick to search for an item in a list and get 2nd, 3rd, 4th, 5th and 6th item occurance found.
VLOOKUP (also MATCH and HLOOKUP) only gives you the first occurance
This formula uses

Added and Created: Oct, 2012
Thu
Oct 13
2011
MySQLReader (880 downloads)

Read any MySQL query into Excel table + VBA Code
This uses VBMySQLDirect application to read data from MySQL database into Excel spreadsheet
To run this you just need to install this app

Added: Oct, 2011 | Created: May, 2010
Wed
Jan 2
2013
Clookup (875 downloads)

I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the

Added: Jan, 2013 | Created: Jan, 2009
Sat
Oct 29
2011
Folder8 (825 downloads)

Share anything in a secure folder, Folder8 is the easy way to create a folder (secure or public) without registration. Once user creates folder, can add

Added and Created: Oct, 2011
Sat
Apr 21
2012
CalXL (805 downloads)

The first Excel functions-only calendar.
I created it as a sample for my students back in 2006 to show them how we can do monthly calendar using functions only, then I decided to share it

Added: Apr, 2012 | Created: Dec, 2006
Tue
Mar 26
2013
XLBrowser (701 downloads)

Browse files and folders inside Excel sheet, a simple tool to help you view files and folders, this was a request from one of my VBA Excel friends.
Code is visible and you can adjust it in any

Added and Created: Mar, 2013
Sun
Feb 19
2012
XLiFrame (683 downloads)

This is a simple way to scroll through large area in your sheet without using Excel scroll bars
It is function-only project that enables you to brows and scroll through an area in another sheet

Added and Created: Feb, 2012

Featured Lib ... more


Diving Club

Black Horizontal Dropdown Menu

CSS Date

XML Template V8

CSS Pagination Pack

OSlider

Specific

Store 7

Twitter Login

The flower

Design team

Corporate Green

CSS Tree

VBA DatePicker

vcard

VCard

Connect 368

Shoes 367

Agency 366

Line25 CSS effect

Delicious buttons

CSS Gradient

Recent Work ... more

Mon
Apr 15
2013
TaShee

Just like PowerPivot, TaShee, Lets you manage your SQL tables in Microsoft Excel
After you connect to a database in

Added and Created: Apr, 2013
Tue
Mar 26
2013
XLBrowser

Browse files and folders inside Excel sheet, a simple tool to help you view files and folders, this was a request from one of my VBA Excel friends.
Code is visible and you can adjust it in any

Added and Created: Mar, 2013
Mon
Mar 25
2013
EmailList

Excel macro to send emails to multiple email addresses, once you have list of email addresses, names, subjects and bodies in the list, click (Send All) to send emails to all these

Added: Mar, 2013 | Created: Apr, 2009
Wed
Jan 2
2013
Clookup

I have seen a lot of requests asking about a lookup functionality that works for colors, this dated back in 2009 when I had some time to work on it, it is a UDF (User-defined-function) that grap the

Added: Jan, 2013 | Created: Jan, 2009

Recent Lib ... more


LoadTree_ANmar7

LoadImage

IsWorkbookOpen

Free Video rotate

Agency 366

Shoes 367

Connect 368

Synchronous

Random.org

Passwords Generator