Skip to main content
Question

Uploading Macro Enabled Excel Spreadsheet


Laura Carpenter
Varsity II
Forum|alt.badge.img

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.

5 replies

darylbowman
Captain II
Forum|alt.badge.img+13

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?

 


Laura Carpenter
Varsity II
Forum|alt.badge.img

@darylbowman I gave what you suggested a shot using the settings that were in your screenshot and we are still getting an error message.  Here are my settings and the steps we are taking to upload the file:

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!


darylbowman
Captain II
Forum|alt.badge.img+13

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:

 


Laura Carpenter
Varsity II
Forum|alt.badge.img

Thanks @darylbowman  that is helpful information. 

 

Any chance that someone else knows of a way around this situation? 


craig2
Pro I
Forum|alt.badge.img+2
  • Pro I
  • 89 replies
  • March 27, 2024

Hey @Laura Carpenter ,

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings