Activate csv file with partial name with VBA

[Finagill]

Every morning I need to open a csv file from a web based server, sort and filter the data, then copy the relevant data over to an Excel sheet. To make things even more interesting, only part of the file name stays the same. I prefer to not have to save the file as I am trying to make sure that the code works for everyone. The file is not located anywhere that I can get to except through a web based interface. I figured out how to do everything if this was a Excel file. The code that I am using is:

For Each wb In Workbooks 'Finds Oracle workbook
If Left(wb.Name, 10) = "Custom_STN" Then Set oBook = wb
Next

This works great for Excel files but it doesn't look at csv files. Is there anyway to automate this without have to save the file?

 

[VBE313]

There are ways to open .csv files in NotePad. As for the internet, you need to automate that with IE VBA, or Selenium Basic. I have something I do every morning that extracts a file online and opens it in NotePad and finds and replaces certain text all written in VBA. Let me know if I can help guide you in anyway. You need to elaborate a little more for me to help

 

[Finagill]

I still plan on opening the csv file manually as it just seems to be trouble then it is worth to write a program to do it for me. When I open the file it automatically opens in Excel as a csv file so that is why I was hoping that there was a way in Excel to have it activate an open csv file.

 

[VBE313]

Do you want the .csv file to open in Excel or do you want the .csv file to open in Notepad?

 

[Finagill]

The process that I have to go through in order to get the file opens it automatically in Excel so I do not need to open it again. Until I can obtain access to the actual location where the file is stored I have to open in order to obtain it.