Suljettu

VBA Macro Bug find

Hi all,

We want to find a bug in a VBA macro which use Kryon export files and xlms templates.

We have isolated a case study happened on April 1st, so I've prepared a full data folder which contains:

- Kryon extraction folders, which are used as input from VBA macros (Attivita, CBK, CPSI, MNT, SickUnits)

- Output folder, where the macro generates an output file for each region template xlsm.

- LOGS folder, with the log recorded

- "Report Operativo [login to view URL]" file, which is the configuration file used by VBA macro

- "Report Operativo [login to view URL]" file, which contains the macro "start_Import_Unattended" called remotely

- 17 files "SCHMIL_OPERATIVO [login to view URL]", which are template for every region and are used to generate the file in Output folder.

I forward you the email from our Product Owner who reports to us in detail all missing values generated by the macro "start_Import_Unattended" called remotely after generating all the Kryon files.

-----------------------------------

Like every week, some "random" data on the 17 reports are missing.

Some are common for many of the 17 reports, others only manifest themselves in some.

This has happened since the beginning of the year and often with the publication of the new week they settle down, only to reappear in a "random" way.

Below, what we found this week:

1) Common for all 17 reports

Sick units (both in % and in number) : the value of column H must be the same as that of column V

2) Report specific:

2603

#Visite S Scadute : column U should remain zero as visits not performed in the month must be charged every 4 weeks, i.e. at the change of the month.

2604

#Visite S scadute : The same, with the addition of the T column which instead should be zero

Media Tempi e NC : column H is not powered on the Mauro Opini sector

2605

#Visite S scadute : as for 2604 (columns T -U should be zero)

Sick Units : the values of the last three weeks are missing (columns s-t-u-v) both in % and numerical value

2608

Media Tempi e NC : column H is not powered on the Roberto Cesarano sector

2613

% ore amministrative (column H) total times are missing (#DIV/0!)

NC (always column H) part of the data is missing (#DIV/0!)

2614

#Visite S scadute : as for 2605 (columns S-T-U should be zero)

% ore amministrative (column H) total times are missing

2616

% ore amministrative (column H) total times are missing

2620

% ore amministrative (column H) total times are missing

#Visite S scadute : as for 2605 (columns S-T-U should be zero)

%FR totale: column H sector Andrea Zecchillo, incongruent value

-----------------------------------

I can send a zip file for whom interested.

Thanks

Taidot: Excel, Visual Basic, Visual Basic for Apps, Tietojenkäsittely, Excel Macros

Näytä lisää: vba macro excel unicode, excel vba macro paste adjacent column, next empty cell vba macro paste, vba macro trial, vba macro generate report excel word, paste excel vba macro, row column increment vba macro, vba macro click button webpage, excel vba macro databases, calling oracle procedure vba macro, vba macro perl, excel vba macro programming bids, deploy vba macro, excel 2003 paste clipboard vba macro excel, export word access vba macro, outlook 2007 vba macro export calendar pst, vba macro txt export access, export pst outlook 2003 vba macro, use information data gathered healthtalkonline case study, Hi! Small bug

Tietoa työnantajasta:
( 0 arvostelua ) Naples, Italy

Projektin tunnus: #30954535

27 freelanceria on tarjonnut keskimäärin €468 tähän työhön

(842 arvostelua)
8.9
(255 arvostelua)
8.2
(1056 arvostelua)
8.2
(459 arvostelua)
8.3
(166 arvostelua)
7.8
(67 arvostelua)
6.9
ksriniravi

Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. Please share the Workbook along with all other files- the bug report in the conte Lisää

€300 EUR 7 päivässä
(230 arvostelua)
7.1
(208 arvostelua)
6.7
AwaisChaudhry

Hi there, I have read the brief details on the job listing. You can check my experience, customer feed backs and my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I believe its a doable job I have grea Lisää

€750 EUR 10 päivässä
(4 arvostelua)
6.0
sajibdigital

"Hi, If you give me this project, I will try my best for your satisfaction. Hope you will consider me for this job. Lets discuss more details about this project."

€400 EUR 7 päivässä
(76 arvostelua)
5.8
(41 arvostelua)
6.1
(14 arvostelua)
5.7
nfnTV

Hi, dear client. I'd really like to work with you on this one if possible! I have carefully read your project post VBA Macro Bug find, and want to make you an offer and some background so you can check my work out. I a Lisää

€555 EUR 6 päivässä
(1 arvostelu)
4.1
(6 arvostelua)
4.2
geomago

Rispondo in italiano visto che siete italiani: sono interessato al lavoro. Sono software engineer da più di 40 anni, vivo e lavoro a Roma. Come valore della mia offerta ho lasciato il default (500 euro), ma se mi invia Lisää

€500 EUR 7 päivässä
(5 arvostelua)
4.2
LordVilagi

Hi there, if you send me the zip files and check it out. If it's a lot of minor bugs (will require less than 4-5 hour of my time), then I will do this for free, if not then I will consult with you. Best Regards Franti Lisää

€250 EUR 2 päivässä
(2 arvostelua)
4.2
osamawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

€250 EUR 1 päivässä
(10 arvostelua)
3.9
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA an Lisää

€250 EUR 2 päivässä
(11 arvostelua)
3.5
Crayon1365

[login to view URL] [login to view URL] [login to view URL] [login to view URL] Lisää

€600 EUR 10 päivässä
(8 arvostelua)
3.6
metlickijv

Good day Glovanni R. I am a top talent Excel macro and VBA developer with extensive experience. I have powerful background in Excel VBA and macro. As an exeprt I am confident I can deliver high quality result. I can wo Lisää

€500 EUR 1 päivässä
(1 arvostelu)
2.6