Hyperlink PROBLEMS

  • Re: Hyperlink PROBLEMS


    when i did like this =HYPERLINK("C:\Users\heral\Desktop\Mechanical\Erection"&A1&".pdf") it works, but the name is also like that, how can i change the name of that link like the RFI name.

  • Re: Hyperlink PROBLEMS


    Look at the attachment I gave you in post #20. It works perfectly.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Hyperlink PROBLEMS


    That is because your locale has changed it from a comma to a semi-colon, which for you is correct. I had no way of knowing that your locale required that, but you should know.


    Do I get a "thank you" now??? ;)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Hyperlink PROBLEMS


    Quote from krazeenookie;775441

    thank you so much, it works now, what can i do for you? :sheep:


    I'll let you know. ;)


    I'm glad to have helped. :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Hyperlink PROBLEMS


    Quote from krazeenookie;775443

    Anyway, how old are you?


    What's that got to do with anything??? Not that I feel the need to hide it. I'm 52.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: Hyperlink PROBLEMS


    ah i see, im very happy now because of that, hmmmn just last one, how do i know if all of my pdf's file at my folder are in my excel. like conditional formatting?

  • Re: Hyperlink PROBLEMS


    No idea about that one, sorry. I think you might need VBA for that. Maybe start a new thread? Have a nice day! :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!