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


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.)


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: vba code table excel html, beta distribution vba code pdf excel, vba code speedometer excel, 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 convert excel html code, vba code rs232 excel, vba code addition excel, vba code complete excel pdf, vba code backtesting excel, convert vba code add excel, vba code convert excel html, vba code saving excel range image file, vba code predecessor excel gantt chart

About the Employer:
( 1 review ) Germany

Project ID: #14958579

Awarded to:


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)

2 freelancers are bidding on average €27 for this job


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)