<div>
Thank you for your help. &nbsp;Used the long-hand version and it works great.
</div>


Thank you for your help.  Used the long-hand version and it works great.

<div>
you're welcome, and awesome!
</div>


<div>
Thank you. &nbsp;Worked out great.
</div>


<div>
you're welcome, Charlie ~ happy to help
</div>


<div>
<div class="content wysiwyg-content">
Hi.<br />
<br />
I am trying to build code for filecopy &nbsp;and cannot seem to build the command string properly. I have 3 strings with the following info:<br />
destinationlocation &nbsp;(text field in a form containing &quot;C:\%userprofile%\Dropbox\<wbr />&lt;subfolder<wbr />name&gt;&quot;)<br />
destinationfolder &nbsp;(text field in a form containing &quot;&lt;destination folder&gt;&quot; -- this is a sub-folder of &quot;destinationlocation&quot;)<br />
destinationfilename (text field in a form containing &quot;&lt;destinationfilename&gt;&quot;<br />
<br />
What is the correct way to build a command string to execute this using VBA filecopy?<br />
<br />
(note: &nbsp;Source file location and name is always the same... not in text field)<br />
<br />
Thank for any help. Charlie
</div>
</div>


Hi.

I am trying to build code for filecopy  and cannot seem to build the command string properly. I have 3 strings with the following info:
destinationlocation  (text field in a form containing "C:\%userprofile%\Dropbox\<subfoldername>")
destinationfolder  (text field in a form containing "<destination folder>" -- this is a sub-folder of "destinationlocation")
destinationfilename (text field in a form containing "<destinationfilename>"

What is the correct way to build a command string to execute this using VBA filecopy?

(note:  Source file location and name is always the same... not in text field)

Thank for any help. Charlie

run FileCopy code from a string

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.