Paul Hunt

Author's posts

And the beat goes on… and on….

More of the same this week. The deadline for UAT has slipped slightly on this project, in the main because of trying to get a purchasing decision signed off on some third party utilities that we wish to use in the front end development. We’re looking at using CorasWorks SharePoint feature set for MOSS 2007 …

Continue reading

It’s been a while..

Well a week or so since I found an untidy solution to the Excel properties predicament. I’ll be honest, I’ve not spent a lot of time looking at that this week as I’ve had to concentrate on the functionality of the communications between the spreadsheet cost model and the actual back-end data systems that will …

Continue reading

Excel Custom Properties Refresh – an untidy solution..

Well I’ve had some time to spend on this little conundrum and think I’ve found a solution. It’s not the tidiest and I’d welcome any suggestions of other methods to do this. Basically the problem is that the SharePoint web based dialogue appears before the Custom Properties are re-freshed in Excel 2003. There doesn’t appear …

Continue reading

VBA, Excel, SQL, LDAP and the like..

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

Result!!

Well I took the exam.. And found that the study work I put in has paid off.. oh and probably the last 9 months playing with the Beta and the RTM versions.. 890 points I got, with a pass mark of 700, so I was happy. I think my knowledge of Kerberos and Multi/Unicasting is …

Continue reading

Quiet huh?

Well that’s cos I locked myself away for a few days to study for 70-631 – Windows Sharepoint Services – Configuring and Administering.. I’m due to take it in 1.5 hours and I don’t feel at all confident.. grin

Workflow design in Visual Studio 2005

Well that was an interesting few hours this afternoon following Nick’s article on creating workflow within Visual Studio 2005 for SharePoint. I got as far as creating all the InfoPath structures, and then when I went to edit the workflow.cs in Workflow Designer, I was faced with a Class Script and Nick had a pretty …

Continue reading