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)