ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

29 Blog posts tagged with software

Oct 26

Frequent quick copy or Move

To copy quick to a certain location without jumping to copy and paste I usually get files in certain location, and most of the time want to move/copy them into same destination location A quick way to do that, is creating shortcut to that destination folder inside the source folder. Then when I want to copy/move a file, I just drag that file from the source folder (with CTRL to force copy, with Shift to force move) into the shortcut And it will be moved/copied as I intended to :-) Read more >>>

Wednesday Oct, 26, 2016 8:23
Apr 27

My #LinkedIn #password

f(x) = Secure Strong Password

Having same exact password for multiple sites or logins is really something you should not do, am sure you already know that.

Having multiple passwords on the other hand is something you can easily forget, it is becoming very hard to remember which password goes with which? What was the password you created for this login?

Some folks (including me) used to have a list of passwords, but now you need to maintain it, update it, etc. again more pain

I used to have a list of my passwords saved in an Excel sheet, but after awhile it started to consume time just to maintain it.

So. Here is something I have been doing for few years now, and thought I can share the idea

Hint: Password function

Read more >>>

Wednesday Apr, 27, 2016 14:24
Sep 21

Returning customer, back to .NET

When you see a returning clinet, you know that they like you (or that your price is too low :-) ).
Any how, I got a returning client for the first time in few years now, it is clear that they liked my work (and possible my prices too). This time with a complete new project. Read more >>>

Monday Sep, 21, 2015 7:23
Feb 26

Methods to speed up VBA long loops in Excel

Edit 2015-03-02: Thank you all for all these comments and appreciate the suggestions, not that I do not appreciate them, just want you all know that this is not a question, I am not asking for help, I am only stating the findings that I landed on. thanks again

This is the second time, the first time was back in 2003 when I was creating some project that has long loops, and it needed me few days to discover that the best way to handle these long loops is to combine between Excel cell functions and VBA WorksheetFunction

You see in case you are struggling here

to go through each row in a sheet, we can one of the following:

Read more >>>

Thursday Feb, 26, 2015 8:35
Nov 28

LEGO again

Back to my hobby again, LEGO
After one year living in a small house, we moved into a bigger one.

Now I have my own LEGO place, I am back, have tons of pictures for my collection.

The important part is that I am now submitting my creations to LEGO CUUSOO website.
Read more >>>

Thursday Nov, 28, 2013 0:0
Apr 1

Unlimited plan, not unlimited anymore

So the limited plan I thought I have is not so "Limited"
My files online have crossed the 25GB limit, that made the people at my hosting company to contact me and complain that my files is taking too much space and I need to delete some.

IT was a shock, but I remember that there was talking for a while about how "Unlimited plans" are not so "Unlimited". Read more >>>

Monday Apr, 1, 2013 0:0
Feb 19

Protect VBE Project from Excel VBA macro

After several attempts, I was able to make a macro to protect itself (protect the VBA project in VBE).
This is very rarely used and may not be successful. Read more >>>

Tuesday Feb, 19, 2013 0:0
Feb 14

Delete sheet from Excel VBA without warning

I know it is all around the net, this tip has been helping a lot in my VBA coding.
The funny part is that I don't use it much, but when I need it I have to go online and search for it.
So, smarty pants here decided to put it on my blog, and when searching, I can find it faster. Read more >>>

Thursday Feb, 14, 2013 0:0
Jan 20

Microsoft Office 2010 Word Expert

Ok, I admit, I did it without thinking
I failed to pass the 700 points of Mictosoft Office Specialist 2010 Word Expert (MOS) from the first time,
I went to the test without any ideas of what I am going to face, and the level of test was high, so I failed, next time, I will prepare for it. Read more >>>

Sunday Jan, 20, 2013 0:0
Oct 6

Active on LinkedIn

Last week of LinkedIn activity paid off, 15 people checked out my profile during last week, I have to admit though that not all of them are welcome.

Read more >>>

Saturday Oct, 6, 2012 0:0
Oct 4

New certificates wave

After suttling down in North Chicago area for few months now, I am thinking of getting back to one old hobby I used to develop two years ago.

It is hunting certificates, Microsoft Office Specialist Certificates. Read more >>>

Thursday Oct, 4, 2012 0:0
Apr 6

Adding PHP+Wordpress on 1st Server

After few days of setting it up, I now have Microsoft SQL database along with MySQL database and PHP.
I needed also to install Wordpress, which I installed few hours ago.
I have these sites now on my own server:

These are the first three sites, in preparing to move in completely to host my own sites on my own server.

Friday Apr, 6, 2012 0:0
Apr 2

1st Own Server database

After few hours of digging and playing, I managed to run the SQL server 2008 on my 1st Server.
Now I am ready to go, Online server with SQL database that support Arabic and ready to go.
I might just tweak the speed a little bit. Go on ANmar, the road is plain in front of you

Monday Apr, 2, 2012 0:0
Mar 19

Craigslist notification on your WinPhone 7

After I changed my phone from Android to Windows 7 (From Samsung Epic 4G to HTC Arrive) early March, I had several challanges.
One of them was to find the alternative application for CragisNotifica that works for Windows Phone 7.
IT took me a while after trying several ones and bought others, the alternative is here .... Read more >>>

Monday Mar, 19, 2012 0:0
Mar 16

My VBA function lib online

I started these days uploading my own VBA function lib to my website.
You can find them by search for VBA function
These are the actual tools that I am using in my daily VBA programming in Excel (and sometimes in Classic ASP). Let me know if you have any question regarding any of those.

