Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
problem closing excel after entering data
Okay I Know this is a problem already dealt with in a number of posts But I have Tried the solutions and Excel is still hanging when I try To close it. If I open an Excel application and worksheet and then close with out doing anything to the sheet I have no problem and I can reopen and close...- aine
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Format Date into Quarters in SQL qry
Hi I am running three qrys to enter dates into three combo boxs. 1 box is for the dates in month format. 01/01/03 to January 2003 2 box is for the dates in Year format. 01/01/03 to 2003 3 box is for the dates in Quarter format. 01/01/03 to Q1 2003 07/01/03 to Q3 2003 The following work...- aine
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
-
Problem Creating an Excel Pivot Table in VB6
Hi I am having problems creating a Pivot Table from VB code. My Code below runs a database query and returns the results to a Recordset, It then puts the contents of the recordset into an excel worksheet (Sheet1), this works fine even though i have a feeling I went a roundabout method of doing...- aine
- Thread
- Replies: 11
- Forum: Microsoft: Office
