Home > Excel Reports > Delete Report > Fineline
Delete Report - Finelines
Below are the steps to delete all the Finelines not being used. No SKUs are associated with these finelines anymore.
Stores with Secure Access will not be able to paste in the macro, you'll need to build the macro manually which is different than typing in the macro.
File Prep (A)
If you haven't already, Enable Editing and Enable Content
Delete any rows you wish to exclude
Click the button in the header called "Export Fineline for .txt file"
The file is automatically prepped and needs to be saved. Save location defaults to your Desktop.
Close out of Excel
Network Access Import (B)
In Eagle Browser, launch Network Access (NA)
Type MFI into the function line, press Enter
In the upper left of the screen, click Options -> Keys -> Programmable Keys
Find a blank Programmable Key, I'll be using Ctrl F8
Click the ". . ." button and find the .txt file you exported earlier in step A.4, click on the file then click Open
Select the following without the asterisks (*) into the Macro Definition box: *{Column 1}{BREAK}{F6}{F6}{F12}*
Right-click in the Macro Definition box and select Paste. **If you are unable to Paste the macro, this is because you have Secure Access. Please see the "Building the Macro for Secure Access users" below.
Uncheck the box saying "Macro playback follows keyboard focus"
Click Ok
Press F12
Run your programmable key: Ctrl + F8 or the one you chose
This could take several minutes to run. The screen will stop flashing when complete then close out of Network Access
Pat on the back, congrats! All Finelines are deleted
Building the Macro for Secure Access users
Place your cursor in the Macro Definitions box
In the upper left hand corner, click Insert -> Data File Column... -> Enter 1 -> and click OK
Press the Pause/Break key on your keyboard
Press the F6 key on your keyboard
Press the F12 key on your keyboard
Your Macro Definition should look like the image below
You can now resume the instructions at Step B.9