OK, After a week of thorough research I found a second method of importing a word table, since the first efficient method gave me out of stack error, which I still cant find a solution to. See below thread link to see solutions I have tried for out-of-stack error.
http://www.excelforum.com/excel-prog...ack-space.html
So I now use both methods, since most computers dont have error on 1st method. If they do, however, the program will use method2 and continue importing word table. I wanted to seek experts advice on this.
If Method2 is used, then lot of user prompts are opened, such as open read-only, save normal.dot, ok button, .... Obvisouly, that's very inefficient. any chance i can fix this procedure? (sorry if its too long to read)![]()
Please Login or Register to view this content.
Bookmarks