Yes I know the csv file is a txt file but I need it to be a text file so when I run an import data code in excel I can parse the entire text file.
The reason why is because the csv file comes with 3 columns of the information and it's different every day so it's hard to delimit it with 1 code...
Hello everyone.
I'm trying to create a rule that runs a code on a certain email that comes into my inbox. This email always has 2 files in csv form. They are called non-delivered_email_report_YYYMMDD and Batch_Failed_Report_YYYYMMDD. I would only like to save the non-delivered_email_report but...
Thank you very much andy! I used what you gave me and played around with and it finally worked for me. Here is the final code. I did make some adjustments to it but it finally works for me. Thank you so much!!!
Public Function file_Upload()
Dim fd As Office.FileDialog
Dim strFileName As String...
Is that what is needed at the end? if so what kind of loop would it be? I'm very new with vba and I got this code from various other threads and I compiled it together. If you could help me out skipvought that would be much appreciated!
Would it be a loop until?
I have a code set up on access that opens a select file dialog box and that with the selected file it imports it into a certain table. How do I get it to allow me to select multiple files and import all of the files selected. I know it's probably a simple fix but I can't seem to get it. I know I...
option explicit
Dim objFSO, objFolder, strDirectory
Dim fso, folder, dt
strDirectory = "C:\Payment Report\folder"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.CreateFolder(strDirectory)
Set fso = CreateObject("Scripting.FileSystemObject")
Set folder =...
I need help writing a VBScript that will take all the .xlsx files in the directory and put them into the folder with yesterdays date.
essentially, I need the .xslx files that are put into the directory to be moved into the new folder that is created by my first script (the one that I mentioned...
I already have a script that creates a new folder in a directory every day with the date from the day before. (have the script running with task scheduler daily). Spreadsheets are saved to this directory as well and they need to be put into the correct dates folder. I need help writing a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.