i was using this vba to copy data from sheet to another every 1min. but now the problems arises that i need to fetch data from external workbook which is linked to a python and python updates the workbook every 1 minute by fetching the live data from a website. So, instead of copy and pasting the data from one sheet to another i need help getting data from that workbook which stays closed or has to be close around 60sec mark so that python can import that on it.
here is the code i was using-
Sub LetsGetsStarted()
rowNum = 8
Call OneToRuleThemAll
End Sub
Sub OneToRuleThemAll()
Application.ScreenUpdating = False
Range("data").Copy
Sheets("Record").Cells(rowNum, "A").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
'Increment for next run
rowNum = rowNum + 6
'Quit condition
If rowNum > 5618 Then Exit Sub
'Schedule next call
Application.OnTime earliesttime:=Now + TimeSerial(0, 1, 00), procedure:="OneToRuleThemAll"
End Sub
here is the code i was using-
Sub LetsGetsStarted()
rowNum = 8
Call OneToRuleThemAll
End Sub
Sub OneToRuleThemAll()
Application.ScreenUpdating = False
Range("data").Copy
Sheets("Record").Cells(rowNum, "A").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Application.ScreenUpdating = True
'Increment for next run
rowNum = rowNum + 6
'Quit condition
If rowNum > 5618 Then Exit Sub
'Schedule next call
Application.OnTime earliesttime:=Now + TimeSerial(0, 1, 00), procedure:="OneToRuleThemAll"
End Sub