I have an automated Excel form our users complete to amend system access. It contains a fair bit of code, enables users to make a number of choices including the manager who should approve the request, then when they hit submit it mails the workbook to that manager. It works perfectly from my PC and others if the file is sent to them.
However I want to host the form on our Intranet, which is Domino server based. This means, as I understand it (Intranet not my strong point!) that it opens from within Internet Explorer. All works fine except the mailing part. Tried 2 or 3 ways and it always fails when trying to reference Active Workbook -hovering over this in the Intranet version shows 'nothing' whereas in the non-intranet one it shows what it should. Any ideas on how to get around this please- been on it for hours and it's driving me mad!
Thanks in anticipation.
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
However I want to host the form on our Intranet, which is Domino server based. This means, as I understand it (Intranet not my strong point!) that it opens from within Internet Explorer. All works fine except the mailing part. Tried 2 or 3 ways and it always fails when trying to reference Active Workbook -hovering over this in the Intranet version shows 'nothing' whereas in the non-intranet one it shows what it should. Any ideas on how to get around this please- been on it for hours and it's driving me mad!
Thanks in anticipation.
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
