|
|
Run it on Vista
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi all,
I have an application will store some data into csv file which using the code below:
Dim Logger_FileName As String
Dim ReportPath as string
Dim sReportHeader As String
Dim CheckPath
Dim iFileNumTrend As Integer
'create folder
Logger_FileName = "test.csv"<br />
CheckPath = Dir(ReportPath & Logger_FileName, vbDirectory)<br />
If CheckPath = "" Then
'print heading at .csv file
iFileNumTrend = FreeFile<br />
Open ReportPath & Logger_FileName For Append As #iFileNumTrend<br />
sReportHeader = "Date" & ", " & "Time"<br />
Print #iFileNumTrend, sReportHeader<br />
Close #iFileNumTrend<br />
End If
:
:
:
'store the latest data
iFileNumbertrend = FreeFile ' Get the free file number.<br />
Open ReportPath & Logger_FileName For Append As #iFileNumbertrend<br />
Print #iFileNumbertrend, sRecordString<br />
Close #iFileNumbertrend
my coding only allow me to store data in 1 sheets with limit 65536 rows. My question is how can i create an another sheet to keep storing the data when over the limit(65536 rows)?
any tips are welcome
thanks in advance
regards
cocoonwls
|
|
|
|
|
CSV stands for Comma Seperated Values. It is mearly a text file and is not a native file format for Excel. Hence, you have no methods of controlling how Excel imports the file by putting something in the file.
You've run into a limitation of Excel, not of the file itself.
Excel is not a database, though it appears you're using it as such. I would suggest using something else to store the data and do your reporting, such as Access or SQL Server Express.
|
|
|
|
|
I'm trying to monitor file access and when another program accesses a file being monitored make changes to the file from my monitor program and then allow the accessing program access to the file. Does anyone know how to block the accessing program temporarily while my monitor program makes changes to the file?
Regards
|
|
|
|
|
The only thing you can do is open the file with ShareDenyAll sharing permissions. This will give you sole access to the file so no other process can open it. BUT, if you cannot open the file like this, it means the file is already open by another process and you have no methods of blocking file access at all until the file is closed by the other app.
|
|
|
|
|
Hello Dave,
Thank you for your reply. One last question. If I write a file monitor program will I receive control of the file befor the other process?
Regards
|
|
|
|
|
Just because you're calling your app a "monitor" doesn't give it any special privileges, so no. Your app get's access to the file like any other, on a first come, first served basis.
|
|
|
|
|
Hi all,
can anyone help...im trying to create a text translation file for my website...i have searched the net...can anyone help me...i wanna be able to translate the text of my website to different languages..can anyone help?
living life on the flip side
|
|
|
|
|
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
My experence is that automated translations are iffy at best. If you truly what a multi-lingual website, then you should employ someone to translate your site into the desired language(s).
You can test automated translation on the web for example Google Language Tools[^]">
Covnert This is a test of English to Spanish text translation to Spanish and you get Esta es una prueba de Inglés a Español traducción de texto. Convert the results back to English and you get This is a test from English to Spanish translation of text
Try something more complex :-
The Blue-Green planet that is the Earth, revolves are the big yellow ball of fire that is the sun.
Gives :-
El Blue-Green planeta que es la Tierra, gira son las grandes amarillo bola de fuego que es el sol.
And back to English :-
The Blue-Green is the planet Earth rotates are large yellow fireball that is the sun.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Thanks Steve...ill see wat i can do...thanks again!!
living life on the flip side
|
|
|
|
|
I have a class with a Region property, that I need to serialize/deserialize (using BinaryFormatter)
My class implements ISerializable and uses a second property to do the job
My code so far:
Private Property MyRegionData() As Byte()
Get
Return Me.MyRegion.GetRegionData.Data
End Get
Set(ByVal value As Byte())
Dim reg As New Region
Dim data As Drawing2D.RegionData = reg.GetRegionData
data.Data = value
m_MyRegion = New Region(data)
reg.Dispose()
End Set
End Property
Private m_MyRegion As Region = Nothing
Public Property MyRegion() As Region
Get
Return m_MyRegion
End Get
Set(ByVal value As Region)
If m_MyRegion IsNot Nothing Then
m_MyRegion.Dispose()
End If
m_MyRegion = value
End Set
End Property
Public Sub GetObjectData(ByVal info As System.Runtime.Serialization.SerializationInfo, ByVal context As System.Runtime.Serialization.StreamingContext) Implements ISerializable.GetObjectData
info.AddValue("MyRegion", Me.MyRegionData, GetType(Byte()))
End Sub
Public Sub New(ByVal info As System.Runtime.Serialization.SerializationInfo, ByVal context As System.Runtime.Serialization.StreamingContext)
MyBase.New()
Me.MyRegionData = DirectCast(info.GetValue("MyRegion", GetType(Byte())), Byte())
End Sub
This code works, but i worder if there is a better way to deserialize it.
Region does have a constructor that takes a RegionData, but RegionData doesn't have any public constructor (that's why i use a second region object to get a RegionData).
Thanks for your help
|
|
|
|
|
i have my a program that made from VB and i made it an installer, the program works but it only in june 11 after that i wont work if tha date is not set
i have program made in VB 0.6 and i make and installer but ones i install the program it expire and has reg. code please help
|
|
|
|
|
zero_angel wrote: reg. code please help
No.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
You see you need to explain exacly what you want. you English make it Difficult for us to understand what you want. Please Explain.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hey
why when i go to declare that ,,
Dim s as System.Management.ManagementObject
,, ManagementObject namespace doesn't exist
thanks ,,
jooooo
|
|
|
|
|
Hi,
before you can use types from System.Management, you must add a reference to the "System.Management" dll.
Right-click your project in the "Solution" pane, and choose "Add Reference...".
|
|
|
|
|
so thanks my friend
now it's ok
jooooo
|
|
|
|
|
I have a textbox that supports only the following alogrthim example.
Where n is a variable number.
AnBnCn.........An
example A3B1C6........A9
How can I do a validation that does not allow that the user to enters Bn after An and
after Bn or An only Cn is ecepted?
Pls can anyone help.
Thank you
|
|
|
|
|
Hi,
provide a KeyDown handler that checks the current content of the TB plus the new key,
and when not acceptable, set both e.Handled and e.SuppressKeyPress true.
if you decide to support text paste (CTRL/V), you must check for that too (you may opt
to do that in the TextChanged handler).
|
|
|
|
|
Hi
please i need to adjust all the DataGrid rows at the same time i am using vb.net 2003 thanks
Mohammad Al Hoss
|
|
|
|
|
|
hi developer
how to chat the two system,but there is located in different location i need the vb.net code.please help me..........
|
|
|
|
|
Hi Pandian062,
dont you know how to use a thing called google? there are lots of examples out there how to do chat apps. it is not the newest concept around.
|
|
|
|