I need to import an excel file every week into an access database. the file is always saved in the same folder called "Current" however the file name changes week to week because of a date and time stamp.
For example this week the file is named: Weekly_Internet_Order_Matchup_Converted_Channel_Summary_20120721_080603
next week it will be
Weekly_Internet_Order_Matchup_Converted_Channel_Summary_20120728_074452
Is there a way for me to import the file by ignoring everything after the "y"?
For example this week the file is named: Weekly_Internet_Order_Matchup_Converted_Channel_Summary_20120721_080603
next week it will be
Weekly_Internet_Order_Matchup_Converted_Channel_Summary_20120728_074452
Is there a way for me to import the file by ignoring everything after the "y"?