asked on
run FileCopy code from a string
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\
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
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\
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
Microsoft AccessVBA
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for your help. Used the long-hand version and it works great.
you're welcome, and awesome!
ASKER
Thank you. Worked out great.
you're welcome, Charlie ~ happy to help