FiveTech Software tech support forums

Hi #include "fivewin.ch" #include "FileXLS.ch" #include "XLSForm.ch" #include "XLSError.ch" #define BORDER_UP nOr( BORDER_TOP ) #define BORDER_DOWN nOr( BORDER_BOTTOM ) #DEFINE TRUE .T. #DEFINE FALSE .L. LOCAL nFormat,nFormat2,nFormat3,nFont1,nFont2,nFont3,oXL...

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

Hi How to read from one Worksheet in one excel file and write to another worksheet in another excel file. I am not able to write to worksheet S2. function test #define xlDouble -4119 LOCAL oExcel := CREATEOBJECT( "Excel.Application" ) LOCAL oSheet LOCAL oSheet2 subdirc3 = "WK2.xlsx&qu...

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

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

Thanks

It works.

Regards

ACWoo

Hi

oSheet:Cells( 5, 10 ):Value="*ABC"

How to say "*" in red and "ABC" in black.

Thanks

ACWoo
Using FWH + bcc582

Thanks

It works.

Regards

AC Woo