asked on

Open run Macro and Close Excel file plus delete another file

Hello Experts,

I have bespoke application that exports a CSV file as 'EXPORT.csv' to my desktop, this file is used to update an Excel spreadsheet called 'SPECIFICATION.xlsx' which has a Macro within called 'CSVSETUP' that will load the 'EXPORT.csv' file to update 'SPECIFICATION.xlsx' - and my application can call a program that should enable me to run this in the background when 'EXPORT.csv' is sent to the desktop.

What i wish to do is to simply call 'SPECIFICATION.xlsx' and open it to run the Macro, Save 'SPECIFICATION.xlsx' and Close it when the Macro has finished running plus Delete 'EXPORT.csv' from the Desktop when this process is completed.

What would be the easiest method to do this task and how should any code required to do this be written?

Thank you, in advance of any reply?

ASKER CERTIFIED SOLUTION

RobSampson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RobSampson

That's VBScript code, by the way, so place the .VBS file in the same folder as the Specifications.xlsm file, and it should work.

Regards,

Rob.

phoenix55

ASKER

Okay, thanks for the prompt reply Rob, will give it a try today.

phoenix55

ASKER

Hi Rob,

Gave the code a try out but it needs a line inserted to enable the Macro's, could you advise please?

phoenix55

ASKER

Right, sorted enabled macro's. Code works brilliantly Rob, much appreciated, thank you.

RobSampson

Thanks for the grade. Typically you need to manually lower the macro security or add the file to Trusted Locations. You probably could do that with a script but it's easier to do it manually.

Rob.