Posts by alring

    Re: Nested If


    Hi Wigi


    As fare as I can see then is it then highest number that Wilna want to have. And If i understand you code too then is it also the highest number you get.


    But let us see which one Wilna want to use.


    Alring

    Re: Nested If


    Hi Wilna


    I have changed B48.


    Take a look and see if you can use this.


    Alring

    Files

    • TAK 60.xls

      (28.16 kB, downloaded 17 times, last: )

    Hi There


    I am working on a calender. Now I want to to put small pictures that shows the size of the moon. So how can I use VBA to input pictures in specified cells??
    I also want to know how I can get VBA to delete the pictures when I change the year of the calander.


    I do hope that it's possible to do these things.


    Thank you in advance.

    Re: Hyperlink


    Hi Goppi


    THANK YOU :thanx:


    This is perfect. Just what I needed. I don't know how I can thank you enough. This was a big help for me. :cheers:


    :thanx:


    Alring

    Re: Hyperlink


    Hi Goppi


    I am using Excel to control the project. In that excel document I have made some hyperlinks that can open some documents in pdf. These pdf documents sometimes change the name. But it's just the last part of the name that changes. As desribed before. The macro I have now look like this:




    It's the part after "Next" that I quiestions to now. I know that this part can open a word document. But what do I need to write so it's Adobe Reader that opens.
    Cells(6,1) is the path and file name.
    Regards

    Re: Hyperlink


    Hi Goppi


    As the macro is now then it's write the number for the document in cell A3. But is it also possible to have the macro to open the document? I know that if it's a word document then the VBA code is:


    Code
    1. Word.Apllication


    But what is it for a Pdf file?? if I just know that then I can use the macro to find the last version and to open the pdf file.


    Alring

    Re: Hyperlink


    Hi Goppi


    Thank you for the code. It's works almost perfect. I was hoping that the macro also could open the document. But it seems that i can't get it all. :)


    :thanx:


    Alring

    Re: Hyperlink


    Hi Goppi


    It don't sounds good in my ears right now. But if Excel can't do it in that way then I have to change my Excel document.


    Now we just come to a nother problem. I have never tried to write a macro like that in VBA before. So can you please help me to make a wildcard in VBA that can solve my problem that way.


    Regards

    Re: Hyperlink


    I want that A3 should be a wildcard so the hyperlink automatic takes the highest version-number in filename.


    Regards

    Re: Hyperlink


    It's not the excel workbook the change number in the filename. It's the PDF file that change version-number in the filename if there is an update to the PDF-document. If there is one of these changes in version-number e.i. from 02 to 03 then 02 will 02 disapear from the filesystem. So it will aways be the highest number. Meaning where I put the XX and YY before.


    I don't know if we can call it wildcard for the last part of the filename.


    Regards

    Re: Hyperlink


    Maybe I didn't explain myself good enogh. The last part of the filename before the dot is version-number of the document.


    I have the following:
    6666-DOC-402-XX.pdf
    and
    7777-DOC-402-YY.pdf


    In different cells I write the hole filename and then I put them together in the a hyperlink.


    E.I
    Cell A1=6666
    Cell A2=-402-
    Cell A3=XX
    cell A4=.pdf
    In another document is it the same but cell A1 will be 7777


    But when I make the hyperlink then I have to write E.I. 02 in cell A3. But if change that document to version 03. Then the name will also be 03.


    So what I want it the hyperlink automatic takes the highest version number.


    Be the way. I don't wnat to use VBA for this. I mean I hope that I can do it without. If not then I have to use VBA.


    Regards

    Re: Userform


    Thank you so mush badger101. Now I can see what an idiot I have been. Maybe I should ask my boss to have a reading course. I think it will be on is't place to get one of these NOW.


    Thank for you help. And sorry to all that I asked above this.


    :thanx:
    Alring

    Hi


    In a userform I have two textboxes. What I write in these two textboxes I want to put in two different cells. I have this code here. But there is something wrong. Please help me.



    Alring

    Re: Input box


    Hi Roy


    As the macro is now then comes there two input boxes. If I understand you correct thenis it not possible to have two lines in one input box. If that's correct then I will make a Userform instead.


    Thank you for your help. :thanx:

    Re: Input box


    Hi Roy


    The two input lines that I want to have in one inputbox is not to be gathered. What i write in the two inputlines I will insert in two different cells in the worksheet.

    Hi there


    I ahve a hyperlink that opens an another documnet. I use this hyperlink in different documents. But most of the name for the document that i want to open is always the same. It's ony´ly the last part that change.


    So in one document the hyperlink opens 6666-DOC-402-03.pdf. But in an another document the hyperlink opens 7777-DOC-402-04.pdf. Is it possible to write the hyperlink so it automatic take the highest number after the last -. The number in front of the name e.i."6666" I change manualy.


    Alring

    Hi there


    I have an inputbox with one input line. Is it possible to have two input lines in one input box?


    Right now I have two input boxes to write the two things I want to write. But it will be great only to have one input box with two input lines.




    Alring