Link to home
Start Free TrialLog in
Avatar of DCRAPACCESS
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?
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

Open in new window

Avatar of wellous
wellous
Flag of Egypt image

Hi,

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
Avatar of DCRAPACCESS
DCRAPACCESS

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
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
ASKER CERTIFIED SOLUTION
Avatar of wellous
wellous
Flag of Egypt image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi, the Security setting was the answer :-)
Glad to be for help ;)
Thanks for the points & the grade