Sorting Data in other Workbook

[macro_learning]

Hi All,

Please refer to the vba code in attached excel name "testing". I want it to first open other workbook "fbb" and then sort data in this workbook.

Can anyone please let me know the problem in this macro.

And secondly, kindly share me the code for copying folders and/or files from one location to other.


Regards,
macro_learning.

 

[Marc L]

Hi !

Explain at least what to sort ! …
​

 

[macro_learning]

I want it to sort data in excel "fbb".

Basically, I want to first open another workbook say "xyz" and want to sort data in this workbook "xyz".


is it something that we can not manipulate data in workbook opened by macro written in another excel?

Regards,
macro_learning

 

[Luke M]

Change code to this

Sub edit()

    Dim strPath As String
    Dim strName As String
    Dim wbNew As Workbook

    strPath = Range("a1")
    strName = Range("a2")
   
    Application.ScreenUpdating = False
    Set wbNew = Workbooks.Open(strPath & "\" & strName)
   
   
    With wbNew.Worksheets(1).Sort
        .SortFields.Clear
        .SortFields.Add Key:=Range("a1"), Order:=xlAscending
        .SetRange Range("A1:B5")
        .Header = xlYes
        .MatchCase = False
        .SortMethod = xlPinYin
        .Apply
    End With
    Application.ScreenUpdating = True
End Sub

 

[macro_learning]

Thank you so much...it is working perfect.

I want to sort the data in the attached "fbb" workbook.

by two field (or column) , "A1" & "B1".

Regards,
macro_learning.

 

[Luke M]

In a2 of your testing workbook, need to give full name, including extension. Change a2 to be:
fbb.xlsx

 

[macro_learning]

it is resolved ..I had forgot to change the range to "A1:B12"

thank you so much....