Help please - Open report on network drive and copy paste contents to sheet

[roberttkim]

Hi Excel experts and happy holidays. I need some help and would really appreciate it. I have an report that is saved as .html format on a network drive let's just say the path is //network/reports/trialbalancereport123119.html. I would appreciate it if someone could share a VBA code to open the file based on the network drive location which doesn't change but a file name that is composed of "trialbalancereportMMDDYY.htlml where the MMDDYY comes from a cell value in sheet Control. The VBA should open the file and copy all contents into sheet named report.

Really appreciate all you experts on this forum.

 

[CSmith]

Looks answered here: Duplicate