I’m not a Mac expert, so I don’t know what else might be causing the problem.
One of the affected people is running Catalina (10.15.3) and Excel for Mac 2019 (v16.35 - the latest update as of today’s date).
Would anyone here happen to have any ideas? I thought about it being a permissions issue with writing to the above folder, but I had one of the affected people check the permissions of it, and they said it is set to ‘Read & Write’ - so that doesn’t appear to be culprit. But a few people are reporting the error, and I don’t understand what might be causing it. Also, many other people are using the workbook with no problems. Once verified, look for a healthy and restorable backup. On all the Mac’s I have tested my workbook on, it works fine. Excel spreadsheet is corrupt: If none the above factors have not caused hindrance in saving the file, then there may be a probability of corruption in the Excel spreadsheet. (My code creates a new folder inside the Data folder, and then saves an Excel file into that new folder.) But my code is written to save the file in a particular folder that should always be accessible by Excel, regardless of the sandbox limitation: I know that starting with Excel for Mac 2016, Excel is “sandboxed”, meaning you cannot save files wherever you want via VBA code. It only seems to happen on Excel for Mac 20. It does not appear that this error occurs on Excel for Mac 2011. Run-time error ‘1004’: Method ‘SaveAs’ of object ‘_Workbook’ failed. For a few people, when this moment occurres, the VBA code in the workbook generates an error. One of the things the workbook does is save a separate Excel file on the user’s computer in a very specific folder, the first time the file is opened on that computer. Thus, I am struggling to figure out what’s causing it. However, a few people on Mac are reporting an issue that I cannot reproduce on any of the Mac’s I have access to.
I released the first version of the file publicly back in November, and for most people, it is working fine. I’ve created a Macro-Enabled Excel workbook for using on Excel for Mac & Windows. You may click to see the features of PDF to Excel Spreadsheet Converter for Mac.This is my first time posting on this forum, and I'm not sure if this is the correct place to put this.
The article has shown you how to convert tabular PDF to Excel spreadsheet on a Mac computer. Then the tabular data are successfully exported to an Excel file by PDF to Excel Spreadsheet Converter for Mac. The final step is to click the button Save and choose the target format as Excel File in the Save dialog. Click the button to draw a rectangle and then the text in the in rectangle will be extracted and displayed in the panel under the page view area as shown in the above image.Ĭlick the button and then you can draw vertical lines in the rectangle, the words on the two sides of one vertical line will be separated to two adjacent columns as you can see in the image. To export the tabular data in the PDF, you should specify the text to process. Use the zoom buttons to zoom the page displayed in the interface. To navigate other pages, please use the arrow navigation buttons. The PDF page outline will be instantly viewed in the left panel of the interface, and the current page will be displayed in the upper-right panel of the interface. In the interface, click the button Open and open o PDF. The following words introduce the steps of converting tabular PDF to Excel. Run the application, and you will see the interface as displayed in the following image.
After the installation, you will see it in the Applications of the Mac OS X system.
The application PDF to Excel Spreadsheet Converter for Mac is free for evaluation and you use it for free within limited times. If you need to deal with the data in editable spreadsheet applications, you may convert the tabular PDF to Excel spreadsheet format with PDF to Excel Spreadsheet Converter for Mac.
Many tabular documents such as reports, invoices and contact information are stored in the popular PDF file format. PDF to Excel Spreadsheet Converter for Mac is developed for converting tabular PDF to Excel spreadsheet in Mac OS X. PDF to Excel Spreadsheet Converter for Mac