K
KtM
Morning!
Problem with WebQuery from changing files
Read data from XXXX2005QY.html
Where Y is a variable, so it reads then automatically from specified
folder(also a string)
so the query woueld be something like BIGDIR+TARGETDIR+Q1-Q4 read into
different sheets and then modified(which works OK and produces graph as
supposed).
Problem is How to put the name in the loop so it reads through Q1 to Q4
automatically and naturally increases the destination to the same value
of Q while it does that.
I cant find a resource on how to input name as variable etc to With
ActiveSheet.QueryTables.Add(Connection:= _
"URL;????
The files are stored locally in a folder with subfolder for each
company. Idea is to read the reports automatically and create graphs of
the development. The naming standard is /local place/company
name/XXXX2005QY.html. In other words I need the webquery to change the
file 4 times and company x times(which should work with same strategy,
exept names are taken from a list in Excel, because the companies
change.)
Any ideas/help is
Deeply appreciated.
Problem with WebQuery from changing files
Read data from XXXX2005QY.html
Where Y is a variable, so it reads then automatically from specified
folder(also a string)
so the query woueld be something like BIGDIR+TARGETDIR+Q1-Q4 read into
different sheets and then modified(which works OK and produces graph as
supposed).
Problem is How to put the name in the loop so it reads through Q1 to Q4
automatically and naturally increases the destination to the same value
of Q while it does that.
I cant find a resource on how to input name as variable etc to With
ActiveSheet.QueryTables.Add(Connection:= _
"URL;????
The files are stored locally in a folder with subfolder for each
company. Idea is to read the reports automatically and create graphs of
the development. The naming standard is /local place/company
name/XXXX2005QY.html. In other words I need the webquery to change the
file 4 times and company x times(which should work with same strategy,
exept names are taken from a list in Excel, because the companies
change.)
Any ideas/help is
Deeply appreciated.