Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by peterd51

  1. peterd51

    VB5 to OOo Calc set decimal places in cell

    Hi Strongm, thanks for the code.
  2. peterd51

    VB5 to OOo Calc set decimal places in cell

    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
  3. peterd51

    VB5 to OOo Calc set decimal places in cell

    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...
  4. peterd51

    Insert cells in OpenOffice Calc from VB

    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...
  5. peterd51

    Insert cells in OpenOffice Calc from VB

    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
  6. peterd51

    Insert cells in OpenOffice Calc from VB

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

    Insert cells in OpenOffice Calc from VB

    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...
  8. peterd51

    Insert cells in OpenOffice Calc from VB

    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...
  9. peterd51

    Insert cells in OpenOffice Calc from VB

    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...
  10. peterd51

    HTML External Links Fail

    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...
  11. peterd51

    HTML External Links Fail

    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...
  12. peterd51

    HTML External Links Fail

    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)...
  13. peterd51

    HTML External Links Fail

    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
  14. peterd51

    HTML External Links Fail

    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...
  15. peterd51

    HTML External Links Fail

    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...
See more

Part and Inventory Search

Back
Top