MS Excel Macro:Data Import, Dynamic file name?

Hello



How do I create a macro to import data from another excel file?

Column A is all I need, for about 50 rows.



The thing is, the input file's name is changed daily.



So Monday, it's ABC201008

Tuesday, ABC 211008

etc



Thanks

MS Excel Macro:Data Import, Dynamic file name?Unless there's a formula you can use to calculate the filename (if it's based on the date, for instance), you'll have to input the filename by hand, so the macro will hardly save you any work.

Why do bed sheets shed

bitting their nails