Search results

Ok so i have sourced some code and had a play around with it.. Function Impo_allExcel() Dim myfile Dim mypath mypath = "J:\PLANNING\Chart\Excel Test Data\" myfile = Dir(mypath & "*.xls") Do Until myfile = "" 'this will import ALL the excel files (one at a time, but...

Yea i guess you are right.. Is there anywhere i cant find some info on how i can create an import procedure using VBA. Like i said earlier i have forgotten pretty much everything so need to start from scratch.. Thanks for the help people! :)

No i guess not, but the issue i have is that each of these 10 x 10 tables are on a differnt worksheet, and there are alot! maybe 50 in each file, and there are a few files. Therefore if i had to import this data etc i would take forever!! Is there a better way? would i have to import the data...

Hi all.. I am new here and would firstly like to say hi.. The reason i have joined is because i want to write an access database in order to help with some data i have at work.. I dont really use access, however i did a a level project at school based on access. I cant really remember much...