nyconfidential
New Member
- Joined
- Jul 22, 2015
- Messages
- 49
- Office Version
- 365
- 2016
Hi all - I've been encountering an issue with workbooks that contain an ampersand. If i do something like try to copy data from one open workbook to another in VBA and the workbook is named something like "M&M Box Company.xlsm", I will get a "Subscript out of range" error, because the name is not getting read correctly and it thinks the workbook im referencing does not exist. If I change the workbook name to "MM Box Company.xlsm", code works fine. Any idea what I should do to correct this problem? (other than having to remove the ampersand from the file name each time, obviously not an ideal solution). Thanks!