Hello forum,
I'm trying to write a program to transfer data from several workbooks to one workbook. It seems to work perfect when I run the program from the VBA editor. However, as soon as I use a short cut key to run the program, it cuts out. Particulary, it stops immediately after the workbooks.open function. Anyone know what the problem is? Is there a way to fix this?
Thanks!
yeb4444
MsgBox() is never reached:
Workbooks.Open Filename:=Location_Files & Industry_Name & Update_Name_End
MsgBox (Check)