Hi all,
I have to do a project in excel by usung vb. The coding part is done and I am getting the output in .CSV format. when doing project in the main excel sheet I will be having 3 sheets and for every sheet I have done some coding and in the 3rd sheet I have linked with the other sheets, now after running the program my output is the extracted database to be save in .csv format that is happening quite good where the out is saving in the path given in the programming. My question is how to get that input from the particular csv file to sheet1 of my actual project.
the above code is a part of my code where the output is extracted and is saved to that location with the values in the particular row/column, but I dont want my output to go there I want it in my active excel sheet, sheet1. could anyone please help me with this.
Fast reply would be helpfull.
thank you
Regards
Siva
I have to do a project in excel by usung vb. The coding part is done and I am getting the output in .CSV format. when doing project in the main excel sheet I will be having 3 sheets and for every sheet I have done some coding and in the 3rd sheet I have linked with the other sheets, now after running the program my output is the extracted database to be save in .csv format that is happening quite good where the out is saving in the path given in the programming. My question is how to get that input from the particular csv file to sheet1 of my actual project.
Open "K:\user\Dhanek ula\Excel Project\file1.c sv" For Output As #2
Print #2, "TestID;Messwer t;UpperLimit;Lo werlimit"
Print #2, "TestID;Messwer t;UpperLimit;Lo werlimit"
Fast reply would be helpfull.
thank you
Regards
Siva