Excel for Mac VBA Specialist - URGENT

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I have an Excel Spreadsheet that was made using Excel 2016. It uses VBA to select and import 3 txt files, unlock/lock sheets, update PivotTables, clear data, fill down formulas to the last used rows, sort and refresh data.

However, it does not work properly in Excel for Mac 2011 or 2016. It either freezes or throws a 1004 error. The Mac specific code to import txt files is already written, and works properly. I need to get the other bugs/incompatibilities in VBA sorted so it works properly in Excel for Mac.

Specifically - the issue with Excel for Mac is that when importing this data it does not import. When clicking Load/Refresh All on the Dashboard, it throws an error or freezes.

2016Jan_Monthly is the file used for import.

Must have Excel for Mac 2016 and be proficient in VBA.

Excel Mac OS Visual Basic Visual Basic for Apps

Project ID: #12893034

About the project

4 proposals Remote project Active 7 years ago

4 freelancers are bidding on average $43 for this job

InnocentSathish

Hi, Thanks for your interest to read my bid. Regarding your project: I’m a pro VBA programmer but worked very less projects in Excel Mac 2016. But I don’t think your project much complex, I could fix those errors i More

$50 AUD in 5 days
(8 Reviews)
3.1
MetaoriginLab

A proposal has not yet been provided

$50 AUD in 12 days
(0 Reviews)
0.0
rapidsoft4

Dear Sir Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. yes we have similar experience and can deliver u as u have mentioned in your requirements. we More

$35 AUD in 6 days
(0 Reviews)
0.0
nice1991

A proposal has not yet been provided

$35 AUD in 1 day
(0 Reviews)
0.0