Answer the question
In order to leave comments, you need to log in
How to deal with this VBA element?
In general, you need to copy the directory, and specifically the open file
in visual basic there is such an element as ThisWorkbook.Path which defines the directory of the open file, or to be more precise, the whole path,
but I don’t know how to convert it into the copy paste command
.
Dim SourceFile, DestinationFile
iPath= ThisWorkbook.Path
SourceFile = "iPath"
DestinationFile = "DESTFILE"
FileCopy SourceFile, DestinationFile
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question