Reading Data from other workbook

[mutley]

Hi

I have a sheet and need read some columns and rows from otther sheet and to import formatting (wihout "/" , "-" ...etc, for example 2005-3/99 will be 2005399).
Somebody know how can I do It, I never do it ?

[Webtest]

You will need a comprehensive rule detailing the exact reformat operation. In the case you have put in your post using a recent version of Excel (will NOT work with Excel '97):

Option Explicit
Sub Macro1()
    Dim tStr As String
    
    tStr = "2005-3/99"
    tStr = Replace(tStr, "-", "")
    tStr = Replace(tStr, "/", "")
    
    'TEST TEST TEST TEST
    MsgBox tStr    'Shows "2005399"
    'END TEST
    
End Sub