<div>
Sorry missed using a snippet box: 

<pre><code class="code-1 nolinks" id="code-20-41711861-1">Dim fso as New FileSystemObject 

'...
fso.CopyFile Source, Dest
</code></pre>
</div>

<div>
I still get error due to these 

<pre><code class="code-1 nolinks" id="code-20-41711867-1"> Dim fso As New FileSystemObject
 fso.CopyFile Source, Dest
 
</code></pre>
</div>

<div>
If the error is 
 
Compile error: 
User-defined type not defined 
 
then Ryan Chong's advice should work 
 
Whenever you want to ask about an error, please tell us what the error message is.
</div>

<div>
I get 
<a href="https://filedb.experts-exchange.com/incoming/2016/07_w30/1107226/5f.png" target="_blank" title="5f.png (8 KB)"><img alt="5f.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/07_w30/800_1107226/5f.png" /></a>due to last line below 

<pre><code class="code-1 nolinks" id="code-20-41716214-1"> Source = Replace(Replace(Source, &quot;\&quot;, &quot;/&quot;), &quot;//&quot;, &quot;http://&quot;): Dest = Replace(Replace(Dest, &quot;\&quot;, &quot;/&quot;), &quot;//&quot;, &quot;http://&quot;)
 
 Dim fso As Object
 'Set fso = VBA.CreateObject(&quot;Scripting.FileSystemObject&quot;)
 Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;)
 'Dim fso As New FileSystemObject
 fso.CopyFile Source, Dest
</code></pre>
and Source is having value 
 

<pre><code class="code-1 nolinks" id="code-20-41716214-2">http://hkgmoss/sites/a4/IT/Projects/ExcelTool/BudgetExcelTool/CHINA/AsiaPacific_Budget_HO_2016-May.xlsm
</code></pre>
while Dest is 

<pre><code class="code-1 nolinks" id="code-20-41716214-3">http://hkgmoss/sites/a4/IT/Projects/ExcelTool/BudgetExcelTool/CHINA/AsiaPacific_Budget_HO_CHINA_2016-Jun.xlsm
</code></pre>
I still get the same problem even if I did not do replace on 1st line in above.
</div>

5f.png

<div>
Please leave my last reply in above
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
I get 
<a href="https://filedb.experts-exchange.com/incoming/2016/07_w29/1106889/5c.png" target="_blank" title="5c.png (8 KB)"><img alt="5c.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/07_w29/800_1106889/5c.png" /></a>due to this line 
&nbsp; &nbsp; &nbsp; &nbsp; FileSystemObject.CopyFile Source, Dest 
 
while Source is having value 
\\hkgmoss\sites\a4\IT\Projects\ExcelTool\BudgetExcelTool\CHINA\AsiaPacific_Budget_HO_2016-May.xlsm 
 
Dest is 
\\hkgmoss\sites\a4\IT\Projects\ExcelTool\BudgetExcelTool\CHINA\AsiaPacific_Budget_HO_CHINA_2016-Jun.xlsm
</div>
</div>

5c.png

Hi,
I get

due to this line
        FileSystemObject.CopyFile Source, Dest

while Source is having value
\\hkgmoss\sites\a4\IT\Projects\ExcelTool\BudgetExcelTool\CHINA\AsiaPacific_Budget_HO_2016-May.xlsm

Dest is 
\\hkgmoss\sites\a4\IT\Projects\ExcelTool\BudgetExcelTool\CHINA\AsiaPacific_Budget_HO_CHINA_2016-Jun.xlsm

Problem to copy file

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

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

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.

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.