Some time ago, a client contacted me complaining that he could not open the report I sent him because it was blocked by the operating system. Indeed, I recently read a rumor that Microsoft plans to replace VBA with TypeScript macros in the recent future because they pose a security threat. It means that all files containing VBA code, downloaded from the Internet, are now blocked. How to solve this problem?
CRM (Customer Relationship Management) represents the concept of managing relationships with potential and existing clients, customers or consumers (depending on what and to whom we sell). Its task is to obtain new and retain existing clients. Although there are plenty of software that very well support the CRM concept, when you are a beginner in business you do not need anything more than Excel.
We meet the hyperlinks every day while surfing the Internet, and they have long time ago become part of Office applications. In Excel, this is often an unfairly ignored functionality. In addition to allowing you to go to an Internet presentation or write a letter to the specified e-mail address, a link can also be used to create a new document or position it on a prefix in an existing document.
Macros represent short programs that the user mostly does not write, but are automatically generated by Excel. Their role is to automate frequently used procedures, and more ambitious users can use them to develop applications with the powerful Visual Basic for Applications (VBA) programming language. In this way there are almost no things that can’t be done in Excel, so it becomes a development platform.