Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. calvarado536

    Saving Certain Attachments in Email

    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...
  2. calvarado536

    Saving Certain Attachments in Email

    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...
  3. calvarado536

    Importing Multiple Selected Files To Access Database

    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...
  4. calvarado536

    Importing Multiple Selected Files To Access Database

    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?
  5. calvarado536

    Importing Multiple Selected Files To Access Database

    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...
  6. calvarado536

    Help with VB script

    never mind I figured it out after playing with it. Thank you very much.
  7. calvarado536

    Help with VB script

    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 =...
  8. calvarado536

    Help with VB script

    I think I should add that the script needs to be run every day and that the name of the folder is different every day since it is yesterdays date.
  9. calvarado536

    Help with VB script

    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...
  10. calvarado536

    Help with VB script

    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...

Part and Inventory Search

Back
Top