VBA code to use for a filename that changes slightly.( Need to copy data from this file)

[ishaan198]

I have a file which changes the filename slightly. The first three letters of the file remains the same though. It reads as "WIP_.....". I have to refer to this file to copy data from this file to another file. How can I automate a Macro to refer to this file when the filename changes everytime? I tried with "WIP*", but it doesn't seem to work. Please help.

[Leith Ross]

Hello ishaan198 ,

Welcome to the Forum!

Before anyone can suggest possible solutions, you need to provide more specific information. Posting before and after example of the data is a good start. If you can post your workbook that would be best.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[ishaan198]

I wouldn't mind attaching the file. The only problem is that it's a confidential data and I could be sued for doing so!