Opening variable php hyperlink from Excel

[Makrini]

Opening a variable hyperlink with php.

I am not importing the data - simply wishing to open the browser with specific conditions on a web page on my companies Intranet. (i.e one of my own data access pages)

i.e. using..

http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10

but varying the ? onwards

I am extremely comfortable with both formulas and VBA - my only restriction being I am using Excel 2000 for this project.

Any and all help appreciated greatly.

 

[shyrath]

I´m not sure how you get the addition after the ? but if the basis is the same, why not use something like:

Excel Workbook
	A	B	C	D	E	F	G	H	I
1
2
3
4	LINK	http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10
5	Addition	do=newthread&f=10
6	Hyper	http://www.mrexcel.com/forum/newthread.php?do=newthread&f=10do=newthread&f=10
7
8
9
Sheet1

 

[Makrini]

I'm sorry - you are right - that appears to work.

That was the first thing I tried - but I think because I was using a hard coded local path it decided not to work for me.

Will have to do more testing when I get in to work to make sure it isn't just an Excel 2000 issue.

 

[Makrini]

Ok - I have led you on a wild goose chase.

My file is actually a html - I am opening from a local path.

(All users have access to that path)

If I hyperlink without parameters it works - but the moment I add the ? it won't find the file.

Annoying

 

[Makrini]

For anyone who is interested - following is the solution

Sub tester()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.Application")
        IE.Visible = True
        IE.Navigate "c:\test.htm?whatever"
End Sub

I have the advantage of knowing ALL my users use internet explorer.

Thanks for listening an for all assistance