Hey all.
I am currently weiting a program that automatically runs at 6am using task scheduler.
It is to make a range of data from sheet 1 and save it as an image (i am currently doing this with the chart.add method).
I have found that it works fine when I am logged into my username.
What i am finding is when i have locked my pc (still logged in), when tasl scheduler runs the code is is saving a blank chart and is not putting the required image into the chart canvas.
Does anyone know why this is or if there is a work around ?
Apologies if this is a known issue, i am quite new to this forum and have been training in VBA for 8 months.
Thanks for any help
I am currently weiting a program that automatically runs at 6am using task scheduler.
It is to make a range of data from sheet 1 and save it as an image (i am currently doing this with the chart.add method).
I have found that it works fine when I am logged into my username.
What i am finding is when i have locked my pc (still logged in), when tasl scheduler runs the code is is saving a blank chart and is not putting the required image into the chart canvas.
Does anyone know why this is or if there is a work around ?
Apologies if this is a known issue, i am quite new to this forum and have been training in VBA for 8 months.
Thanks for any help