Forum Discussion

Mederic's avatar
Mederic
Post Patron
1 year ago
Solved

Copy/paste queries into worksheet

Hello everyone, I would like to know if it is possible to automatically copy all the queries from a file and paste them into a worksheet (see screenshot below). Thanks in advance
  • slorin's avatar
    1 year ago

    Hi Mederic 

    en VBA

     

    For i = 1 To ThisWorkbook.Queries.Count
    Cells(i, 1) = ThisWorkbook.Queries(i).Name
    Cells(i, 2) = ThisWorkbook.Queries(i).Formula
    Next i

    Stéphane