I am attempting to copy a formula from one work book to another. Both are based on the same template, i.e cell layout, worksheet tabs etc.
I noticed that in the formula I am attempting to copy from there is a reference to the workbook i.e ([workbook1.xlxs). When attempting to copy to the new workbook it still references the original workbook I have copied from. I may be way off the beaten track on this one but is there anyway I can copy the formula and make it reference the active workbook?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…