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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: peterd51
  • Order by date
  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...
  16. peterd51

    HTML External Links Fail

    Hi, I have in my <body> an external link and when I click on it, the URL changes to 'my web page' plus the one I'm trying to get to. For example... <A HREF="http://www.tek-tips.com">Click here to visit Tek-Tips.com!</A> Would show 'www.mypage/http://www.tek-tips.com' and get an error 404...
  17. peterd51

    CM3.3 to Unity 4.0

    Hi, sorted it! Basically the MS Exchange server is supposed to send an 'alias' to the Unity Server when creating a new user and it isn't doing that. I found the 'toolbox' and dbWalker, that showed my three new users and the missing aliases with an error code... that lead me via Google to a...
  18. peterd51

    CM3.3 to Unity 4.0

    Hi, sorry for the delay, I've been off-site for a couple of days...but I now have a contract extension for another couple of weeks so I have time to play with the Unity. I found a 'tools' folder, tried DBwalker and this found a number of errors on the three usernames that I've set up...
  19. peterd51

    CM3.3 to Unity 4.0

    Hi, thanks for the suggestions but everything is set as it should be and it still isn't working. Looks like I'll be leaving this contract at the end of the week with this unresolved... I don't like doing that but it's one of several problems that I can't sort out (though all of the others are...
  20. peterd51

    CM3.3 to Unity 4.0

    Hi whykap, sorry, I thought I'd answered your question... the two boxes are separate and there's no connection to anything else such as emails. Hi ethereal112, thanks for the suggestion. I think the 'take message' is set but that's something for me to check on Monday morning. We did have a...

Part and Inventory Search

Back
Top