autofilter

[alex_peng]

Hello, I am new to this site and I have a question regarding autofilter. Any help would be appreciated.

I have a table which I have imported from a csv file on a website. "http://reports.ieso.ca/public/PriceHOEPPredispOR/PUB_PriceHOEPPredispOR_2020.csv"

I use table to text and It comes in fine as a table. DATE(YYYY-MM-DD) I
(Date'Hour'Price) Header -
I deleted some rows and columns that were not needed and redefined the date cell.
.Columns("A:B").ColumnWidth = 12
.Range("d:i").EntireColumn.Delete
.Range("1:3").EntireRow.Delete
.Range("A500000").NumberFormat = "yyy-mm-dd"

I am only looking for data for the current month (Day 1-31)

am using the following criteria

With ActiveSheet
.Range("a1").AutoFilter Field:=1, _
Criteria1:=XlDynamicFilterCriteria.xlFilterThisMonth, _
Operator:=xlFilterDynamic
End With

When I apply this filter it appears to work however it appears that all the row heights have been set to 0. Due to this fact, I cant use the "xltypevisisble" to copy because all the rows are equal to 0. If I try to change row height manually in the worksheet or in vba it does nothing. However, I can stretch each row one by one to reveal the filtered data.
I went into excel and selected the autofilter and it brings up option boxes for each day. If I select each box for the month it works fine.
Hopefully someone can decipher my gibberish. Any help would be appreciated.
Thank you.
Alex

 

[Logit]

If the new download is also a CSV file .... just changing the URL on the front page should work.

Have you tried it ?

 

[alex_peng]

yeah that works, its coming of the same website. I need to import both, so i would probably need to duplicate the macro or modify the existing to include two urls. Not sure what the best approach is.

 

[Logit]

.
Just thinking out loud (air code) :

On the main sheet, below the existing data ... list each URL on a separate row.

Create a macro that will first copy the URL to the rows above, then run the download macro.
Then the macro copies the next row URL / copies / runs the macro.

So ... you will need to create a new macro that performs the above functions and each time it runs
the main macro for download.