Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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()...

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?

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]...

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

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

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

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