UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Open Workbook With Html, Office 2010    
 
   
wornout
post Jun 20 2019, 01:57 AM
Post#1



Posts: 1,328
Joined: 17-November 13
From: Orewa New Zealand


OK I use an accounting package called Manager.io
We can have custom fields that accept html
I already have a html code that opens a folder <a target="_blank" rel="noopener noreferrer" href="C:\Users\Michelle\Dropbox\Manager\Clients\SweetAsCampers\SweetAs\2018">SweetAs2018</a>
I would like to open an excel workBook but it keeps saying file
This localhost page can’t be found No webpage was found for the web address: http://localhost:55555/<a%20target=
HTTP ERROR 404
on a page on the internet
Go to the top of the page
 
DanielPineault
post Jun 20 2019, 05:13 AM
Post#2


UtterAccess VIP
Posts: 7,000
Joined: 30-June 11



What's your code for opening the excel file?

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
wornout
post Jun 27 2019, 12:45 AM
Post#3



Posts: 1,328
Joined: 17-November 13
From: Orewa New Zealand


Its in a text box in manager.io and it is <a target="_blank" rel="noopener noreferrer" href="C:\Users\Michelle\Dropbox\Manager\Clients\SweetAsCampers\SweetAs\2018">SweetAs2018</a>
Go to the top of the page
 
DanielPineault
post Jun 27 2019, 06:30 AM
Post#4


UtterAccess VIP
Posts: 7,000
Joined: 30-June 11



Your link href doesn't specify a file? The basic syntax should be
CODE
<a href="file://C:\Users\MyUser\Desktop\Test.xlsx">Test</a>

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
Zaddicus
post Jun 27 2019, 06:38 AM
Post#5



Posts: 139
Joined: 3-April 19
From: Cardiff


You know I was just going to jump in and state that there was no file extention (xls, xlsx, xlsm) but it appears @DanielPineault managed to jump in before me...

Worth noting that the path "C:\Users\Michelle\Dropbox\..." will not work on other computers either unless they all oddly have that path also


--------------------
~ Castiel


Skype: live:castielswift
Go to the top of the page
 
Phil_cattivocara...
post Jun 27 2019, 06:47 AM
Post#6



Posts: 368
Joined: 2-April 18



I do not know if it is a regional setting (Italy), I do not believe, but to open a local file I must write an URL like this
CODE
file:///C:/Folder/Subfolder1/filename.ext

Note: always slashes and 3 after "File:". I tried to write 1 or 2 but automatically the browser puts 3 slashes.

--------------------
Please forgive in advance my horrible English.
Go to the top of the page
 
DanielPineault
post Jun 27 2019, 07:12 AM
Post#7


UtterAccess VIP
Posts: 7,000
Joined: 30-June 11



Very interesting.

I always understood // = local resource, but further digging reveals different browser handle things differently, no surprise there (no one wants to work together!). So there are several variations depending on the browser.

href="file://C:\..."
href="file:///C:\..."
href="http://file:///C:\..."

Read https://en.wikipedia.org/wiki/File_URI_scheme for all the details and proper explanation of // vs. ///


You may also which to add the Download attribute, see: https://www.w3schools.com/tags/att_a_download.asp

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    9th December 2019 - 08:26 AM