Skip to main content
Question

Microsoft URI Scheme

  • February 13, 2018
  • 0 replies
  • 145 views

If any of you are in a Windows environment and have Microsoft Office installed, do me a favor and try and open Excel directly from a specially constructed URI:

In the application at the bottom of this post the [Open in Excel] Rich Text formula field synthesizes this <a> element which when clicked should open the Formula Function Reference CSV Report directly in Excel:
<a href="ms-excel:ofv|u|https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6&opts=csv">Open FFR in Excel</a>
This is the formula being used:

"<a href='ms-excel:ofv|u|" & [URL] & "'>Open FFR in Excel</a>"

Here is the application:

Office URI Scheme
https://haversineconsulting.quickbase.com/db/bnghwijq4?a=td

I can't test this myself at the moment as I do not have Microsoft Office installed on my boxen.

Please tell me what happens and what your configuration is (OS, and Browser).

Thanks!
This topic has been closed for replies.

  • Quickbase Alumni
  • February 13, 2018
Hi Dan,

I tested it on my system and got the below error.



Browser: Chrome
OS: Windows 7 64 Bit

Please let me know if you need any further information.

Thanks,

Gaurav