Excel VBA code debugging - going from Mac to PC

Encerrado Postado há 4 anos Pago na entrega
Encerrado Pago na entrega

I need a fresh set of eyes on some VBA code. I wrote some code to automate cleaning datasets (excel), analyzing them and making some graphs. The code works fine on Mac platforms but now I have to move to Windows and it is glitching.

I need someone to take a look at it and debug the code so that it runs on all platforms. It should be just a couple of hours of works. If the debugging works well, there might be a follow up project after that to refine the code and develop new functionalities.

Let me know if you are interested.

Camille

Attachments:

I am attaching three files and I am happy to clarify or provide further information about how to use them as needed:

1/ AutomationTemplate_working: my working file with the modules containing the VBA code. At this point, the four modules that I need running in Excel are CleanData, AnalysisPlan, DataAnalysis and CreateGraphs. The one glitching is mostly DataAnalysis (the code for creating pivot tables on PC is a bit different from Mac).

2/ example : provides an example of the result I expect the code to be able to produce - with CleanData sheet being the dataset, AnalysisPlan sheet on which the user can manually choose which variables to include in the data analysis, DataAnalysis in which the pivot tables are created, and Graphs sheet (in this case renamed FinalDatasheet) with the pivot graphs formatted.

3/ dataset : an example of the initial file that the code might run onto.

Coding Programação de Banco de Dados Visual Basic Excel VBA Excel Macros

ID do Projeto: #21189360

Sobre o projeto

21 propostas Projeto remoto Ativo em há 4 anos

21 freelancers estão ofertando em média $131 nesse trabalho

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mais

$250 USD in 4 dias
(191 Comentários)
7.7
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on debugging your VBA program in order to work fine in Windows will look like. Fortunately, I can show you how your job will look like Mais

$150 USD in 3 dias
(24 Comentários)
5.9
zekovicm

Hi there,I am Excel VBA/Macros expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within Mais

$175 USD in 3 dias
(12 Comentários)
5.7
bhupendrayadav

I can debug your vba code and make it work for windows. Please find below a brief introduction of myself. I am postgraduate with more than 6 years of experience in advanced excel based tools, VBA automation, google s Mais

$120 USD em 1 dia
(22 Comentários)
5.2
liangjongai

Hi, dear! I've checked your project description and I've understood the requirement. I've an experience of jobs for VBA development. Please give me chance to work with you. Ping me to discuss about your project. Thank Mais

$140 USD in 7 dias
(19 Comentários)
5.4
indrapandu

Hi, I have extensive skill and experience in Excel VBA. I can do debugging and mske sure everything is working properly in Win OS. Let's have a chat, looking forward to speaking with you.

$61 USD em 1 dia
(46 Comentários)
5.0
olaideejiwole

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Mais

$30 USD em 1 dia
(3 Comentários)
3.3
TumblingWave

Hi Camille, I can help you with this. I am an Excel Expert with experience switching between Mac and multiple versions of Windows (I have several Mac/PC virtual machines in which I can do the testing). I will be availa Mais

$133 USD in 5 dias
(6 Comentários)
2.4
vipin0110

Hi, I can complete your project in $30 within 5 day. Greeting! My name Vipin Garg and I am a software engineer (Master of Computer Application). I have 15+ Yrs. Exp. in Excel, Access & VBA Macro which is used for autom Mais

$30 USD in 5 dias
(1 Comentário)
1.9
GopalJp

This is Gopal. I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional account Mais

$250 USD in 7 dias
(3 Comentários)
1.4
ITPyramid85

Hello, I am software developer with enough experiences on C#/VB.Net, VBA for 13 years. I can work by full time for your project and trying to satisfy the requirements. Client's idea + Programmer's good coding is the pe Mais

$200 USD in 7 dias
(1 Comentário)
2.0
elmorabit90

Hello, I read your offer and I can help you. With my vast experience and my knowledge of Excel and macros, I will be able to realize this project that meets your requirements. I'm Expert in Microsoft Excel, I have 4+ Mais

$40 USD in 7 dias
(1 Comentário)
0.4
mithunchavan599

I specialize in providing Excel based solutions, including template design for reporting, interactive dashboards, business and financial modeling, application development, VBA programming, and data analysis. I provide Mais

$95 USD in 5 dias
(0 Comentários)
0.0
cooddooc

Hello, I am interested in your project, would you like to discuss further details with me! I will wait for your reply. Thank you. Regards,

$140 USD in 7 dias
(0 Comentários)
0.0
PradeepKumar2150

Dear Sir, I have reviewed your requirement and happy to say that we can easily prepare this macro file. We have 8+ years of experience in VBA (Macros) and created multiple macro files. We can deliver this project with Mais

$80 USD em 1 dia
(0 Comentários)
0.0
Amkay88

Hi I have gone through your requirement. I can help you to create a new macro for Windows. I have 10 years of experience and have sound knowledge of MS excel, VBA and graphs. Let me know when do I need to start worki Mais

$30 USD in 3 dias
(0 Comentários)
0.0
olenakravch

Hello! I've been working with VBA for over 5 years now on a daily bases, constantly learning for about 7. I work as an Automation Specialist at Market Research company, and saved it more then 32000 man hours last ye Mais

$50 USD in 2 dias
(0 Comentários)
0.0
PageOllice

Hello, I am interested in your project and would like to invite you for further discussion. Waiting for your positive reply! Regards, Page M. O.

$240 USD in 7 dias
(0 Comentários)
0.0
amaiaalustiza

I have broad experience in automating and optimizing VBA scripts on excel. Efficient and elegand solutions with multiple comments explaining the process included.

$170 USD in 7 dias
(0 Comentários)
0.0