Discussions
Excel Web Query in Version 11
Ver 10.6 and prior had an undocumented feature that allowed us to pass parameters to Excel Web queries. We had built a spreadsheet that allowed us to run a series of reports based on dates input within Excel.
Essentially we appended the info below to the web query html where FromDate and ToDate were ranges in the spreadsheet
&reload=T&crit_1_mod=CUSTOM&crit_1_from=["From%20Date"]&crit_1_to=["To%20Date"]
This does not work in Version 11 in the form above (in ver 11 it uses the dates most recently used by the report when run in Netsuite).
Has anyone been able to come up with any kind of workaround?