Issue
How can I send the Fund Transfer Data file to the new accountant by Email? The email bounced back saying there is virus.
Cause
Symantec cloud anti-malware detects the embedded VBA macros as malware and blocks them.
Resolution
Sending the File
- Unzip the fund transfer data
- Open a file named ExcelLoader
- Click on Enable Editing and Enable Contents
- Manually confirm that all the data flows through to the spreadsheet
- Click on Info
- Unprotect all of the spreadsheet's tabs
- Save the spreadsheet as a macro-free version
Receiving the File
When the new accountant receives the file, download a blank new Excel Fund Loader.
Copy each tab from the file received and paste into the new Excel Fund Loader.
Refer to our knowledge article, How to copy and paste in an Excel Transaction Loader for tips.