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

Help Studio
1

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

image

2

@SIM_JUN_HUI_BERTRAM_CSOD

Check as below

image
image1313×378 19.8 KB

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

3

Thanks it works

1 Like
4

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