Open an Excel Workbook using word VBA
Posted on 2006-06-02
I am currently preparing a template generator using Word VBA.
The Userform consists of option boxes and the programming behind the boxes simply tells it to open the files. This works perfectly for Word documents.
However, whenever i give it a path relating to an excel spreadsheet it simply crashes. I am a novice at vba!
Could someone provide a vba example of how to open a specific workbook in excel from word and make it appear in a normal excel window and visible?
I am creating quite a few template generators in the near future and this would be very helpful.