Number11's latest activity
-
NNumber11 reacted to Fornatian's post in the thread Deleting directories and subdirectories in VBA with
Like.
use this function: Public Sub KillDirs(stDirName As String) 'purpose: deletes all files and directories in the the directory 'passed... -
NNumber11 replied to the thread Solved Mass Importing Txt Files.Running well now thank you :)
-
NNumber11 replied to the thread Solved Mass Importing Txt Files.thanks also had to change With .OpenTextFile(path, 2) to With .OpenTextFile(col(j & ""), 2) running now...
-
NNumber11 replied to the thread Solved Mass Importing Txt Files.setup the table as you have suggested and started the job it imported all the files within the first folder and deleted them as planned...
-
-
Nput the foldername to a table, then you can use a Recordset to loop through the each folder: tblFolders Path (short text) example...
-
NNumber11 replied to the thread Solved Mass Importing Txt Files.Thank you yes that worked, so now for a different question, i also have to import other text files they are in a folder and has then a...
-
Nreplace path with col(j & "")
-
NNumber11 replied to the thread Solved Mass Importing Txt Files.Thanks added that getting another error now on
-
-
NDoCmd.TransferText acImportFixed, "Cash Import Specification", "Cash_Importing", strFileName, vbNo True Use the HasFieldNames argument...
-
NNumber11 replied to the thread Solved Mass Importing Txt Files.Ok thank you for sharing, i am getting a run time error using this code..
-
-
NDim strFileName Dim oExcel As Excel.Application Dim oWb As Excel.Workbook Set oExcel = CreateObject("Excel.Application")...
-
NI find it convincing if you put the files to be imported in a fixed, known folder. You can then go through this folder in a simple loop...
-
NI am looking for a better way to import txt files rather than me having to select the file and then import all the files are within 1 folder
-
NNumber11 reacted to ebs17's post in the thread Solved Convert a text string date to dd/mm/yyyy with Like.
CDate(Format("20231129", "@@@@-@@-@@"))
-
NNumber11 replied to the thread Solved Convert a text string date to dd/mm/yyyy.Thanks all i got it working using RealDate: DateSerial(Left([T_Date], 4), Mid([T_Date], 5, 2), Right([T_Date], 2)) 20231130 =...
