Recent content by Clearlier

Thanks Gizmo. B.I. = Business Intelligence.

Importing multiple files (more precise question) Maybe I need to be a bit more specific. I've got a macro that imports a data file. I have fifty of these files each with the data added to the file name. I could rename each file to 'Data' and run an import for each individual file. Is there...

Hello, first question so please be gentle! I think that I'm looking for a macro but if I'm better off following a different path please let me know. I've got a folder with approximately 50 excel files with the name "Dataxxxxxxxx" where xxxxxxxx is a date in yyyymmdd format. I need to...

Hello, I'm an Irishman living in the UK who has recently returned to working in the B.I. arena after about 5 years out looking after kids. I'm gradually getting back up to speed but my new role pushes me in the direction of Access a lot which I haven't really used other than in the first...