Does anyone have experience with using a macro-enabled Excel spreadsheet into the line level of Acumatica screens? We have a macro-enabled spreadsheet we use for estimating and would like to use it to load in the detail lines of a quote and are receiving an error message.
Does the error message happen to say something about the file type not being permitted?
Have you added the file extension as a permitted file extension in File Upload Preferences?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/cd8ef657-4cba-42fe-aeaf-76fa5c2e1b69.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9d55018f-7537-4d29-a599-e78420df7602.png)
We save the file as a .xlsm file type:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/0de56b61-d69c-46e3-be6d-a364fea2be5b.png)
We are uploading to a Sales Quote using the file upload button:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/161e4e0a-bd22-42d9-bfae-2791cf6fdee0.png)
This is the error message we receive after trying to upload:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/af986b98-e0b4-4b40-bba0-9889cdb262b5.png)
Any thoughts or insight would be helpful. Thanks!
I’m guessing this is a code restriction placed on the Upload action. I’m not sure this is the exact code causing it, but I have found code indicating the allowed file types for this action:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/f3974bc2-4495-41ac-ab55-300e482b7189.png)
Thanks
Any chance that someone else knows of a way around this situation?
Hey
May or may not be helpful, but when I make various Excel tools I’ll add an “Export” button that copies whatever sheet I want to upload and let’s you save it as a separate .xlsx file.
Here’s the VBA I use, hopefully it’s of some use:
Sub MacroNameHere()
'
' MacroNameHere Macro
'Copy sheet to new workbook, save workbook and close it
Sheets("Name of the sheet you want to upload").Copy
' ActiveWorkbook.SaveAs "Location and name.xls"
Application.Dialogs(xlDialogSaveAs).Show
ActiveWorkbook.Close
End Sub
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.