VBA rename table column (almost there)

[boblarson]

1. The extension shouldn't matter as this is ACCESS CODE meant to be run from Access, not Excel.

2. So, if it is an xls file that you get, it will just open it.

 

[Coatezy]

1. The extension shouldn't matter as this is ACCESS CODE meant to be run from Access, not Excel.

2. So, if it is an xls file that you get, it will just open it.

Hmm, Until I added the compatibility part above save it was stopping at the save point I am using access 2010. Would this cause any issues!? I will try again without and see if it runs.

Just need to point to a set sheet now.. Would assume that is easy enough

Edit:- Now pointing to correct sheet and working 100%

 

[boblarson]

Oh, yes you might have to have that compatibility part. And does the spreadsheet have code in it? If not you should be able to save it to xlsx if you want.

 

[Coatezy]

Oh, yes you might have to have that compatibility part. And does the spreadsheet have code in it? If not you should be able to save it to xlsx if you want.

No code in the sheets.. access now pointing to the correct sheet and all working fine.

Ok its now 22:00 here in the UK and have been playing with this since I finished work at 18:00.. I think its time to give my eyes a break.

Well from Access anyway. Time for some html/php now!

Thanks again for your help Bob! (Wheres the thanks button!)

Tom