ANmarS - Blog

Excel/VBA expert since Sep 1997 (19 years 6 months)

Recent Posts

Wed
Oct 26
2016

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
Tue
Oct 25
2016

Easiest way to unprotect Workbook or Worksheet without password


Looks like there is a bug in new Excel dealing with old Excel files
Tried that several times and it worked every time, it did actually remove the password for protected view of Worksheet and Workbook, it did not remove the protection, just the password.

So, If you have xlsx or xlsm with Workbook view or Worksheet view protected, do the following:

  • Save it as xls
  • Save it back as xlsx or xlsm
  • Now try to unprotect workbook or worksheet
Read more >>>

Tuesday Oct, 25, 2016 8:40
Mon
Jun 13
2016

Numbers to Arabic (online free ervice)



This is the online version of SpellNumber that is directed to Arabic speakers
As some of you might already know, I did the SpellNumber back in 2007 even though I added to my website in 2012.

Now we can have the similar but as online version.

This is the actual function Num2Ar Read more >>>

Monday Jun, 13, 2016 11:38
Mon
Jun 13
2016

My new business cards

After seeing the re-action to my old business card

I thought it is time to push it a little further and we fix some issues with the old one.
So here is the new one that am going to use once it arrive :-)

More LinkedIn

I am targeting more posts to put on LinkedIn
Seeing the reaction I am getting from posting in LinkedIn, I am going to put more and more posts on LinkedIn, then post it here too This way I can drive people to my website, and at the same get some exposure.

the thing is that I need to spend more time in cleaning and creating the image for that post, it is not just writing :-)

Monday Jun, 13, 2016 10:29
Mon
Jun 13
2016

Alwah again?

Looks like we are back to Alwah
I am getting some time now to get back to Alwah.net, it has been few years since I stopped that website and lost all these clients, not a good start.

However, I am back now and this time is not going to be stupid as last time

Monday Jun, 13, 2016 10:27
Wed
Apr 27
2016

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
Mon
Apr 18
2016

CTRL+K,C



Comment un-comment lines quickly in VBE

Visual studio has CTRL+K, C and CTRL+k, U (keeping CTRL down, and pressing K then C or K then U) to comment and un-comment line or lines

VBE for VBA does not have that.
Read more >>>

Monday Apr, 18, 2016 13:26
Mon
Sep 21
2015

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
Fri
Aug 21
2015

IraqiNames or ArabicNames in Bootstrap

A long past due project that comes to life within 3 weeks.
IraqiNames.com with flexibility to add new names by users, add transliterations and name means.
I admit, I am having some free time. Read more >>>

Friday Aug, 21, 2015 7:36