How do i open a excel file that goes by year?

hey guys im not sure how do i open a excel file that will change every year so for example i want to open this year 2021 excel file and when it reach next year it will open 2022.

image

@SIM_JUN_HUI_BERTRAM_CSOD

Check as below

Declare a string varialbe and assign as Now.ToString(“yyyy”)

This will give output of current System year

and pass to your file name

Hope this may help you

Thanks

Thanks it works

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.