VBA not working when running on windows schedule

Hi All,

The following code runs fine when I open the excel file on my local drive (it auto runs on open). However when run on windows server via a remote desktop, the exact same code doesn't return any records or field headers. I am trying to run it manually on windows server just now before I set up a schedule

***when I run this code on my local drive the value of rs.fields.count is 30 which is correct as there are 30 fields being returned, however when I run it from windows server the value of rs.fields.count is 0, even though the code is exact same, it is also the same for rs2 which returns the actual records***

Any help would be greatly appreciated

I am using Excel 2013 on my local machine and Excel 2008 on windows server and SQL Server 2014. Also it may not be relevant but I am using Microsoft ActiveX Data Objects 2.8 Library

Please Login or Register  to view this content.