ANmarS - Search results

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

4 Blog posts found in year 2015


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
Thu
Feb 26
2015

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
Sun
Jan 11
2015

DB restoration

I am not sure if the hacking attempt late last year or I messed something up while using my Excel-based website admin, my DB was messed up and I had to spend around 3 hours to clear and restore.

I really need to finish that Excel-based DB autobackup application soon.

Sunday Jan, 11, 2015 0:0