Excel VBA – Convert Numbers to Words in Hindi Language

Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]

Read More

How to Show Full Path in Excel Title Bar?

Problem Statement: Is there a way to display complete path of the document and not just the file name in the Excel title bar ? e.g. I would like to see C:\MyExcelFiles\MonthlyBudget.xlsx in Excel title bar instead of just MonthlyBudget.xlsx In Excel, there is no setting/straight way for us to display the full path in […]

Read More

Excel VBA: Different Types Of Excel Macros

Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the most common of questions asked is “What are the different types of Excel Macros?” This is a helpful question to ask because if you do not know the different […]

Read More

How to Automate MS Excel Using Visual Studio.NET

Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]

Read More

VBA Tip: Filter An Excel Table On Multiple Columns

Filtering information out of a larger data set is standard Excel functionality but sometimes it’s necessary to fine tune the filtering to get the information you need. For example, you might have a list of customers prioritized as A,B or C. Additionally, you could have them listed by region. Something like this. Customer, Category, Country […]

Read More

How to Download/Extract Product Details from eBay Shopping Website in Excel

Excel VBA Solution to Download/Extract Product Details from eBay Shopping Website.
Many businesses use Ebay to sell surplus inventory and many individuals and small businesses use Ebay as a marketplace to make a profit. Unfortunately, the data cannot be download into an excel readable format or pasted into excel for obtaining statistics and do some analysis. This application accesses Ebay data and populates on Excel worksheet with it. It has a simple interface to allow the user to input the ebay url for the product or results that he or she wants to download.

Read More