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.
Uploading Macro Enabled Excel Spreadsheet
+12
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?
Userlevel 4
We save the file as a .xlsm file type:
We are uploading to a Sales Quote using the file upload button:
This is the error message we receive after trying to upload:
Any thoughts or insight would be helpful. Thanks!
+12
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:
Userlevel 4
Thanks
Any chance that someone else knows of a way around this situation?
Userlevel 5
+1
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.