Utility Bill Information

[Usman Ghayoor]

I need to extract information of my electricity bill through a reference number from utility company's website. Is it possible thru excel ?

I also need to download the PDF file of the bill as well and save it to my computer

 

[AlanSidman]

I can think of several possible options.

1. Use Power Query to find the web site and download the bill. Manipulate as needed and load to Excel
2. Check around the web site. Often these types of notifications have a download feature to Excel or Adobe (PDF).

 

[Usman Ghayoor]

Yeah I did that for one bill its easier and quicker.
what if I have 1,000 sites then ?

 

[AlanSidman]

I do not believe that you can automate this as each site will be set up differently as determined by the individual site web masters. Unless the sites are consistent, you will need to do each individually.