how to get ws from excel into vb ?
Posted on 1999-06-29
please tell me how to create a program that can give the user to get worksheet from different file in excel and print
the worksheet by the page no. ie 1 , 2 3 and ..........
for your information, i having so many excel file. and i want to get a worksheet from different file in excel and now i want it to be print and after i get all the worksheet into the vb program, it will print the worksheet in the sequece page no. and i know i can do it even not using vb. but i hate to copy so many file and got to open so many file just to print a different ws form diffenrent file.
so please give me the way and step by step code.