Schedule Tasks: Can the excel method .ExportAsFixedFormat be used in Schedule Tasks

[Stretchy10]

Hi all,

Can the excel method .ExportAsFixedFormat be used in Schedule Tasks as after extensive tests it appears not, probably due to the Task not being run as an 'Interactive User'.

But hopefully someone may know the definitive answer or maybe have a workaround.

(I've tried setting up a user in Component Services>DCOM Config>Microsoft Excel>) as other posts have hinted at but this does not make difference.

Thanks in advance

Steve


Steve Stretch

Continue reading...