queries submitted via Excel macro were broken after last update

anthony bouttell

I have an excel macro that submits this command:

ActiveWorkbook.FollowHyperlink Address:=JIRA, NewWindow:=True

whereJIRA= "https://XXXsupport.atlassian.net/sr/jira.issueviews:searchrequest-excel-current-fields/19300/SearchRequest-19300.xls?tempMax=1000"

This has been running for the past year without issue.

After the latest change I'm getting this error:

Illegal request-target, unexpected end-of-input at position 1009

 The hyperlink above actually works (when I change "XXX" to the actual name of my area). Something JIRA is doing to the inflight html request is breaking it.

I have thirty or so requests I run anywhere from once a day to once a week. What changes will I need to make to this macro to restore functionality.

 

anthony bouttell

it fixed itself!!

One second it;'s working, the next second a change is made and it breaks. and presto-chango it fixes itself, without a word.

Its like it never happened.

frick'n magic