Close file after a macro opens it [SOLVED]

[brightyoyo]

Hi


I have a macro to opens a specific file and copies data to my open workbook

Dim wb As Workbook

[code]Set wb = ThisWorkbook

[code]Workbooks.Open Filename:="WORKSTATION-48Excel Macro FilesPL_Import and [code]Conversion_Template_DATA_1.xlsm" '<<<< Change File Name

[code]Columns("B:B").Select

Selection.Copy

wb.Activate[/code]

Range("D1&#34.Select[/code]

Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _[/code]

False, Transpose:=False[/code]


I would to add to the macro a way to close that file after the copying is done.


Thank You

 

[ThrottleWorks]

Hi brightyoyo,


Could you please try


workbooks("PL_Import and Conversion_Template_DATA_1.xlsm").activate

activeworbook.close

 

[brightyoyo]

Hi sachinbizboy


It worked perfectly, although it leaves a lot of information on the clipboard. Is there a way to empty the clipboard from the macro, instead of having the pop up message.


Thanks

 

[SirJB7]

Hi, brightyoyo!

Add this:

-----

Application.CutCopyMode = False

-----

Regards!

 

[brightyoyo]

Hi


@sachinbizboy

Thank You for your quick response


@SirJB7

Thank You once again for you expert help!!!

 

[ThrottleWorks]

Hi brightyoyo, glad that i could assist you in some way.


SirJB7, brightyoyo Good night, have a nice weekend.

 

[SirJB7]

Hi, brightyoyo!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!


@sachinbizboy

Hi!

Same for you, thank you.

Regards!