<div>
You should be able to use a FileSystemObject, and call fhe DeleteFile method with the path.
</div>


You should be able to use a FileSystemObject, and call fhe DeleteFile method with the path.

<div>
I get<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279737/21h.png" target="_blank" title="21h.png (8 KB)"><img alt="21h.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w09/800_1279737/21h.png" /></a><br />
due to last line below. Why?<br />

<pre><code id="code-20-42483606-1">    Dim Name0 As String
    Name0 = Application.ActiveWorkbook.Path &amp; &quot;\Departure List (of People already left).xls&quot;
    FileSystemObject.DeleteFile Name0</code></pre>
</div>


I get
21h.pnghttps://filedb.experts-exchange.com/incoming/2018/02_w09/1279737/21h.png
due to last line below. Why?


    Dim Name0 As String
    Name0 = Application.ActiveWorkbook.Path & "\Departure List (of People already left).xls"
    FileSystemObject.DeleteFile Name0

21h.png

<div>
You need to allow the cmd host or script to run within AppSense Application Manager, which is what is blocking it judging by that dialog box.
</div>


You need to allow the cmd host or script to run within AppSense Application Manager, which is what is blocking it judging by that dialog box.

<div>
<div class="content wysiwyg-content">
Hi,<br />
It seems there is problem to run CMD within Citrix. How to execute these 2 lines below?<br />
<br />

<pre><code id="code-10-29086430-1">    Command0 = &quot;cmd /c delete /y &quot;&quot;&quot; &amp; Application.ActiveWorkbook.Path &amp; &quot;\Departure List (of People already left).xls&quot; &amp; &quot;&quot;&quot; &quot;
    Shell (Command0)</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279724/21f.png" target="_blank" title="21f.png (11 KB)"><img alt="21f.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w09/800_1279724/21f.png" /></a>
</div>
</div>


21f.png

Hi,
It seems there is problem to run CMD within Citrix. How to execute these 2 lines below?

(CODE)


Problem with CMD

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.

Microsoft Office

Citrix is the synonym for the virtualization and application infrastructure systems developed by the company of the same name. Main areas are application virtualization, Software-As-A-Service (SaaS), cloud-computing and networking. The two most well-known are Citrix XenApp or Citrix CloudPlatform.

Citrix

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.

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.

Programming Languages-Other

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.