FiveTech Software tech support forums

... "Mantenimiento" } ; ACTION OrdenPago() DEFINE BUTTON OF oBar ; FILE op:bmp32+"excel32.bmp" TOP ; PROMPT "Excel" ; GROUP LABEL "CONSULTA" ; COLORS CLR_BLACK, CLR_HRED ; TOOLTIP { "Enviar Consulta a Excel", "Consultas" } ...

Estimado Foro Al realizar la exportacion a Excel desde un browse me muestra el siguiente error desde algunas consultas Error description: Error Excel.Application:ACTIVEWINDOW/3 DISP_E_MEMBERNOTFOUND: _FREEZEPANES Args: [ 1] = L .T. Stack Calls ...

When I click on cell from the worksheet named "MASTER" that has a hyperlink to another cell in "DETAILS" worksheet I found the cell in the bottom of the video. This almost always happens. Is it possible to scroll the worksheet so that when I go into a cell that it is positioned i...

... here there is not a call to END Refresh_title refresh the title of the dialog PrintBrowse print the dbf with treport ExportToExcel save the dbf on excel

Thanks Marco! Here is: oAs2:Range("A1"):value := [=COLLEG.IPERTESTUALE("#UNO!A1";"MARCO")] Note: Some sites: (https://pt.excelfunctions.eu/) translate COLLEG.IPERTESTUALE (HYPERLINK) to HIPERLIGAÇÃO that gives ERROR. The correct is (here in Brazil): oAs2:Range("A1&...

In this way
oAs2:Range("A1"):value := [=COLLEG.IPERTESTUALE("#UNO!A1";"MARCO")]

... sito non valido. Controllare l'indirizzo e riprovare" What I'm doing wrong? bye #include "fivewin.ch"FUNCTION MAIN()LOCAL oExcelLOCAL oAs1, oAs2oExcel := CREATEOBJECT( "Excel.Application" )oExcel:Workbooks:Add()iConta := oExcel:WorkSheets:countoExcel:WorkSheets:Add( ...

Hi Antonio,
I just want to check code snippets on how to add new sheet in Excel and how to select a sheet based on name or number

Dear Hua,

https://github.com/search?q=repo%3AFiveTechSoft%2FFiveTech_wiki%20excel&type=code

There are many more results on these forums about Excel

What exactly are you looking for ?

How to search for wiki content on the site https://github.com/FiveTechSoft/FiveTech_wiki ?
I am trying to find the code snippets for Excel

Anybody knows how to how I can return to original cell containing hyperlink after I clicked on it and obviusly moved?
without to create another hyperlink obviously

Have a nice day
Marco

... a contact database in SAGE and SAGE has quit supporting their Contact info of products. I was fortunant enough to export my Customers data into an Excel file which I imported into MS Access. I have all the usual fields like Company Contact Street City, State and Zipcode In my Customers old Sage ...

You are correct, seems to easy, thank you.

Dear Byron,

Maybe this way ?

Selection:FormatConditions:Add( xlCellValue, xlEqual, .T. )

just guessing...

The following line of code is from an Excel recorded macro:

Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual,Formula1:="=TRUE"

Seems like the Add method has three parameters, how do you call this in FiveWin?

Thanks,