![]() SFname = “/Users/YOUR_USER/Desktop/FindAndReplaceTable.docx” EVERYBODY will need to modify the following line of code: MsgBox (" Batch Find and Replace Operation Complete! ")Ħ. ![]() Set rReplacement = oTable.Cell(i, 2).Range Set oChanges = Documents.Open(FileName:=sFname, Visible:=False) SFname = "/Users/YOUR_USER/Desktop/FindAndReplaceTable.docx" Replace all of the VBA text with the code below Sub ReplaceFromTableList()ĭim oChanges As Document, oDoc As Documentĭim rFindText As Range, rReplacement As Range The Visual Basic Editor may open automatically, if not click Edit Open Individual AP Coverage Maps, per floor.docx Report Template Save the Word document to the desktop, retain the filename FindAndReplaceTable.docxĥ. Select the line below the existing table and Paste The table should continue, now populated with your AP Name matching Select and copy the contents of both columns as A and B for each row that column B has a value Open “Simple Incremental AP Names” Excel document In this example, we will use the My AP Groupģ. This will generate a list of the AP Names to be exposed in your report Run “Table of AP Names” Report Template in Ekahau Individual AP Coverage Maps, per floor.docx – Report TemplateĢ. Simple Incremental AP Names.xlsx – AP Name Paste spaceįindAndReplaceTable.docx – Macro Values for Find and Replace Please get on with it… How does this work? You will need to perform a little template manipulation each time you wish to run this template.Each AP that you wish to expose MUST have a unique Name.The template references each AP by Name.… and so on Can this be achieved with Custom Report Templates? I am trying to create the following visualizations: The Report output should illustrate the coverage per AP, on each floor of the building. NamedAP001 – NamedAP020 – Are physically located on the Ground Floor NamedAP101 – NamedAP120 – Are physically located on the First Floor NamedAP201 – NamedAP220 – Are physically located on the Second Floor Yet, have you wondered how to visualize and illustrate floor-to-floor Wi-Fi bleed-through using automated Ekahau report templates? Read on to learn how. We also know Wi-Fi signals penetrate between floors. We all know Ekahau Pro has an outstanding Wi-Fi reporting system that combines full customization with one-click automation – using report templates. Submit support requests & view documentation Request access to the Ekahau Partner Portal Learn more about the Ekahau Partner Program Register for upcoming webinars and watch recordings Understand potential issues and ways to resolve them Take a deeper dive into the more complex aspects of Wi-Fi ![]() Refresh your knowledge and extend your certification Learn the fundamentals of Wi-Fi and how to use Ekahau solutions World-renowned ECSE Training and Certification programs Private 5G, 4G and LTE network planning software. Wi-Fi performance analytics with automatic issue identification. Pro-grade Wi-Fi health validation & troubleshooting for mobile. Pro-grade Wi-Fi site survey tool for iOS & Android. Optimize Network Performance & Security with Simple, Step-by-Step Guides Powerful 6 GHz Wi-Fi planning and AI wireless network design. The all-in-one product suite for high performing Wi-FiĢ.4, 5 & 6 GHz diagnostic and measurement device.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |