ANmarS - Search results

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

47 Blog posts tagged with programming


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

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 :-)

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
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
Mon
Apr 1
2013

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
Tue
Feb 19
2013

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
Thu
Feb 14
2013

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
Sat
Feb 9
2013

Sites transfers and moves

Spent few hours (when was trying to fix one of my clients email issues) into moving most of my sites to my own server.
This was prepared for few weeks now, in addition to my client sites, I also moved File1.net, DCave.com, TrioCouture.com, VBAXLMan.com. Most of them were linked to this site.
The new challange now is to host email server on my own and start providing email services.

Saturday Feb, 9, 2013 0:0
Sun
Dec 2
2012

VBA, SQL IKM tests

During of a the process of applying to new position in downtown Chicago, I had to do some tests in IKM, I am not sure how widely used these test, but they were kind of hard and tricky, one of them (the one I am proud of) is in VBA.
This is the result of it, it looks like I am an expert in Excel after all these 15 years

Read more >>>

Sunday Dec, 2, 2012 0:0
Tue
Nov 27
2012

At least 1 phone call a day for new position

This is realy exciting, I have been called for a lot of jobs now, it looks like the Resume I updated did kick off after all.
For the last two weeks I recieved at least one phone call a day for new position here in Chicago greater area Read more >>>

Tuesday Nov, 27, 2012 0:0
Sat
Oct 6
2012

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
Wed
Aug 29
2012

Pagination in Excel 2003 when showing more than 65,536 rows

I have been busy these days in a very interesting concept. The system we are building is limited to Excel2003 only, and cannot be moved (yet) to Excel2007 or later.
That have been said, we have a lot of reports that pull data from Oracle database using SQL query that may (or may not) exceed the limitation in Excel2003 of 65,536 rows. So the approach followed was to add some piece of code that makes it fit. Read more >>>

Wednesday Aug, 29, 2012 0:0
Mon
Apr 2
2012

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
Sun
Mar 25
2012

Excel VBA 2011 for Mac

This is the first project I got to work in Excel 2011 for Mac.
I knew I had to do something there somewhen, and here it is.
The project called "Macrijan" and it is for "Intillijury", I need to either buy a Mac with Excel2011 or Install Mac as Virtual machine.
I already learned some new stuff regarding the path and hard drive names, and need to update my functions I had for few years now (mostly FixPath, GetPapa and GetSon).
However, I still got a lot to learn, this link can help in that Rondebruin.nl Mac

It is going to take a while, but I am up to the challange.

Sunday Mar, 25, 2012 0:0
Fri
Mar 16
2012

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
Tue
Mar 13
2012

1st own Server

Finally...!
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
Fri
Feb 17
2012

Sometimes bad news are actually good (VB6 on Win8)

Windows 8 will suppurt VB6 (As this article 6 on 8? Will VB6 be supported on Windows 8? Yep (mostly)! says).
Sometimes the bad news here are actually good, it means we can still be alive for at least 7 years from now (up to 2019), even though the VB6 is kind of old, I guess Microsoft still stuck with it since most of VBA platforms are in VB6 and most of them are actually running entire organizations.

At least this is my openion.

Friday Feb, 17, 2012 0:0
Wed
Jan 25
2012

Faster SQL

After few months of working in ANmars.com (also ANmar.us) I notice that the home page is kind of slow.
So I give it a thought and decided to go a head and update my SQL commands in the home page only to be faster.
Basically what I did was combining all home page SQL commands into one (actually two) instead of the way it was executing (was executing around 15 SQL commands).
Read more >>>

Wednesday Jan, 25, 2012 0:0
Mon
Jan 9
2012

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
Tue
Dec 27
2011

Updates to Folder8

Some updates were made to Folder8 during recent few days.
After I received our family videos from Baghdad (with tons of old family photos)

I decided to share these videos with family. I have to admit I built Folder8 having that in mind. Read more >>>

Tuesday Dec, 27, 2011 0:0
Wed
Dec 14
2011

SQL fx

I had to notice that having a lot of tags in my Questions and Answers causing a delay in reading that page.
Blog tags mechanism had different approach, but tags for Questions and Answers are kind of wider and open for more in future. Read more >>>

Wednesday Dec, 14, 2011 0:0
Sat
Dec 3
2011

Own server attempt failure

Attempt failed to establish my own server.
I was looking to a simple cheap easy-to-follow method to create my own server hosting my own website(s) on one of my machines, but it failed.
It is clear that the DNS/IP/CNAME settings where I don't have any experience in were the main thing against me. I tried to avoid that using No-IP.com or DNSExit.com with something called "cloaking" to stop showing IP to end user, but it wasn't what I am looking for. Read more >>>

Saturday Dec, 3, 2011 0:0
Tue
Nov 29
2011

Website Pointer

I had to learn this technique, linking two domains to one actual site, not redirecting.

And after few searching, I got it and finally linked ANmar.us to ANmars.com.

That was joyful and promising, now I just need to remember how to do it to link Alwa7.net and Alwah.net to Alwa7.com after it is ready to be used.

I might also revisit that procedure and generate screenshot for it, sounds a very good idea now.

Tuesday Nov, 29, 2011 14:25
Sun
Nov 20
2011

Adding testimonials

After few days of ideas and thoughts, I added my all testimonials to my site (ANmars.com) with a small slider at home screen, still need to add the "Testimonials" page, which will be in few days.

Sunday Nov, 20, 2011 0:0
Mon
Oct 3
2011

