Posts by dbrown14

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Re: Find value from open workbook in closed workbook and copy adjacent cells


    You might want to open you CSV file to see if the formats stay there.
    Try this though.

    Re: Find value from open workbook in closed workbook and copy adjacent cells


    Try this

    Re: VBA Copy paste values to another sheet


    Try this

    Re: Find X in a row of closed workbook assign the column letter to a variable


    Try this.


    Re: Copy data from a file in netwrok based on File Name & Folder name key in by user.


    I see what your problem is now.
    Try this.

    Code
    open_path = "[URL]http://tg.plexus.com/mgmtinfo2/reports/" & Range("C4").Value & "/csv/[/URL]"


    The code you had before made everything inside the quotes a string. Therefore, "Range("C4").Value" was literally place in the string open_path.
    The code I provide, starts and end with a string added onto the evaluation of "Range("C4").Value"
    To see the difference you can use this.

    Code
    open_path = "[URL]http://tg.plexus.com/mgmtinfo2/reports/Range("C4").Value/csv/[/URL]"
    open_path2 = "[URL]http://tg.plexus.com/mgmtinfo2/reports/" & Range("C4").Value & "/csv/[/URL]"
    Msgbox "open_path: " & open_path & vbNewLine & "open_path2: " & open_path2

    Re: Validation Across Several Worksheets


    Try something along these lines.
    Try uploading an example workbook for better help