Thursday, 19 April 2018

How robot draws a picture | Robot drawing sketch | Sketching Robot

Hi Guys,

I was working on a fun project, how to draw a picture using a robot.

Here you can see the magic.




Note :

  • The workflow is created using UiPath RPA software
  • Robot reads the coordinates of the picture and points the coordinates in Paintbrush to recreate the picture.
  • I will share the workflow and logic in a different video very soon.


Thursday, 5 April 2018

Top Excel VBA Macros Interview Questions & Answers - Samples from a hiring expert



I spent 11+ years of my career in Excel and VBA before moving to newer technologies. I used to hear from lot of people (even VPs & top leaders) that Excel is going to get outdated. Funny part is, I've been listening the same words again and again past 10 years, but nothing happened.

Excel is still a primary tool for data analysis and reporting and we cannot avoid VBA when you talk about Excel. I see that it will still have an important role for at least next 10 years as we don't have an alternative available which provides simple way to get complex things done.

I would like to share some Excel VBA Macros Interview Questions & Answers, which I had used to conduct technical interviews behalf of my clients to hire candidates for them.

The Questions has been prepared keeping in mind to evaluate the candidate's depth of knowledge in Excel VBA. This question bank is helpful for both Interviewee and Interviewer as it provides a quick channel of questions and answers covering major topics of Excel and VBA.

If you are a beginner in Excel VBA, I would not suggest this for you. Because in most of the cases the interviewer will not stop asking questions by giving a one line answer. He may ask you to describe more about the facts of the topic he asked to understand how good you are in the tools.

Kindly share the feedback in comments or contact me directly macromatician[at]gmail.com

I will be updating more when I have time. Click on the below links to go to each pages.

Pages:
1. Excel VBA Macros Interview Questions Part I - 10 Questions
2. Excel VBA Macros Interview Questions Part II - 10 Questions



How to get computer name using VBA Excel MS Access/ VBA code to find the computer's name





Sometimes you might require to find user's computer name various scenarios like to track which computer has accessed the file or database, etc.

We can find the computer's name using below VBA code.

Function FindComputerName() as String
      FindComputerName = environ(6)
End Function


Note: Copy paste above function to your module, You can use it as an Excel function or call from a sub procedure.

Friday, 2 February 2018

How to Create a Notepad diary / Notepad Scheduler / Notepad Logbook

Here are the simple steps to use the Windows Notepad as a simple digital diary /  Scheduler

  1. Just open the Notepad and type .LOG on the first line and press enter.
  2. Save the Notepad file with any name of you want.
  3. After saving it, Close the Notepad and open it again.
  4. Surprisingly you can see the current date and time being inserted automatically after the  .LOG line.
  5. Now write your daily/hourly activities easily in the next lines
  6. After that save the file & Close
  7. When Your open that file next time, you can see current date & Time in the next line again automatically

Note : If you want to bring the current date and time just press shortcut key F5, Its another option

Monday, 15 January 2018

A Great Milestone - 400,000 visitors

It's great to start 2018 seeing 400,00 visitors to my blog.

I started this blog as a back up of day to day work in 2010. 

Then later I decided to make my posts public in 2012 so it can be useful to others as well. But the busy work schedule has blocked me from spending time on this. 

I was completely away from this blog for couple of years.Thanks for your mails with suggestions and requests. As per your demands, I will be sharing more resources to learn and master VBA Macros and other technologies as well.

If you like the posts in my blog, kindly share the posts with your friends in Facebook, Google+, etc.