Friday Mar, 16, 2012 0:0
Mar 13

1st own Server

I did it, I have now my own server, that is online, expandable to multiple sites, fast, and linked to certain IP.
IT took me around two months (actually around 36 hours) of trial and error attempts to work around the limitation of my ISP along with some resources online. Read more >>>

Tuesday Mar, 13, 2012 0:0
Jan 9

NirSoft a new set of helpful small utilities

I just love these tiny applications, I always loved them, they are so powerful and in the same time small and quick.
They are focusing on one thing and they do it very well. Today, I found one of these websites made by a developer to list all his applications (small utilities), his name is Nir Sofer and he was online for a while now, good job and I will keep an eye on you Nir. Read more >>>

Monday Jan, 9, 2012 0:0
Nov 26

My own HTTP server on Win7 ... finally

After few days of trying and failing, I managed tonight to have access to my own server, it is actually a folder on my own laptop that I can access using an IP address+Port.

It was indeed one of my oldest dreams, to get my own server, I don't have one yet, but I know how to do one, I was lost among the IPs, ISPs, DNSs, and stuff like that until made it.

The trick was that my ISP was blocking the port 80, so I have to add another port to my Firewall, then add a port forward in my router firewall (Since I am behind a router) to have access to it.

Check my free subdomain linked to my ip here Read more >>>

Saturday Nov, 26, 2011 0:0
Oct 24

DX-Ball game

I had this game since 2001, one of my clients in File1 gave it to me, He said that you will love it, at that time I was kind of away from games and consider them a waste of time (I still feel that sometimes) however I became easily addicted to it, not only me, other friends and customers were easily addicted to it.

It needs no setup at all, just unzip and play
Download it from here
Read more >>>

Monday Oct, 24, 2011 0:0
Oct 30

Free File Sync

After few searches, I got it, it is kind of have-it-all software with easy UI.

It is called FreeFileSync, HomePage

Read more >>>

Saturday Oct, 30, 2010 0:0
Aug 8

Another great application

Now this is another one, TreePad Lite

It looks like I am going to buy the full version, it has a lot of features

Read more >>>

Sunday Aug, 8, 2010 0:0
Aug 5

Finally find it - LaunchBar Commander

It has been a while since I last explored and application, and when I do, I find the best one I was looking for.

It is LaunchBar Commander from

Read more >>>

Thursday Aug, 5, 2010 0:0
Jul 15

Even my bugs are new

I am facing an issue now

Even the bugs I am facing are new too.

After I have installed VS2010, My Excel2007 started to crash several times in one hour, this started to be flustrating, I need to see if VS2010 is the issue and solve it.

Read more >>>

Thursday Jul, 15, 2010 0:0
Jul 9

Visual Studio 2010

This one sound promising!!

The previous one I tried (was Visual Studio 2005) was tough to jump into, since I needed to try the ASP.NET, It was hard to jump from Classic ASP into ASP.NET of VS2005.

Read more >>>

Friday Jul, 9, 2010 0:0
Jun 26

New Clipboard software

This one sound promising, it has up to 25 slots for the clipboard plus easy to paste method.

It worth a try

Saturday Jun, 26, 2010 0:0
May 22

Installing Windows Home Server

It was kind of slow, but it did installed on my P4 computer.

It has only 504MB of RAM, and installed and running kind of smooth.

I was also successful in sharing hard drives/Printers along with adding new hard drives to the server.

However, I wanted to do the Remote Sharing, but it is not working, I might need to replace the router to do that, let me see.

Saturday May, 22, 2010 0:0
Apr 4

IT experience

I dont know what is happening? It looks like the years are marking up into my experience. After few tries, still cant get this computer to work. Windows 7 is harder than I thought regarding IT and changing hard drives Read more >>>

Sunday Apr, 4, 2010 0:0
Apr 20

Software cannot live without

Here is a list of software I can not live without:

  • Microsoft Excel, Purchase, Spreadsheet
  • Microsoft Outlook, Purchase
  • AVG Anti-Virus, Free
  • Avast Anti-Virus, Another free AntiVirus that will enjoy it on your desktop
  • TrueCrype, Free the best free encryption application out there
  • CONVAR Free Data Recovery, Recover your files for free
  • KeePass, free password list to save your list of passwords
  • nero, Purchase or comes free with some burners
  • NetNanny, Purchase, Family filter application that worth every penny.
  • Norton Ghost, Purchase, Image cloning, powerful, easy
  • MagicISO, Trial, ISO creator, editor, you can do 135 CD with no need of purchase.
  • 7Zip, Free, Easy Compressor that open every archive
  • Google Chrome, Free, wao, that is a quick browser
  • Mozilla FireFox, Free, Powerful browser
  • MySQL Query Browser, Free, MySQL Browser to do everything you need on your daily MySQL stuff
  • Filezilla, Free, FTP Client, I cannot believe it is free
  • PrimoPDF , Free, PDF Printer
  • Ant, Free web movies downloader, to download any movie shown on the webpage.
  • Gimp, Free, who needs PhotoShop?
  • Macromedia Captivate 2, Purchase, and not Adobe Captivate
  • Read more >>>

    Monday Apr, 20, 2009 0:0
    Feb 20

    TrueCrypt, encryption application

    The best encryption software I have found during my 12 years with computer (Since 1997)

    I spent sometime (around 4 years) with safe house application called SafeDisk, it was great, enables you to create logical encrypted disks.

    < Read more >>>

    Friday Feb, 20, 2009 0:0