Jul 19 2021 08:45 AM
i would be very grateful if anyone has any advice or solution to the following:
i have a file that gets data from the WEB. (picture of data source settings attached) i had to cross out the actual web address as possible security issue ( i'm not sure )
so twice a day i need to change each of these 7 sources.
is it possible i could have each data sources LINKED to a cell in excel.
( just because its easier to change a cell than it is to change in the data source settings )
your help is greatly appreciated.
i have searched on google but don't see an answer, maybe there isn't one, i'm hoping someone knows and can help on this. ( even if its to say that it cant be done )
it would save me so much time
thanks, sarah
Jul 19 2021 09:53 AM
SolutionYou may keep addresses in named cells within the sheet
and take it ij Power Query like
let
getAddress01 = Excel.CurrentWorkbook(){[Name="address01"]}[Content]{0}[Column1],
Source = Web.Page(Web.Contents(getAddress01)),
Data0 = Source{0}[Data]
in
Data0
Jul 21 2021 10:59 AM
Jul 21 2021 01:59 PM
@stever78 , you are welcome
Jul 26 2021 04:51 AM
Jul 26 2021 07:56 AM
Jul 19 2021 09:53 AM
SolutionYou may keep addresses in named cells within the sheet
and take it ij Power Query like
let
getAddress01 = Excel.CurrentWorkbook(){[Name="address01"]}[Content]{0}[Column1],
Source = Web.Page(Web.Contents(getAddress01)),
Data0 = Source{0}[Data]
in
Data0