473,320 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Need a help to export data in Form to excel sheet to save them in that..

Dear experts! I need a help. I had made a small Bill format and i need it to be exported and save it in an excel sheet. Please help me anybody. I will put here my codes....

Expand|Select|Wrap|Line Numbers
  1. Option Explicit
  2.  
  3. Private Sub Command1_Click()
  4. Text11.Text = Val(T1) * Val(T7)
  5. Text12.Text = Val(T2) * Val(T8)
  6. Text13.Text = Val(T3) * Val(T9)
  7. Text14.Text = Val(T4) * Val(T9)
  8. Text15.Text = Val(T5) * Val(T10)
  9. Text16.Text = Val(T6) * Val(T11)
  10. Text5.Text = Val(Text11.Text) + Val(Text12.Text) + Val(Text13.Text) + Val(Text14.Text) + Val(Text15.Text) + Val(Text16.Text)
  11. End Sub
  12.  
  13. Private Sub Form_Load()
  14.  
  15.     'center the form:
  16.     Me.Top = (Screen.Height - Me.Height) / 2
  17.     Me.Left = (Screen.Width - Me.Width) / 2
  18.  
  19.     'display date & time
  20.     lblDate.Caption = Format$(Date, "m/d/yyyy")
  21.     lblTime.Caption = Format$(Time, "h:nn AM/PM")
  22.  
  23. End Sub
  24.  
  25. Private Sub cmdPrint_Click()
  26.  
  27.     cmdPrint.Visible = False
  28.     cmdExit.Visible = False
  29.  
  30.     PrintForm
  31.  
  32.     cmdPrint.Visible = True
  33.     cmdExit.Visible = True
  34.  
  35. End Sub
  36.  
  37. Private Sub cmdExit_Click()
  38.     End
  39. End Sub







Please Guys Help me to save the data from my text boxes in either excel or as text file
Jul 5 '14 #1
1 1287
twinnyfo
3,653 Expert Mod 2GB
hedge123,

Unfortunately, you don't give us much to go on. We don't know where you want to save your data (other than "to excel") and it appears you have yet to try to implement anything to perform this function (using the vast number of tools available on this site--and others).

We will not build your project for you, especially when we don't know what your result is supposed to look like.
Aug 13 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Edward S | last post by:
I budget for a Project in an Excel sheet as illustrated below. The months below are usually a 2 year period i.e. 24 months, though it could be over 24 months depending upon a Project. I then...
5
by: bimalkumar | last post by:
hi 2 all, i m using some txt boxes and few combo box in my form. how do i export the txt box and combobox data to excel sheet directly without using any database.just get the data from txt...
4
by: hibbii | last post by:
I am trying to import data from a spreadsheet into a pre-created table. The table however has columns that the spreasheet does not such as an autonumber PK and an ID as the FK. What is the best...
3
by: dmshah01in | last post by:
hi. i am new to .net i need to fetch data from excel sheet and display it on web page. please help me how to do this???
1
by: bbawa1 | last post by:
have a GridView with data. I want to export this data to an excel sheet. How can I do that. Thanks in advance
3
by: Ratan | last post by:
hi everybody, i want d code for d procedure to import data from excel sheet to db2 table. can anybody plz help me? its quite urgent. my mail id is ratan.nitrkl@gmail.com, yahoo chat id:...
4
by: alvinstraight38 | last post by:
Hey guys, I am trying to import data from an Excel spreadsheet into my SQL database. I am running SQL 2005. I following Microsoft's instructions for creating a linked server, and it appeared...
3
by: priyanka1915 | last post by:
I need to read data from Excel sheet using java classes, and insert the Data in to the tables of a database its really urgent
5
by: sangeethass | last post by:
How to export sql server-2005 table data into excel sheet .. Can u tell me how can i do this both my manually and by programmewise using perl please help me... thanks Sangeetha.S
1
ammoos
by: ammoos | last post by:
Hi Friends I need to read data from excel sheet. The issue is that the first few rows of the excel sheet are images and buttons...and the data I need to read is start from the 6th row. And also...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.