CSS DateStamp

Obviously I spent some time on CSS these days, during my efforts to update my site and adding Blog and some nice Date stamps. I did search the net for nice ones
Read more >>>

Monday Oct, 3, 2011 0:0
Sat
Oct 1
2011

Now we need to read Facebook feeds

After importing my old blog posts into the new one, I just turned into reading my Facebook posts, I did post there some posts and links that I want them to be on my site too. Read more >>>

Saturday Oct, 1, 2011 0:0
Sat
Oct 30
2010

Alwah is ranking up

After few months now, it looks like Alwah is going up.

The Alexa rank is now 700,000+

And the Google PR is 3.

Read more >>>

Saturday Oct, 30, 2010 5:26
Mon
Aug 16
2010

More free time

For the first time in three months, I feel that I have some time to do my own projects.

The main client who used to fill my time up with work for the recent three months has not contacting me since 5th of August.

Read more >>>

Monday Aug, 16, 2010 0:0
Mon
Jul 19
2010

Hacking attempts on File1.net

They have been trying that for a while but after some attempts they could access the database.

File1.net my first website faced a hacking attempt.

I liked that, that proves that the website is grabbing some visitors now, and it is becoming more and more popular.

Read more >>>

Monday Jul, 19, 2010 0:0
Mon
Jul 12
2010

multiple tasks / projects again

It is that time again, I do love these days of multiple projects dues and work need to be done.

Read more >>>

Monday Jul, 12, 2010 0:0
Fri
Jul 9
2010

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
Wed
Jun 30
2010

Shukran' s blog

Shukran is now has her own blog, it is here Shukran's Shake and it took me longer than I planned due to some changes in the template.

Anyhow, I am learning new stuff doing all these blogs, and will be doing more soon.

Wednesday Jun, 30, 2010 0:0
Wed
Jun 9
2010

Need some rest

After some busy days and good/bad time management, I need some rest, It was a busy week, with lots of new projects (at least now I have 4 need to deliver next week).
I kind of like it, this projects traffic, but it looks like I do have some limit.

Read more >>>

Wednesday Jun, 9, 2010 0:0
Mon
Jun 7
2010

Web development - structure diagram

This is a very good diagram that shows how the web developing and related design knowledges are structured.

Check it out, it is very helpful to understand it. Read more >>>

Monday Jun, 7, 2010 0:0
Sat
May 29
2010

Documenting programming

Now that is another story, I already know that Programming is the easy part, documenting what the programmer does is completely another tough part.

It is again happend, I have to do the documenting for the ACuSys system, it is taking me a lot of time, and need to remember a lot of old stuff I did and why I did that.

However, the client is happy with it and might have some new chances in the future to do more like these.

Saturday May, 29, 2010 0:0
Tue
May 25
2010

Customer Feedback

These are just few lines I got today in the email for the recent project work I was busy with. We had really rush time and low info to do what we done, however, we did it after few missing deadlines. See the full article for the customer feedback.

Read more >>>

Tuesday May, 25, 2010 0:0
Wed
May 19
2010

New ANmars.com

After doing some searches, I found the design I am looking for.

It is more like me, and attractive.

So, after buying it, started to implement. this process will take a while.

Wednesday May, 19, 2010 0:0
Mon
May 17
2010

Another daughter blog

Now my eldest has her own blog, using the same old skin

AMI's 964

Which using the same engine I talked about earlier.

Monday May, 17, 2010 0:0
Sat
May 15
2010

Advancing needs more Aggressive Rules

Advancing needs more aggressive rules
It is true, I tried it and still doing it all the time.
Meanning, that if you want to advance in any subject, you have to got some rules that are more aggressive than usual

Saturday May, 15, 2010 0:0
Fri
May 14
2010

DCave is coming soon

That is it....

DCave is coming soon, I spent a lot of my recent time working on VBAXLMan.com, now after I have bought DCave, I will move to it.

Why DCave? that is another story, read the full article to know.....!!

Read more >>>

Friday May, 14, 2010 0:0
Wed
May 12
2010

New Captcha

It looks like sometimes the complicated solution (advanced one) will not be as effictive as the simple cheap one.

I was used to reCaptcha for a while now, even though i am facing some spam recently though that.

So I am changing to a simple one, after few searches, I got this one.

It is stupidely simple, let me see if it will work and prevent the spam or not.

Wednesday May, 12, 2010 0:0
Sun
Apr 4
2010

New projects

There is a chance that I got new project in VB.NET with connecting to database. cross the fingers

Read more >>>

Sunday Apr, 4, 2010 0:0
Mon
Apr 20
2009

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
    Tue
    Mar 10
    2009

    Busy, busy, busy

    I like when I get busy, but I hate neglecting other projects as well, I am busy these days with some projects:

    Read more >>>

    Tuesday Mar, 10, 2009 0:0
    Fri
    Feb 20
    2009

    ASP blog system

    I liked this blog system, so I decided to use it as my blog site
    It is called Forest Blog, and it is rather simple and got the Categories feature along with multi user
    Just exactly how I wanted it Read more >>>

    Friday Feb, 20, 2009 0:0
    Fri
    Feb 20
    2009

    I did that, why don't you believe me?

    It happend again

    Why people can not believe that I did my website File1.net on my own?

    From scratch, in ASP and MySQL using my background in VB with some help from online tips and forums

    -------------------------------------
    Do I look like someone who can not do something like this?
    -------------------------------------

    Read more >>>

    Friday Feb, 20, 2009 0:0