25Jun2015

Text to Columns in Excel

Text to Columns in Excel are used to split a single column of text into multiple columns. This feature is helpful when we import data from word, PDF or any other source. As the imported data may not be usable right away. We can split the text based on fixed width or split it at
  • 25 Jun, 2015
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Text to Columns,
Read more
16Jun2015

How to Browse and Select File and Folder in VBA

Browse and select file in VBA : Sometimes, we may need to work with external files in Microsoft Excel. We might need a button in excel to open windows file dialog box so as to select the desired file. To achieve this we need to write the following code in VBA editor.   VBA Code Snippet:
  • 16 Jun, 2015
  • Excel for Commerce
  • 0 Comments
  • Browse and Select File and Folder in VBA, Excel Consultant, Excel Expert,
Read more