In Progress

Python Openpyxl: Translate 1 line VBA code with timer (for Excel usage)

WHAT SCRIPT SHOULD DO:

There are 2 open Excel workbooks: Book1 and Book2. Script should grab data form [url removed, login to view](A2:B20) and place them to [url removed, login to view](C2:D20). VBA script would look like this:

Workbooks("[url removed, login to view]").Worksheets("Sheet1l").Range("C2:D20").Value = Workbooks("[url removed, login to view]").Worksheets("Sheet1l").Range("A2:B20").Value =

(it is not copy/paste, script should not select any range, nor interfere with other (currently) active worksheets.)

WHEN - TIME/TRIGGER/LOOP:

Script must be run every 20 second, but it must be aware of local computer time, and repeat the task on 18th, 38th and 58th second (in real time).

Skills: Python

See more: openpyxl merge cells, openpyxl create workbook, openpyxl cell value, openpyxl read excel, openpyxl range, openpyxl write row, openpyxl get_column_letter, openpyxl load_workbook, vba code table excel html, beta distribution vba code pdf excel, vba code speedometer excel, vba code convert excel html code, vba code rs232 excel, vba code addition excel, vba code complete excel pdf

About the Employer:
( 1 review ) Germany

Project ID: #14958579

Awarded to:

junaidlodhi6

i can do this for you. can you share the details Relevant Skills and Experience python Proposed Milestones €30 EUR - transfer

€30 EUR in 1 day
(3 Reviews)
3.2

2 freelancers are bidding on average €27 for this job

vishalpandey233

I understand that you need to get translated 1 line VBA code with timer. We have team of python developer who can do this for you. Relevant Skills and Experience Python Proposed Milestones €23 EUR - Ball Park

€23 EUR in 1 day
(0 Reviews)
0.0