Posts by dbrown14

    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
    1. 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
    1. open_path = "[URL]http://tg.plexus.com/mgmtinfo2/reports/Range("C4").Value/csv/[/URL]"
    2. open_path2 = "[URL]http://tg.plexus.com/mgmtinfo2/reports/" & Range("C4").Value & "/csv/[/URL]"
    3. 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