Archive for the ‘General Tips’ Category

Opening URL @ new tab in Internet Explorer: VBA

Posted: September 11, 2013 by Theodoulus in Excel, General Tips, VBA
Tags:

Problem Statement: Suppose, we have an array of URLs and we need to open them one by one. By looping over all the URLs on the same tab at internet explorer, we need to check the internet explorer is in LOADED or LOADING state. If the explorer is in loading state, it may give an error. And by default, the URL will be opened on the same tab.

So the process of opening URL on the same tab will be lengthy in terms of Coding, and processing time.

Solution:

We can use different tabs of the Internet Explorer so that we would not have to check the READYSTATE and to REFRESH the tab again and again. The example is given below:

Option Explicit

Sub OpenURLOnNewTab()

    Dim lngC As Long
    Dim strUrl  As String
    Dim ieObj   As InternetExplorer

    Set ieObj = New InternetExplorer
    ieObj.Visible = True
    strUrl = "https://usefulgyaan.wordpress.com/"       'We have taken one URL but you can take an array of URLs

    For lngC = 1 To 100
        ieObj.Navigate2 strUrl, 2048            '2048 is to open the URL on the new tab
    Next lngC

End Sub
Advertisements

Creating Powerpoint Slides: Rules

Posted: May 17, 2013 by MaxFraudy in General Tips, Powerpoint
Tags: ,

I recently came across some very poorly made presentations which prompted me to create this deck. It has some rudimentary pointers that need to be kept in mind while creating powerpoint slides.

 

 

 


We send so many mails everyday that sometimes we forget to attach files or add subject line. Here we have a macro that solves both the issues.It prompts the user if:

  1. subject line is missing or
  2. there are words like enclosedattached and PFA in message body but attachment is missing

To add this macro in your outlook go to Tools -> Macro -> Visual Basic Editor or just press Alt+F11 and paste the macro in ThisOutlookSession.

Subject Line or Attachment Missing_1

VBA Editor in Outlook

(more…)


Re-creating Custom Charts

Re-creating Custom Charts Can be Frustrating

Excel provides us with many chart types and those of us who work with data representation or create dashboards know that they are not enough. We do need to create custom chart types every now and then to satisfy specific needs. At the same time, some of these custom charts are so frequently used that it becomes frustrating to re-create them each and every time. But don’t worry, Microsoft is considerate enough to provide a solution to this.

(more…)

Excel Shortcuts to Speed up Calculations

Posted: May 2, 2013 by MaxFraudy in Excel, General Tips
Tags:

Although it may sound cumbersome to remember keyboard shortcuts for Excel actions, it really does save a lot of time that is otherwise spent on moving between menus and finding various options. Also, once you get started, then you realise that you had been wasting precious time with the mouse. Why don’t you memorise some of the shortcuts below and see if you still disagree.Person typing on a keyboard

Action Shortcut
Select entire column of active cell [Ctrl] + [Space]
Select entire row of active cell [Shift] + [Space]
(more…)

How many times have you needed to copy the path of one of your opened files and you had to go all browsing through folders to get it?…. Many, right? What if you could get it without having to go anywhere else? Sounds lovely, doesn’t it?

Well, you actually can do it without much of an effort. Simply follow the steps below and you are set:

  1. Go to ‘Quick Access Toolbar’ (QAT) that appears in all MS Office files.
  2. From the dropdown, select ‘More Commands’

    QAT - More Commands

    QAT – More Commands

  3. In the pop-up that appears, Go to ‘Customise’ tab
  4. In the left dropdown, select ‘All Commands’

    Untitled

    All Commands in ‘Customise’ tab

  5. A long list of available options appears in the box below. Scroll down and select ‘Document Location’.
  6. Click on the ‘Add’ button.
  7. Click OK.
  8. The option will appear on the right. This is the list of commands available to you in the QAT.

    Untitled

    Available Commands in QAT

That’s it!!! Now the location of any document that you are viewing can be seen right at the top.

Tip: If there are any other commands that you use on a frequent basis, then they can also be added to the Toolbar. Simply right-click on that option and select ‘Add to Quick Access Toolbar’.

QAT - More Options

QAT – More Options

For more options, check out MS Office Support page