Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel VB Editor 2 Problems!
Name: Dave Date: February 20, 2002 at 03:36:05 Pacific
Comment:
I have programmed a nice Payroll Prog but 2 problems I find (I have got around it but in a VERY long winded way!)
1. set a date in European not American Style ie 4/12/01 not 12/4/01
2. How do I set a figure to be 2 places of decimal? I keep getting 1212.221312423534 or 101.2 instead of 101.20
Name: A Certain TH Date: February 20, 2002 at 07:09:39 Pacific
Reply:
1st prob: Is the date a)in a cell b) entered in a form c) loaded into a variable? d) etc etc 2nd prob: Is the number a) in a cell b) the result of a formula c) loaded into a variable
The solution to your problems are very very simple - but you need to be exact about your problem.
Summary: Hello I am trying to export a datagrid to an excel file using VB.NET. I can do it in ASP.net like this: Dim oDS As DataSet = reports.GetDataset(StoredProcedure, oparams) Dim DG As New DataGr...
Summary: Hi, I would like your opinion/suggestion/idea in this pls. I have a comma separated text file (attached) with 9 fields. I am interested in the 1st field and the last 2 fields. This file contains da...
Summary: I'm running a vbscript in excel. But i keep running into Run-time error '13': Type mismatch at line If Cells(i, 2).Value = "#N/A" Then Cells(i, 2).Value = Cells(i - 1, 2).Value Any1 have any idea ho...
0 
Communication with parall...
