22. marts 2011 - 15:27Der er
2 kommentarer og 1 løsning
Formattering af tal
Hej
Jeg har fundet denne lækre kode, som giver mig fortløbende nummerering, hvor nummereringen ikke er "bruger-begrænset".
Jeg kunne godt tænke mig, at min nummerering skal starte med 000001, istedet for 1 - hvordan gøres dette?
Koden: Public Function NextSeqNumber(Optional sFileName As String, Optional nSeqNumber As Long = -1) As Long Const sDEFAULT_PATH As String = "C:\...." Const sDEFAULT_FNAME As String = "defaultseq.txt" Dim nFileNumber As Long
nFileNumber = FreeFile If sFileName = "" Then sFileName = sDEFAULT_FNAME If InStr(sFileName, Application.PathSeparator) = 0 Then _ sFileName = sDEFAULT_PATH & Application.PathSeparator & sFileName If nSeqNumber = -1& Then If Dir(sFileName) <> "" Then Open sFileName For Input As nFileNumber Input #nFileNumber, nSeqNumber nSeqNumber = nSeqNumber + 1& Close nFileNumber Else nSeqNumber = 1& End If End If On Error GoTo PathError Open sFileName For Output As nFileNumber On Error GoTo 0 Print #nFileNumber, nSeqNumber Close nFileNumber NextSeqNumber = nSeqNumber Exit Function PathError: NextSeqNumber = -1& End Function
Public Sub Workbook_Open() ThisWorkbook.Sheets(1).Range("E2").Value = NextSeqNumber End Sub
Mød en af Nordens fremmeste eksperter i adfærdsdesign – Morten Münster, der bl.a. har skrevet ” Jytte fra marketing er desværre gået for i dag” – på Computerworld Cloud & AI Festival.
Public Function NextSeqNumber(Optional sFileName As String, Optional nSeqNumber As Long = -1) As String Const sDEFAULT_PATH As String = "C:\Data" Const sDEFAULT_FNAME As String = "defaultseq.txt" Dim nFileNumber As Long Dim Nuller As String Nuller = "000000" nFileNumber = FreeFile If sFileName = "" Then sFileName = sDEFAULT_FNAME If InStr(sFileName, Application.PathSeparator) = 0 Then _ sFileName = sDEFAULT_PATH & Application.PathSeparator & sFileName If nSeqNumber = -1& Then If Dir(sFileName) <> "" Then Open sFileName For Input As nFileNumber Input #nFileNumber, nSeqNumber nSeqNumber = nSeqNumber + 1& Close nFileNumber Else nSeqNumber = 1& End If End If On Error GoTo PathError Open sFileName For Output As nFileNumber On Error GoTo 0 Print #nFileNumber, nSeqNumber Close nFileNumber NextSeqNumber = Left(Nuller, 6 - Len(Trim(nSeqNumber))) & nSeqNumber Exit Function PathError: NextSeqNumber = -1& End Function
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.