Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
~604 People Reached
Favorite Forums
|
Hi there, I was trying to edit a excel document and save under different name and my coding for this is as follows. [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'Open Dim MyExcel As New Excel.Application MyExcel.Workbooks.Open("C:\Test\WalkAir.xlsx") 'Extract MyExcel.Sheets("sheet1").Activate() MyExcel.Range("A99").Activate() MyExcel.ActiveCell.Value = TextBox1.Text MyExcel.SaveAs("C:\Test\alkAir.xlsx") MyExcel.Workbooks.Close() … 
|