Get Excel Spreadsheet VBA to work on Mac -- 3

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

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

Habilidades: Excel, SO Mac, Visual Basic para aplicaciones

Ver más: shift work overtime work list excel spreadsheet, vba work excel spreadsheet, freelance work vba excel, excel vba open spreadsheet start macro, vba excel spreadsheet, vba excel programmers work home, contract excel spreadsheet work, automatically email excel spreadsheet vba, convert excel spreadsheet work web page, vba front end excel spreadsheet, excel contract work vba canada, access vba open format excel spreadsheet, excel spreadsheet work bank statement, vba excel spreadsheet work, excel spreadsheet vba data entry form

Información del empleador:
( 5 comentarios ) Jaipur, India

Nº del proyecto: #12878564

6 freelancers están ofertando el promedio de $53 para este trabajo


Hi, I am good at Excel and vba in Mac. Plz provide me the excel file to understand the cause of the problem.

$150 AUD en 3 días
(335 comentarios)

Hello, I have read the job description posted by you and understood it completely. To tell more about my self: We are a company based in Bangalore, India by the name UNITEC. We are a 10 seater company and special Más

$25 AUD en 1 día
(3 comentarios)

me complete your excel work on excel spreadsheet in one day.i am new but i am expert data entry on excel spreadsheet

$15 AUD en 1 día
(0 comentarios)

A proposal has not yet been provided

$10 AUD en 1 día
(0 comentarios)
$15 AUD en 7 días
(0 comentarios)

I have a MacBook (Yosemite) with Excel 2016 that I have purchased specifically for this type of task. I'm afraid that the effort is generally not trivial, but without seeing your code I can not give you a better idea t Más

$100 AUD en 3 días
(0 comentarios)