Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ddcroit

    Hotspot link to executable

    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...
  2. ddcroit

    Saving Export Pivot Table from Access to Excel as a specific name

    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...
  3. ddcroit

    SendObject method - Error 2296

    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...
  4. ddcroit

    SendObject method - Error 2296

    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
  5. ddcroit

    SendObject method - Error 2296

    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...
  6. ddcroit

    Data type handling

    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...
  7. ddcroit

    Save Spreadsheet columns to new workbook

    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...
  8. ddcroit

    functions in personal.xls -> #name? error

    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...
  9. ddcroit

    In Excell - VB code to trigger

    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...
  10. ddcroit

    Best Approach to populating / autofilling values to repeat

    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" &...
  11. ddcroit

    Best Approach to populating / autofilling values to repeat

    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")...
  12. ddcroit

    ERROR in MACRO

    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...

Part and Inventory Search

Back
Top