![]() Save the template document with a new name: Highlight and delete the remainder template below your final NamedAP ![]() Word will position your view to the last entry that the macro updated SFname = “C:\Users\Public\Desktop\FindAndReplaceTable.docx”Ī message will appear when the process is completeĨ. ![]() Windows users need to replace the text to something like: MacOS users need to change USER to your username Make sure it points to the modified FindAndReplaceTable.docx document on your desktop 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |