Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Macro 101: Convert a Workbook into a PowerPoint Presentation This macro takes the concept of using Excel data in PowerPoint to the extreme. Open the sample workbook called Macro 101 Convert a Workbook into a PowerPoint Presentation.xlsm. In this work- book, notice that each worksheet contains its own data about a region. It’s almost like […]
Macro 101: Convert a Workbook into a PowerPoint Presentation Read More »
Macro 100: Sending All Excel Charts to a PowerPoint Presentation It’s not uncommon to see multiple charts on one worksheet. Many of us occasionally need to copy our charts to PowerPoint presentations. The macro here assists in that task, effectively automating the process of copying each one of these charts into its own slide.
Macro 100: Sending All Excel Charts to a PowerPoint Presentation Read More »
Macro 99: Sending Excel Data to a PowerPoint Presentation It’s been said that up to 50 percent of PowerPoint presentations contain data that has been copied straight out of Excel. This is not difficult to believe. It’s often much easier to analyze and create charts and data views in Excel than in PowerPoint. After you’ve
Macro 99: Sending Excel Data to a PowerPoint Presentation Read More »
Macro 98: Simulating Mail Merge with a Word Document One of the most requested forms of integration with Word is the mail merge. In most cases, mail merge refers to the process of creating one letter or document and then combining it with a separate document containing their names and addresses. For example, suppose you
Macro 98: Simulating Mail Merge with a Word Document Read More »
Macro 97: Sending Excel Data to a Word Document If you find that you are constantly copying and pasting data into Microsoft Word, you can use a macro to automate this task. How it works Before walking through the macro, it’s important to go over a few set-up steps. To get ready for a process
Macro 97: Sending Excel Data to a Word Document Read More »
Macro 96: Compacting an Access Database from Excel During your integrated processes, you may routinely increase or decrease the number of records and tables in your database. As time goes on, you may notice that your Access database gets bigger. This is because Access does not release file space. All the space needed for the
Macro 96: Compacting an Access Database from Excel Read More »
Macro 95: Opening an Access Form from Excel In some instances, you or your clients may need to switch focus to an Access form. This example demonstrates how you can open an Access form from Excel. How it works With this macro, you point Excel to an Access database and trigger a specific Access form
Macro 95: Opening an Access Form from Excel Read More »
Macro 94: Opening an Access Report from Excel Access reports allow you to build professional looking reports that have a clean PDF-style look and feel. If you run and distribute a great deal of Access reports, the following macro can help automate your processes. How it works This macro demonstrates how you can open your
Macro 94: Opening an Access Report from Excel Read More »
Macro 93: Running an Access Macro from Excel You can run Access macros from Excel, using automation to fire the macro without opening Access. This technique can be useful not only for running those epic macros that involve a multistep series of 20 queries, but can also come in handy for everyday tasks like outputting
Macro 93: Running an Access Macro from Excel Read More »
Macro 92: Running an Access Query from Excel Here’s a nifty macro for those of you who often copy and paste the results of your Microsoft Access queries to Excel. In this macro, you use DAO (Data Access Object) to open and run an Access query in the background and output the results into Excel.
Macro 92: Running an Access Query from Excel Read More »
