<div>
you can use &quot;R:\ABC\Boris Info\Horis_Project\GBM\&quot;&amp;R<wbr />ange(&quot;D4&quot;)<wbr />.value&amp;&quot;\F<wbr />lat Data Files&quot;
</div>


you can use "R:\ABC\Boris Info\Horis_Project\GBM\"&Range("D4").value&"\Flat Data Files"

<div>
getting the red errors when i paste that in place of dec-15
</div>


getting the red errors when i paste that in place of dec-15

<div>
Thanks Professor! :)<br />
<br />
@Seamus2626<br />
Thanks. Glad it worked for you.
</div>


Thanks Professor! :)

@Seamus2626
Thanks. Glad it worked for you.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have some code to open a file using VBA <br />
<br />
&nbsp; &nbsp; ChDir &quot;R:\ABC\Boris Info\Horis_Project\GBM\Dec<wbr />-15\Flat Data Files&quot;<br />
&nbsp; &nbsp; Workbooks.Open Filename:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;R:\ABC\Boris Info\Horis_Project\GBM\Dec<wbr />-15\Flat Data Files\Flat_GBM_ALL.xlsx&quot;<br />
&nbsp; &nbsp; ActiveWindow.ActivateNext<br />
<br />
I have a drop down in cell D4 which has months Jan-16, Feb-16 etc <br />
<br />
Instead of hardcoding Dec-15 like above, can the code use whatever value is in D4 so each month it selects the correct file <br />
<br />
Thanks
</div>
</div>


Hi,

I have some code to open a file using VBA 

    ChDir "R:\ABC\Boris Info\Horis_Project\GBM\Dec-15\Flat Data Files"
    Workbooks.Open Filename:= _
        "R:\ABC\Boris Info\Horis_Project\GBM\Dec-15\Flat Data Files\Flat_GBM_ALL.xlsx"
    ActiveWindow.ActivateNext

I have a drop down in cell D4 which has months Jan-16, Feb-16 etc 

Instead of hardcoding Dec-15 like above, can the code use whatever value is in D4 so each month it selects the correct file 

Thanks

open file vba

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Adobe Acrobat is a family of application software and Web services developed by Adobe Systems to view, create, manipulate, print and manage files in Portable Document Format (PDF). The family comprises Acrobat Reader (formerly Adobe Reader), Acrobat (formerly Acrobat Exchange) and Acrobat.com. The commercial proprietary Acrobat, available for Microsoft Windows and OS X only, can also create, edit, convert, digitally sign, encrypt, export and publish PDF files.

Adobe Acrobat

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.