use a macro to Open a file with a variable filename

**plunkettyplunk** · 05-24-2010, 08:14 AM

Hi,

I'm pretty new to Macros and VB and I am trying to run a marco that opens a file.

The file name however changes on a daily basis

"Open Position Client Count (Daily)2010-05-24-01-35-27.xls"

I can open the file if the filename contained only the date however I'm stuck with the issue of time, the time is diferent every day.

I have tried to use

Workbooks.Open Filename:= _
"T:\crystal_reports\General\Oracle_Web_Trading_Reports\"Open Position Client Count (Daily)" & Format(Date, "yyyy-mm-dd-HH-MM-SS") & ".xls

But that looks for a file called "Open Position Client Count (Daily)2010-05-24-00-00-00.xls"

Any ideas?

Thanks

Ben

**JBeaucaire** · 05-24-2010, 01:58 PM

Here's one way to do it:

Please Login or Register  to view this content.

**plunkettyplunk** · 06-07-2010, 04:53 AM

Hey, apologies for not replying before now, but that worked a treat. thanks for your help.

Take it easy

Ben

**JBeaucaire** · 06-07-2010, 09:37 AM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**jayakarthick4** · 07-05-2013, 02:53 PM

Hi,

I have a similar issue, but thing is that i need excel file from intranet webpage which contains bulk of excel files, (always file name contains date in it) example= position report 20130706, on daily basis i want previous days data to be extracted. can i make use of above coding.

**arlu1201** · 07-05-2013, 03:03 PM

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.