Recent content by peterd51

Hi Strongm, thanks for the code.

Hi Strongm, and once again this is something in VB stopping OOo from accepting the commands that I send it as I don't know the correct VB format to use. Regards Peter

Hi, I'm trying to set a cell to show numbers to two decimal places and I've found various bits of code around but nothing works for me. I currently have: Dim oCell As Object Set oCell = oSheet.getCellByPosition(1, 1) Call oCell.setvalue(1000) Dim NumberFormats As Object Dim...

Hi Strongm, yes, I cross-posted because I think it's best to approach these problems from both sides. The guys over there seem to have problems with VB. I accept that they don't know it, but they query things like 'object' telling me it's something else on their side. As long as it works I...

Hi Andrzejek, I did. But yesterday I had problems logging in and had to do it three times before I could post my reply, so it may have failed while I was on an earlier attempt. I've just done it again...not sure if it's worked or not yet. Regards Peter

Hi strongm, that's got it! Thanks! Regards Peter

Hi strongm I now have: (General)(Declarations) Option Explicit Private Enum CellInsertMode none DOWN Right rows Columns End Enum Private Sub Form_Load() ... Call oSheet.insertCells(oCRAddr, CellInsertMode.DOWN) but this still gives error 438 'Object doesn't support...

Hi strongm, thanks, I've tried there but they're not familiar with VB. The problem is how to set something in VB to hold "com.sun.star.sheet.CellInsertMode.DOWN". If I try it as an object then it rejects on 'com.'. As a String it isn't passed to OPenOffice. I've poked around with Property...

Hi, I'm looking at Open Office (v4.1.5) and accessing Calc (=Excel) from VB. Specifically VB5 but I hope I can convert any suggestions made for VB.net, etc. I've played around with a few things for a few days, checked online, nothing seems to work. Dim URL As String Dim oSM As Object...

hi Chris, I've been to Blackpool a few times, ships tend to be a long way out there... I had to put the site on a back burner for a week as I was making changes to a VB program that I use every day, just about finished that now. I'll be doing some more on the site over the next week or so...

Hi Chris, I was trying to find colours that worked OK and I can read those even with my poor eyesight. Something I could play around with later... the background could do with being a bit darker. I used to have a decent colour chart for HTML but I haven't seen it for a few years, kicking around...

hi Chris. yes, you might also guess that I'm not a programmer, I just poke around a bit. My old site was still using html from before v4.0... and I'd never used any CSS until a week ago. It should be more up to date now. My main site, www.padco.net (photos, mostly ships, a few aircraft)...

hi Chris, sorry, I wasn't looking way up there! It's in place now and I don't recall changing it. I have a html template that I used for every page and it's in place there so I'm not sure why you found it was missing. Thanks for your help. Regards Peter

Hi Chris, thanks, but I still couldn't see it. I must admin that I thought I'd reset it after poking around trying all sorts of things but I'd actually left it right after one of my 'pokes' so the line was a bit mixed up. However you made me do another google search for 'html target' and when...

Hi, thanks for the replies. My main web-site isn't quite finished so I've copied the offending parts onto a 'spare' site that I have. www.sharesim.co.uk The first link to Irfanview highlights the problem of getting my URL and the target URL linked together. The second part is the shipping...