Search results for query: *

Hello community, I am having a bad time in finding out how to send a mail with a link to a program using a hotspot in LotusScript. The code below sends an empty email. '---code--- Sub Initialize() Dim NotesSession As New NotesSession NotesSession.Initialize ("Password") Dim NotesDB As...

Marisol, I would suggest to use some code to transfer the data to Excel and at that point create your Pivot Table. This is how it works: 1- Create an object variable (Dao.Recordset) that contains the data from a particular query. Dim DB as Dao.Database Set DB = currentdb Dim ThisRset as...

PHV and the rest of the community, So this is how the problem got solved... When using the DoCdm.SendObject method, Access goes to Control Panel / Internet Option / Programs, and searches for the default e-mail setting. If this setting is different than your real e-mail software ( Lotus...

PHV, thanks for your interest. The problem arises with Lotus open or closed. I have discovered that from Control Panel / Internet Options , on the Programs Tab, the user has Oulook as the default. I will first check changing this setting to Lotus Notes,retry and let you know. Thanks pal

Hello to all, I am looking for a real expert here. I am trying to fix an error appearing on just one computer. I am using the sendobject method and Error 2296 is appearing. The error description is : "The password is invalid; the message wasn't sent" We have Lotus Notes installed in our...

To all, It becomes a common programming error to declare variables in a group. VBA does not support this feature. Dim String1 , String2 as String will declare String1 as a Variant type and String2 as a String type. Using the Variant type when you know the type is not Variant is inefficient...

Managing toolbar and button are a quite interesting Excel feature that works kind of different as one might think. When you create a toolbar or button, you are saving that button in an XLB file located in the Windows directory. So buttons and toolbars are not related to a particular workbook...

Agree with xlboo. If you open a new workbook and you just type in suppose A1. =Getformula(a2) You will get #name error because the openned workbook doesn't know where to find the Getformula (sub or function). One approach would be to reference that particular workbook like...

desi5pure, I would create a combobox. In the ListFillRange Property of the Combobox select the range where you sheet's names are. in design mode right click the Combobox and select view code. You can paste this code: Private Sub ComboBox1_Change() On Error GoTo NoMatch...

AnotherHiggins, I have really learnt from you. Please have a look at the coding below. It's very similar to yours but might be interesting Sub MyRangeFills() Dim MyRange As Range Set MyRange = _ Range(Range("a2"), Range("a" & ActiveSheet.Rows.Count).End(xlUp)) Range(Range("a1"), Range("a" &...

Dear cojeda, The best way to tackle this issue is to create a looping procedure. Use the procedure below. More efficient coding might exist for this issue but this will work. Sub FillValues() Dim q As Variant 'Need to create the range properly Range(Range("a2")...

naikadit, This is the first time I respond in this forum. Hopefully I apply to the standards of Tek-tips. The overflow error is mainly caused due to a wrong variable assignment. Try using the variant data type which uses more memory but can handle all data types. Sub TestDataType() Dim...