DCRAPACCESS
asked on
xlsm href problem
Hi Experts,
I have a xlsm file that i open with a href from a html file. The xlsm file have some code in the open workbook so is opens a xlm file. It works fine when i double click the xlsm file, but when it is open through a href link the xlsm file opens but it does not open the xml file?
Can someone help with this?
I have a xlsm file that i open with a href from a html file. The xlsm file have some code in the open workbook so is opens a xlm file. It works fine when i double click the xlsm file, but when it is open through a href link the xlsm file opens but it does not open the xml file?
Can someone help with this?
Dim strname As String
Dim strpath As String
Dim oExcel As Excel.Application
Dim oWX As Workbook
Set oExcel = New Excel.Application
Application.Visible = False
Application.WindowState = xlMinimized
Application.ScreenUpdating = False
strname = Replace(ThisWorkbook.Name, ".xlsm", ".xml")
strpath = ThisWorkbook.Path & "/"
Set oWX = Workbooks.OpenXML(strpath & strname)
Application.Visible = True
Application.WindowState = xlMaximized
Application.ScreenUpdating = True
Application.ThisWorkbook.Close
ASKER
Yes that is what i want. But i found out something strange. If i press the link(href) in a firefox browser, then there is no problem. But nothing happens when i do the same with IE 6 (that is the version my work place are using :-( )
So it seems that it is some security issue in IE6
So it seems that it is some security issue in IE6
It seems that you need to upgrade the ie version, but anyway before doing that please read this article http://radio.javaranch.com/pascarello/2005/10/26/1130348276996.html
hope it helps,
Wellous
hope it helps,
Wellous
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, the Security setting was the answer :-)
Glad to be for help ;)
Thanks for the points & the grade
Thanks for the points & the grade
Would you please explain more, what you are after?
opening xlsm which has xml in the same folder from href ? is that what you want?
Brgds
Wellous