![]() ![]() csv extension, please rename " vbCrLf _ ![]() "and make sure files exist and are spelled correctly." vbCrLf _ "Please check files in O:\IDP_DOWNLOAD" vbCrLf _ MsgBox "Import files are not in place or are not named correctly." vbCrLf _ If VenFile = "" Or APPFile = "" Or APIFile = "" Then VenFile = Dir("O:\IDP_DOWNLOAD\EXPVE N.csv")ĪPPFile = Dir("O:\IDP_DOWNLOAD\EXPAP P.csv")ĪPIFile = Dir("O:\IDP_DOWNLOAD\EXPAP I.csv") '*****check for existence of files and names of files***** csv files before they are stored in the Access database. I need to delete the first lines of each of the. Rember, this is not VB.NET and I do not have the luxary of the Rename function. First, I want ot be able to add the extention to the files. csv files are give to me they have no extention. I have written a program that will take a. Slow Chat with the Microsoft Visual Basic team.Universal Windows Platform and Modern Windows Experience.It's not a technique specific to programming but it is critical to programming, so the sooner you apply it, the better. This is basically problem solving 101 - divide and conquer. You then just need to combine the solutions into one. If you break your process down into those steps and research each one individually though, you're far more likely to find help for each of them. ![]() The more steps in your process, the less likely you'll find all of them implemented in the same place. The reason that beginners so often find it hard to find information is because they expect to find a turnkey solution for a multi-step process. Finally, File.Move or File.MoveTo will do the renaming. You can then use String.Substring as suggested to get the two parts of the file name that you need to retain and combine them. The Path.GetFileName method or FileInfo.Name property can help you there. The next part is to get just the file name. Directory.GetFiles or DirectoryInfo.GetFiles can help you there. The first part is to get all the files in the folder. ![]() Ah, I just realised that you said that you found that code on the web, so maybe you are using VB.NET and that code is basically useless to you as it isn't VB.NET.Īs with any problem, you should break it down into parts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |