Well, it’s been a very busy week or so, I’ve really been burying my head into the Excel code thats going to form the backend of our application. Due to the nature of the data and the demands of the users, I have certain restrictions on the reference numbers that we’re using to track the …
May 2007 archive
May 14
A quiet week for the Blog..
..but not for me.. I’ve spent the last week working with Excel VBA and OLE to get a connection into our backend SQL server. Then a couple of stored procedures to generate our required indexes and voila, I almost having a working DB.. Just some tweaking to do now. For those that haven’t seen the …
May 08
Long weekend..
Mmm.. lovely.. a nice long weekend.. And I didn’t touch code, SharePoint or Excel for the whole of it.. I did however play World of Warcraft for some of it!!!.. (Level 29 Human Warrior.. nice level to be at..) I also had a good spring clean of my Garage, something about having a good clear …
May 01
The Excel properties predicament – A resolution..
Well thanks to a fellow SUGUK member, I found the solution to passing Date values from Excel into a SharePoint document library. ‘The devil is in the detail’ as the saying goes and it’s no truer in this instance.. The trick is making sure that the date format of the text you’re passing out of …