Macro to import data from folder without hardcoding any file name

**excelmonalisa** · 03-21-2017, 03:03 PM

Hi All,

I'm looking for a macro to import data from excel sheet.when i click on command button in sheet1 it will go to Folder C:\ once i select the input excel file it will copy the excel sheet data into sheet2 of my macro sheet.Any one can guide me.

File name can not be hardcoded.
Thanks

**Bernie Deitrick** · 03-21-2017, 03:26 PM

Please Login or Register  to view this content.

**excelmonalisa** · 03-22-2017, 02:14 PM

Hi Bernie Deitrick,
Thanks for your script.Only one issue is when i ran macro it is opening c folder. instead of selecting file when i click cancel buttonn im getting runtime error 1004.false.xlsx not found instead of getting that runtime error is there any way to avoid that error by using any error handling or when i click cancel it will not throw any error.

**Bernie Deitrick** · 03-22-2017, 02:57 PM

Did you not want to "go to Folder C:\ "? Anyway, this will handle the cancel error - not running the code when you don't want to import the sheet will also prevent the error.

Please Login or Register  to view this content.

Macro to import data from folder without hardcoding any file name

LinkBack

Thread Tools

Rate This Thread

Display

Macro to import data from folder without hardcoding any file name

Re: Macro to import data from folder without hardcoding any file name

Re: Macro to import data from folder without hardcoding any file name

Re: Macro to import data from folder without hardcoding any file name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Import data from files in folder with a given word/text in the file name

VBA to import data from a file within current folder

Macro to find most recent csv file in folder and import this

Macro to import data from folder

[SOLVED] Macro - Master file to import data from another open file with variable file name

Import with macro the last modified csv data file in a specified folder to excel 2007

Excel VBA to import all the data of various files into 1 file in the same folder

Bookmarks

Bookmarks

Posting Permissions