ANmarS - Search results

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

24 Blog posts tagged with excel


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
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
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
Sun
Jan 20
2013

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
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
Tue
Oct 9
2012

My desktop screen

It has been a while since last time I posted my screen, here they are two of them

Tuesday Oct, 9, 2012 0:0
Thu
Oct 4
2012

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
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
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
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
Sun
Jan 22
2012

XL f(x)s in Wordpress

I have to do it. And I did.
After few years of pushing the CMS away from me, I finally joined it.
Created the website XL f(x)s (I already had the domain for a while now) using WordPress, and did some updation.


No knowledge is bad, so learning WordPress, even late, is good, also after all these months of experiences of HTML and CSS, the WordPress does make sense.

Sunday Jan, 22, 2012 0:0
Tue
Jan 10
2012

New design for my business cards

It has been a while since I created new business card, it looks like I wanted to use the ones I already have here, anyways, I created new one here.



I always wanted a business card that looks exactly like an Excel screen, simple yet nice and creative

Tuesday Jan, 10, 2012 0:0
Thu
Nov 17
2011

2 Yahoo! Answers profiles

My old profile used in Yahoo! Answers was removed because what it looks like, I didn't follow some rules, but I managed to read most of my answers there, in addition, this is my profile screenshot:

And this is my new one (VBAXLMan) as of few days ago:

Back to Yahoo!Answers



Going back to Yahoo! Answers, I almost forgot why I left that piece of me there, using the same name VBAXLMan, I start answerring questions.
In the same time, I started adding all of my old answers (The ones I stored in "MyYahooAnswers.xls" file) into my website. Read more >>>

Monday Nov, 14, 2011 0:0
Thu
Oct 6
2011

Convert facebook posts to Excel

Few days ago I had that app in facebook to help me import all my facebook status posts and links into an Excel sheet.
Link to first post

The challange was to combine them both, since Get Me My Data does each type of post in a seperate process, and the one that does all wall is not alighned well.
So I created an Excel spreadsheet called fb.xlsx that does that, which is:
- Reads from the CSV generated by Get me my data into Excel sheet (both Status posts and links posts). Read more >>>

Thursday Oct, 6, 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
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
Mon
Apr 19
2010

VBAXLMan will be back

Getting back to VBAXLMan on Yahoo! Answers, starting to answer a lot of Excel questions again, and withen few days, I became a "Top Contributer" again, and got to level 6.

My Yahoo! Answers profile

Monday Apr, 19, 2010 0:0
Mon
Apr 19
2010

VBAXLMan.com is back

VBAXLMan.com is also back, will try to finish it by the end of this month.

It enables you to host all your digital work.

Monday Apr, 19, 2010 0:0