Open csv files & copy and paste info into master file

gbaker · #1 04-12-2016, 10:46 AM

I am looking for a way to open multiple files located in a folder on my network, open each of them and copy and paste the information to one master file. I have some code that when the e-mails with the attachments come in the attachments are moved to a folder on the network. Now I would like to have some code to open each one of them up and copy and paste the information to one master file.
Here is what I have so far:

HTML Code:

Option Explicit

Public Sub saveAttachtoDisk(itm As Outlook.MailItem)
Dim objAtt As Outlook.Attachment
Dim saveFolder As String
saveFolder = "\\fngn.com\us\Projects\Print Production\Reports\DSG Drop reports"
     For Each objAtt In itm.Attachments
          objAtt.SaveAsFile saveFolder & "\" & objAtt.DisplayName
          Set objAtt = Nothing
     Next
End Sub

Attached is an example fo the files that come in via e-mail
Had to change it to excel to be able to attach it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy and Paste from File to File but File Names always change	aaronbauer1980	Excel Programming	1	04-15-2016 05:53 PM
Macro to open Multiple files and copy information to a master file	gbaker	Excel Programming	2	04-08-2016 08:44 AM
Keeping track of the original file when you copy/paste	sidbisk	Excel	2	09-01-2015 02:11 PM
Loop through files and Copy Table Row and Paste into Different Document	spiderman1369	Word VBA	2	10-15-2014 08:30 AM
Can't Copy and Paste until new message is open	tabletop	Outlook	0	12-04-2009 11:38 AM