Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Excel Tutorials for FREE…

 

A new link has been added to the Microsoft Excel Tips links on the left. However, after visiting the site…

I have to say, this has to be one of best websites dedicated to Microsoft Excel that I have come across in a long time. Hmm, maybe I should rephrase that… This has to […]

 1,183 total views,  1 views today

Excel Manipulation from Access…

Sometimes, I have to send data out to Excel. Every once in a while I have to add a little something to that data… row count, specific Worksheet, a formula, etc. For those times when you find you need to do the same, here’s what I’ve used…

I always use Late Binding, highlighted in […]

 2,484 total views

Confirm record count after Excel import…

When importing records from Excel here’s a way you can let the User know they all made it.

Step 1… In your Import code include the UpdateUser() line…

Function ImportMySpreadsheet() Dim lngColumn As Long Dim xlx As Object Dim xlw As Object, xls As Object, xlc As Object Dim dbs As DAO.Database Dim rst As […]

 1,353 total views