I wrote this code in the Code of Sheet1
Sub Macro1() ThisWorkbook.Sheets(Array("Sheet1")).Select ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ Filename:="C:\test\upload\sample.pdf", _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False End Sub
I would like to run this every 5 minutes so I wrote this code and put it in ThisWorkbook
The problem is that this ran once but the next 5 minutes the code won't run.
What did I wrong ? What can I do to solve this ?