repair excel

3 Handy Methods to Batch Add a Prefix to Multiple Cells in Excel Worksheet

If you would like to batch add a specific prefix to multiple cells, you can refer to this article. Here we will introduce you 3 easy methods. Each has its own pros and cons. You can choose one as per your needs. At times, you may need to add a specific text to the beginning …

3 Handy Methods to Batch Add a Prefix to Multiple Cells in Excel Worksheet Read More »

How to Call a SQL Server Stored Procedure from Excel VBA

Data on a server can be modified by examining the records ‘client-side’ in Excel VBA, changing them as required, and saving them back to the server. A more efficient way of doing this, particularly if the database is at a remote location and there’s a lot of traffic involved, is to do the work ‘server-side’. …

How to Call a SQL Server Stored Procedure from Excel VBA Read More »

error

Enjoy this blog? Please spread the word :)

LinkedIn
Share
RSS