Workbook.Open Problem ReDuex

[StuB88]

The object of the macro is to open workbooks in one folder, "save as" into a new folder, apply the data values to a scorecard workbook and then delete the original workbook in the first folder. If I run the macro in the VBA Edit window, all goes well and the second folder contains all the workbook from the first folder and all the data is updated on the scorecard workbook. If I execute the macro from a shortcut key module the code "Stalls " on the first Workbooks.Open statement. The workbook opens and then no code is executed.

Please Login or Register  to view this content.

End Sub

[Leith Ross]

Hello Stub88,

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

Sincerely,
Leith Ross