Posts by h

    Re: Align Inside A Cell


    The numerics comes from a code that puts these values in cells like this :


    " 1"
    "1"
    " 1"


    That is why the numeric values comes in disorder .
    yes, i can correct the code, but a lot of lines, better to have a code to do the correction.


    Is there a code to allign the numeric values in left side ?
    i.e.
    "1"
    "1"
    "1"

    Hi there


    I wrote numbers in column b cells in disordered way :


    1
    .. 1
    1
    .... 1
    .. 1
    1

    I would like to make them to be aligned in the left side by a code.


    Is there a code to do so ? Thank you

    Hi there


    i have a number formate 0000001 and another formate 0000123005
    i would like to move only all the zeros on the left side of the number .


    i got this code from Dave before:

    Code
    Sub KillZeros()
    '*Note: Column B must be the Entry No one
    
    
           Range("B:B").Replace What:="000", Replacement:="", LookAt:=xlPart, _
            SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
            ReplaceFormat:=False
    
    
    End Sub


    the problem of this code, it delete all the zeros in the whole number, but i want only to delete the zeros on the left side of the number....i trid to figure it out, but......

    Re: Check If Ref Library Is Loaded `


    the problem still appears when excution comes to

    Code
    ID.AddFromGuid referenceGUID, Array(2, 2, 1, 1)(i), Array(5, 5, 5, 0)(i)


    it says the error is : name conflict with object library


    what i meant in my last post is :

    Code
    If Not isReferenceLoaded("referenceGUID") Then _

    Re: Check If Ref Libray Is Loaded


    the problem is still there.


    The compiler error is solved here by putting " " in between the highlighted bold variable:

    Code
    If Not isReferenceLoaded([U][B]referenceGUID[/B][/U]) Then _


    so the problem now is

    Code
    ID.AddFromGuid referenceGUID, Array(2, 2, 1, 1)(i), Array(5, 5, 5, 0)(i)


    the error is : name conflict with object library


    any idea for a solution ?

    Re: Send Mail Error


    Ger Plante, thank u very much for reply


    i have the Microsoft Office 12 Object Library added in in the "Reference" manager in VBA, but not office 11


    and the default email system in place on my PC is windows mail


    stil the problem appears ? any help ?

    Re: Check If Ref Libray Is Loaded


    mikerickson
    Thank u very much for your cooperation


    the error is in the sub not the function, and particular in this line the bold underlined part:

    Code
    If Not isReferenceLoaded([B][U]referenceGUID[/U][/B]) Then _

    Re: Send Mail Error


    Thank you respected Admins.


    when i created this thread i realised that it should be moving, so did some corrections and donot know how to do it.


    when you correct any mistake, would you please express it gently


    so your directions would be taken with good impression


    at the end of the day we, the members, utilise from the sit and your help.

    Re: Check If Ref Libray Is Loaded


    Thanks 4 reply, but i face a problem..........................


    the code says, Next without for.............and i trid 2 solve it , but cannot.......!!!!!!!!


    pls help me ?

    Re: Check If Ref Libray Is Loaded


    Thanks, however


    in running the code , it gives me this msg
    compiler error : ByRef argument type mismatch
    and it highlight this variable referenceGUID

    Hi there
    if this post has 2 be moved to Email Excel Forum, then accept my apology..............


    i use Excel 2007.............
    The SendMail Method took it from OzGrid web does not work with me . It gives me an error msg : Method send mail of object workbook failed...........


    why is this ?? Do i have to refrence 2 particular library. i use OP windos vista (windows mail)


    Hi there
    I call this code from within Workbook_Open.........
    If these Refrences libraries are loaded then an error appear tells
    Name conflict with object library........it's clear why......


    Is there a way 2 check if the Refrences are loaded then exit the sub i.e. no need to excute this code , and if not loaded then excute the code ?