get files and consolidate ranges

[Brandonien]

Hi I've concluded VBA is probably my best bet for efficiency here and really only need it this once. If you guys could help me I would greatly appreciate it! So I want to make an excel file (*ConDatalog.xlsx*) which will hold the consolidated tables on a single sheet.

This is the location of the unconsolidated datalogs which are in .csv format
C:\Users\Gnomish Fire\Desktop\RX-8 Tuning\Datalogs\Tune 1

This is the location of the consolidated excel file (*ConDatalog.xlsx*)
C:\Users\Gnomish Fire\Desktop\RX-8 Tuning\Datalogs

This is the range I need copied from EVERY excel file in the Tune 1 folder:
Sheet1!A2:Sheet1!U <---whenever thecells have no values so it could be 2 rows or 30000...

This is the range to copy them to
Sheet1!A1:Sheet1!U <---same as above

I need the data to be consecutive so that each table gets added to the bottom of the last

I also need it to clear all the data when the file is closed

Thank you for your time!

 

[Brandonien]

scratch the saving one unless you really feel like it, I just changed the default save path in excel instead as a work around (*however I see this coming back to bite me in the a$$ later*)

 

[Brandonien]

'Folder where you want to save the Excel file
DefPath = Application.DefaultFilePath
If Right(DefPath, 1) <> "\" Then
DefPath = DefPath & "\"
End If

where do I enter a custom savepath in here insted of the default

 

[kpark91]

Try using this method:

Application.GetSaveAsFilename ("C:\blahblah", "*.xls")