Dave,
Many thanks, while I still had trouble with the LogOnServer method and was unable to get it working, your suggestion of SetLogOnInfo worked perfectly.
Reference to SetLogOnInfo did not appear when I added reference to Crystal Reports ActiveX Designer Runtime Library 10.0, so I had to add...
Recently purchased Crystal Reports 10 Professional.
Installed on PC with Windows 2000 Professional and MS Office 2000
Using Crystal to report on a Lotus Notes Database.
We have a scheduler that was built using MS Access and works fine to schedule and run reports on the PC which Crystal 8.5 is...
Here is some code I use for sending email with attachment through Lotus Notes.
May be of some help.
Public Sub SendNotesEmail(Subject As String, Attachment As String, Recipient As String, ccRecipient As String, BodyText As String, SaveIt As Boolean)
'Set up the objects required for Automation...
try this link for some helpful answers to your question on Colours
http://www.cpearson.com/excel/colors.htm
Best solutions would be using this function
being an extract from Chip Pearsons site
**************************************
Counting Cells With A Specific Color
The following function...
If you change the Properties for the Userform, field ShowModal, from True to False, then the form will remain while you switch windows. Form will remain displayed until you use the Unload event activated from an action such as clicking an OK Button.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.