Search results for query: *

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

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

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

Howdy all, I'm copying out a DBF (VFP 9) to an XLS file that includes a character field with a url in it. i.e.: http://www.soccerbase.com/results3.sd?gameid=505813 When I open the XLS file in Excel (2003 SP2), the field is formatted as General and isn't a blue, hightlighted Hyperlink. To...

Howdy all, Hope this email finds everyone well. Would anyone know how to check with ShellExecute has stopped? I'm spawning a cmd box that's running a Blat script. However, I want VFP to stop processing until this window is finished\gone A work around has been giving to me already: > Put...

Howdy all, I have opened an Excel spreadsheet, which always has just 3 columns. I would like to scan through the rows, evaluate the 3rd column to be > 0, and if not, make the entire row bold. I thought something like this would in order: lnLastRow = loXls.Range( "A1").End( xlDown).Row for...

Howdy all, Hope this message finds you all well. Over on the Profox list, someone has asked the above question. Does anyone have any such experience? Many thanks! Cheers, Garry