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’. This exercise calls a stored procedure from Excel to categorise employees into age-ranges according to their dates of birth (i.e. 18-25 years, 26-35 years, etc.), without a copious...
Read more »
Many users hope to quickly resend the meeting invitation to the attendees who have not made any responses. This article will show you how to achieve it.
In my previous article – “How to Quickly Send a Notification Mail to the Meeting Attendees Who Haven’t Responded”, you could learn how to send a notification mail to the meeting recipients who haven’t responded. Similar to it, many users would like to directly resend this meeting invitation instead of a notification mail. Thus, in the...
Read more »
Where data downloaded from a database exceeds a combo box’s range, the new items are simply not shown. To counter this, the range that underlies List or Combo boxes needs to expand or contract to match the data. This article examines how to do this automatically.
It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google “Excel Developer Tab” or “Excel Code Window”.
A professional way of displaying combo boxes is to have their...
Read more »
