# Posts by h

• ## Remove Preceeding Zeros

Re: Remove Preceeding Zeros

Thanks, Members
it works as you said

• ## Remove Spaces From Numbers

Re: Align Inside A Cell

hi
this code doesnot work when the disorder is coused by a code

• ## Remove Spaces From Numbers

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"

• ## Remove Spaces From Numbers

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

• ## Remove Preceeding Zeros

Re: Remove Preceeding Zeros

Thank you very much
For these rich replies

:rose:

• ## Remove Preceeding Zeros

Re: Kill Zeros From Number

Thank You Very Much

• ## Remove Preceeding Zeros

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

• ## Check If Ref Library Is Loaded `

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 _``
• ## Check If Ref Library Is Loaded `

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 ?

• ## Send Mail Error

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 ?

• ## Check If Ref Library Is Loaded `

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 _``
• ## Check If Ref Library Is Loaded `

Re: Check If Ref Libray Is Loaded

i noted the underscore, but stil face the same problem.

any idea how to solve , pls ?

• ## Send Mail Error

Re: Send Mail Error

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.

• ## Check If Ref Library Is Loaded `

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 ?

• ## Check If Ref Library Is Loaded `

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

• ## Check If Ref Library Is Loaded `

Re: Check If Ref Libray Is Loaded

Could u pls tell me how 2 use this code ?

• ## Send Mail Error

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)

• ## Check If Ref Library Is Loaded `

Re: Check If Ref Libray Is Loaded

this code shows what are the loaded Ref Libraries....................

my need here is to check whether are they loaded or not ?

• ## Check If Ref Library Is Loaded `

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 ?

• ## Method Calculation Error

Re: Method Calculation Error

Thank u Derk

i will try your suggestion and will get back 2 u.