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 derfloh 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: *

  1. gbettle

    SQL Injection from VFP

    http://xkcd.com/327/ G.
  2. gbettle

    VFP exe doesn't start minimized

    Hello again, I've found the problem. I had SCREEN = Off inside a Config.fpw file. When I remove that it works fine. Thanks to Barbara Paltiel - see below - over on vfug.org for the "kick" that led me to find the problem. Cheers, Garry > On 10/2/07, Barbara Paltiel wrote: > > Gary, > I...
  3. gbettle

    VFP exe doesn't start minimized

    Howdy all, I have a VFP9SP1 form rolled into an EXE. This starts from a batch file. It's ShowWindow is "2 - As Top-Level Form". I've changed the forms WindowState to be "1 - Minimized". But the form still starts as normal. I've also tried _SCREEN.WindowState = 1 in Main.prg, form.Load and...
  4. gbettle

    Excel Automation and .NumberFormat

    I think I should just be using ROUND and get on with it! Thanks Brian & Mike. Cheers, Garr
  5. gbettle

    Python scheduler - Basic

    Have you tried pycron?: http://www.kalab.com/freeware/pycron/pycron.htm Cheers, Garry
  6. gbettle

    Excel Automation and .NumberFormat

    Hi Mike, Hope this email finds you well - roll on the weekend! I just would have expected CAST( -1.66542711967825E-32 as Numeric( 10, 5)) to return 0.00000. I guess it can't expand the exponential notation. So, if you have -1.66542711967825E-32, how do you convert that to 5 decimals? ( I...
  7. gbettle

    Excel Automation and .NumberFormat

    Hi Brian, Thanks for your post! My biggest problem was when the code ran on a machine with Excel 2007 installed. I was using VFP9's CAST with no problem to return CAST( lnLinest as Numeric( 10, 5)). Then I had a situation that was returning a very, very small number on the Excel 2007...
  8. gbettle

    Excel Automation and .NumberFormat

    I'm really going crazy after failing all day to debug this. Has anyone successfully used the .NumberFormat of Excel's Range function during automation? I don't know why but I can't ... code to follow: oExcel = CREATEOBJECT( [Excel.Application]) IF VARTYPE( oExcel) != [O] * could not...
  9. gbettle

    Mapping Software Example

    Hi Steve, Sure, I'd like to see the samples for MapPoint. I don't have MapPoint at this point in time, but who knows, eh? Do you have any samples for: http://maps.google.com or http://www.multimap.com Cheers, Garry
  10. gbettle

    Mapping Software Example

    Hi Lee, Many thanks for your reply. It looks promising but I don't this it is. I'm pretty sure it wasn't using Google Earth - it was Google Maps & purely for directions between two locations. Could still have been Craig though ... Craig, are you there? Cheers, Garry
  11. gbettle

    Mapping Software Example

    Howdy all, I've used in the past an example form wrapping the mapping services of two websites. It returned the webpage inside of the form, therefore, it wasn't a "true" webservice. It was using maps.google.com and I think multimap.com (NB: the last website I'm not entire sure of). You gave...
  12. gbettle

    How can I create an email in HTML format?

    Sending HTML email using Outlook from VFP faq184-1700: http://www.tek-tips.com/faqs.cfm?fid=1700
  13. gbettle

    Excel Automation Question

    Hi Tamar, That does raise an interesting point. I'm running: oExcel.Selection.End( xlToRight).Select to get the furthest most column in the sheet - I don't know how many columns there might be. So, I'm really surprised about the next line: oExcel.Range( [BA1]).Select because it won't...
  14. gbettle

    What makes a column a Hyperlink?

    Hi Baltman, Sorry for the hassle ... If I have an entire column (i.e. column A) of URLs, how would I convert it to Hyperlinks? i.e. with oExcel .Range( [B2]).Activate .Selection.HyperLinks.Add(.Range( .Selection, .Selection.End( xlDown)).Select) .Selection.HyperLinks.Add()...
  15. gbettle

    Excel Automation Question

    Nevermind, I've sorted it. oExcel.Range( Selection, Selection.End( xlDown)).Select should be oExcel.Range( oExcel.Selection, oExcel.Selection.End( xlDown)).Select Cheers, Garry PS: Any quick ways to stop Excel asking to confirm saving?
  16. gbettle

    Excel Automation Question

    Hi Baltman, I'm nearly there ... It's choking on the following line: oExcel.Range( Selection, Selection.End( xlDown)).Select VFP is stopping with "Variable 'SELECTION' is not found." Full code: oExcel = CREATEOBJECT( [Excel.Application]) IF VARTYPE( oExcel) = [O]...
  17. gbettle

    Excel Automation Question

    Man, that was quick. Many, many thanks Baltman! Cheers, Garry
  18. gbettle

    Excel Automation Question

    Howdy all, Can anyone help converting the following Excel macro to VFP 9? I'm particularly confused about the PasteSpecial lines ...: Selection.End(xlToRight).Select Range("BA1").Select ActiveCell.FormulaR1C1 = "1" Range("BA1").Select Selection.Copy...
  19. gbettle

    What makes a column a Hyperlink?

    Many thanks JRB-Bldr! And Brian for the quick VFP conversion. Cheers, Garry
  20. gbettle

    What makes a column a Hyperlink?

    Hi Mike, Happy New Year (in case you haven't heard that already!). Thanks for the reply. Well, a bit of both really. If I knew how to do it in Excel, I'd like to automate VFP to do it. I've tried to record a macro while in Excel, but have been unable to record the actual hyperlinking event...

Part and Inventory Search

Back
Top