FiveTech Software tech support forums

Thanks

Now it compiled OK.

Regards

ACWoo

Dear ACWoo, Use the right hbcurl.lib Harbour and bcc 7.7: https://github.com/FiveTechSoft/harbour_and_xharbour_builds/blob/master/harbour_bcc770_32_20240417.zip Harbour and MSVC32: https://github.com/FiveTechSoft/harbour_and_xharbour_builds/blob/master/harbour_msvc2022_32_20240417.zip ...

Hi. How to solve the problem:

Error: Unresolved external '_hb_gcAlloc' referenced from C:\HARBOUR1510\LIB\HBCURL.LIB|hbcurl
Error: Unresolved external '_hb_storclenAdopt' referenced from C:\HARBOUR1510\LIB\HBCURL.LIB|hbcurl

Regards
ACWoo
FWH1510+bcc582

Thanks

Is there something like
File1:oSheetS1:Cells( 1, 1 ):Value=File2:oSheetS2:Cells( 1, 1 ):Value
File1:oSheetS3:Cells( 2, 1 ):Value=File2:oSheetS4:Cells( 2, 1 ):Value

?

Regards

ACWoo
Using FWH1510

Hi

How do I select worksheet "S1" of Excel File "WK1" and worksheet "S2" of Excel File "WK2" so that I can write certain values from S1 to S2 ?

Thanks

ACWoo
Using FWH1510

Thanks

How do I specify only certain worksheets in the files ?

Regards
ACWoo
Using FWH1510

... = oSheet2 excel2 = oSheet excel1:Cells( 30, 5 ):Value=excel2:Cells( 30, 5 ):Value excel1:Cells( 30, 6 ):Value=excel2:Cells( 30, 6 ):Value Thanks ACWoo Using BCC582 + FHW1510

Thanks

It works.

Regards.

ACWoo

Hi

Thanks

I get :

Syntax error at 'SHEET1'

Regards

ACWoo
Bcc582
FWH

Hi

=HYPERLINK("[C:\MyFolderName\MyExcelFile.xlsx]Sheet1-A!C5","CLICK HERE")

If the page (Sheet1-A) has a hyphen, the link is not valid. How to overcome this.

Thanks

Regards

ACWoo
Using bcc582
FWH

Thanks

It works.

Regards

ACWoo

... ):Value := '=HYPERLINK("c:\abc\TEST1.xlsx", "oExcel:Sheets(1):Select()" )' How to hyperlink to sheet 1 of Test1 Thanks Regards ACWoo Using bcc582 + FHW Did you try =HYPERLINK("[C:\MyFolderName\MyExcelFile.xlsx]Sheet1!C5","CLICK HERE") This will navigate ...

Hi

oSheet:Cells( 12,6 ):Value := '=HYPERLINK("c:\abc\TEST1.xlsx", "oExcel:Sheets(1):Select()" )'

How to hyperlink to sheet 1 of Test1


Thanks

Regards


ACWoo
Using bcc582 + FHW

Thanks

It works.

Regards

ACWoo
Using FWH + bcc582

Hi

oSheet:Cells( 1, 5 ):Value="We hope this information will be as helpful to others as it was for me."

How to underline "this information" only in red ?

Regards

ACWoo
Using FHW + bcc582