Links to specific posts

Re: What I would like to see in Excel 2016

OK, if I create a link in my normal way to post #33 in that Lounge thread I initially get this with address detailed below.
Code:
http://www.mrexcel.com/forum/lounge-v-2-0/695674-what-i-would-like-see-excel-2016-a-4.html#post3455895
This works for me by loading page 4 and then skipping down to display post #33 at the top of the screen. Presumably it doesn't work correctly for you?


If I manually edit out the "-4" I get this link with address detailed below.
Code:
http://www.mrexcel.com/forum/lounge-v-2-0/695674-what-i-would-like-see-excel-2016-a.html#post3455895
This presumably works for you. It also works for me but in a rather slower and annoying way: It fully loads page 1 of the thread (it makes sense now why it does that) then works out that the post is not on page 1 (for me) and so loads page 4 then skips down to display post #33 at the top of the page.

As I say, annoying (slower) to wait for the page-loading like that and also annoying to always have to remember to remove any page reference from the copied link address.
 
Re: What I would like to see in Excel 2016

RoryA has pointed out that given the post # (eg 3455895) a link with this address should work for all users.
Code:
http://www.mrexcel.com/forum/showpost.php?p=3455895
Does this take you to post #33?

Problem is, there still isn't a quick, simple way to generate that address as far as I know.
 
Re: What I would like to see in Excel 2016

RoryA has pointed out that given the post # (eg 3455895) a link with this address should work for all users.
Code:
http://www.mrexcel.com/forum/showpost.php?p=3455895
Does this take you to post #33?
Yes, it does. By the way, I'm not sure what the problem was before, but I had to reboot my computer and now your posted URL (the first one in Message #11 above) now works for me, but the slow way like you described for when you use my URL on your computer. What happens is the -4 changes to -3 (because I only have 3 pages) which display Message #81 which is at the top of that page (this is where everything stopped before my reboot), then it stalls there for a few seconds before taking me to the correct message The URL you posted from RoryA is much faster though.


Problem is, there still isn't a quick, simple way to generate that address as far as I know.
This function (which works as a UDF) can be run directly from the Immediate Window giving you a somewhat fast way to produce the URL...
Code:
Function URL(S As String) As String
  URL = Left(S, 29) & "showpost.php?p=" & Right(S, 7)
End Function
 

Forum statistics

Threads
1,221,532
Messages
6,160,381
Members
451,643
Latest member
nachohoyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top