Long time Mr. Excel viewer. First time poster. Thanks beforehand.
Here's the problem - Excel refresh returns "Please enable JavaScript to view the page content."
Understand a work around to this is to right click, edit query, click on import. This works 75% of the time. Not all the time - with 25% of the time returning the JavaS error.
However, when attempting to macro around this problem, the resulting macro fails.
With Selection.QueryTable
.Connection = _
"URL;http://[surpressed www.]"
.CommandType = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingAll
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Here, ".CommandType = 0" returns a Run-time error '5'. There are some posts on this, but no solution.
When I rem out the ".CommandType..", you guessed it, the Java error returns.
I wrapped a loop around it to run until the error is gone. This loop runs in-definitely.
I've spent about three hours trying to fix this. Again, many thanks for your help.
HELP
Here's the problem - Excel refresh returns "Please enable JavaScript to view the page content."
Understand a work around to this is to right click, edit query, click on import. This works 75% of the time. Not all the time - with 25% of the time returning the JavaS error.
However, when attempting to macro around this problem, the resulting macro fails.
With Selection.QueryTable
.Connection = _
"URL;http://[surpressed www.]"
.CommandType = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingAll
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
Here, ".CommandType = 0" returns a Run-time error '5'. There are some posts on this, but no solution.
When I rem out the ".CommandType..", you guessed it, the Java error returns.
I wrapped a loop around it to run until the error is gone. This loop runs in-definitely.
I've spent about three hours trying to fix this. Again, many thanks for your help.
HELP
Last edited: