runtime error 1004 in copy and close workbook vba code

**JEAN1972** · 04-21-2018, 01:49 PM

I have a workbook testandclose .xlsm where sheets master copies a template format :c:\\sample \intermartformat by using the code below.

That is it opens the interformat,xlsx , copy , paste in active workbook and close the interformat sheet.

but I am getting a runtime error 1004.as in bold red below.

Can anyone assist

Please Login or Register  to view this content.

**AlphaFrog** · 04-21-2018, 02:48 PM

intermartformat.xlsx‎ is actually an older format .xls file. You just renamed it with the .xlsx extension, but you didn't do SaveAs with the .xlsx file type selected.

Open the file and then do SaveAs. Make sure you select the .xlsx file format Type in the SaveAs dialog.

**JEAN1972** · 04-21-2018, 03:23 PM

Thanks Now working

runtime error 1004 in copy and close workbook vba code

LinkBack

Thread Tools

Rate This Thread

Display

runtime error 1004 in copy and close workbook vba code

Re: runtime error 1004 in copy and close workbook vba code

Re: runtime error 1004 in copy and close workbook vba code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Runtime error 1004 with my saveas code

Runtime error and workbook won't close

[SOLVED] Range error in code, runs alone but not inside my full program, giving runtime error 1004

Copy sheet from another workbook - runtime error 1004

Runtime Error Code 1004

After sharing workbook VB code stops working. Runtime Error 1004

shared workbook runtime error 1004

Bookmarks

Bookmarks

Posting Permissions