Breaking News: Grepper is joining You.com. Read the official announcement!

file liste excel vba

Maryam Lalloucht answered on October 9, 2024 Popularity 1/10 Helpfulness 1/10

answer file liste excel vba

related map array practice

file liste excel vba

Comment

Sub Liste_fichier()
    Dim Chemin As String
    Dim Fichier As String
    Dim i As Integer

    'Initialisation de la variable
    i = 1

    'Choix du dossier à lister
    Chemin = "D:\Extraction\Data"
    Fichier = Dir(Chemin)

    'Boucle sur les fichiers xls du répertoire
    Do While Len(Fichier) > 0
        Range("A" & i).Value = Chemin & Fichier
        i = i + 1
        Fichier = Dir()
    Loop
End Sub

Popularity 1/10 Helpfulness 1/10 Language vb

Source: openclassrooms.com

Tags: excel file vba

Link to this answer
Share Copy Link

Contributed on Oct 09 2024

Maryam Lalloucht

0 Answers Avg Quality 2/10

Closely Related Answers

map array practice

Comment

function doubleNumbers(arr){
  arr.map(x=>x+x)
}

console.log(doubleNumbers([2, 5, 100])); // [4, 10, 200]

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: coursework.vschool.io

Tags: javascript map

Link to this answer
Share Copy Link

Contributed on Oct 09 2024

Humail Majid

0 Answers Avg Quality 2/10

map array practice

Comment

function stringItUp(arr){
  arr.map()
}

console.log(stringItUp([2, 5, 100])); // ["2", "5", "100"]

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: coursework.vschool.io

Tags: javascript map

Link to this answer
Share Copy Link

Contributed on Oct 09 2024

Humail Majid

0 Answers Avg Quality 2/10

map array practice

Comment

function namesOnly(arr){
  // your code here
  return arr.map(x=>x.name)
}

console.log(namesOnly([
    {
        name: "Angelina Jolie",
        age: 80
    },
    {
        name: "Eric Jones",
        age: 2
    },
    {
        name: "Paris Hilton",
        age: 5
    },
    {
        name: "Kayne West",
        age: 16
    },
    {
        name: "Bob Ziroll",
        age: 100
    }
])); 
// ["Angelina Jolie", "Eric Jones", "Paris Hilton", "Kayne West", "Bob Ziroll"]

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: coursework.vschool.io

Tags: javascript map

Link to this answer
Share Copy Link

Contributed on Oct 09 2024

Humail Majid

0 Answers Avg Quality 2/10

file liste excel vba

Contents

More Related Answers

file liste excel vba

Closely Related Answers

map array practice

map array practice

map array practice

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.