Search found 1102 matches

by Marc Vanzegbroeck
Mon Feb 15, 2021 2:18 pm
Forum: FiveWin for Harbour/xHarbour
Topic: barcode check
Replies: 3
Views: 4252

Re: barcode check

Thank you,

I was wondering if there was a FW-function to detect the codetype.
AntoninoP wrote:maybe a code 39 or a code 93? I don't know much bar codes with alpha numeric
by Marc Vanzegbroeck
Mon Feb 15, 2021 10:36 am
Forum: FiveWin for Harbour/xHarbour
Topic: barcode check
Replies: 3
Views: 4252

barcode check

Hi,

In by program, the customer can scan barcode's and create automatically invoives, scan customer cards, print labels,...

Normaly it's EAN13, but a costomer of mine have scanned a barcode on an article something like '0WTU118C02699'.

How can I determine what type this is?
by Marc Vanzegbroeck
Fri Jan 29, 2021 3:49 pm
Forum: FiveWin for Harbour/xHarbour
Topic: COPY FIELDS TO with variable
Replies: 3
Views: 1400

Re: COPY FIELDS TO with variable

João, I know that is the format, but I wanted to store the fields in a variable, because, I want the fields, depending of the content of a database. That was not working with the command. I found a solution with __dbCopy vvelden := { "NTWKNUM","NODENUM","MODNUM","S...
by Marc Vanzegbroeck
Fri Jan 29, 2021 1:58 pm
Forum: FiveWin for Harbour/xHarbour
Topic: COPY FIELDS TO with variable
Replies: 3
Views: 1400

COPY FIELDS TO with variable

Hi, If I do copy fields NTWKNUM,NODENUM,MODNUM,SLOTNUM,NAME,PTDESC,KEYWORD,NODETYP,POINT_TYPE TO c:\temp\tpsdoc.dbf it's working like expected. Now I want the fields coming from a variable like this vvelden = "NTWKNUM,NODENUM,MODNUM,SLOTNUM,NAME,PTDESC,KEYWORD,NODETYP,POINT_TYPE" copy fiel...
by Marc Vanzegbroeck
Wed Jan 20, 2021 6:12 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Re: Copy Complete sheet op excel to another workbook

Anton,

Thank you. It's working very nice.
by Marc Vanzegbroeck
Wed Jan 20, 2021 6:12 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Re: Copy Complete sheet op excel to another workbook

Anton,

Thank you. It's working very nice.
by Marc Vanzegbroeck
Wed Jan 20, 2021 3:56 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Re: Copy Complete sheet op excel to another workbook

There are 4 Sheets.

I allready tried with 0 and 1, but the same error.
Enrico Maria Giordano wrote:Does exist the Sheet number 3 in oExcel? The first is 0, if I remember correctly.

EMG
by Marc Vanzegbroeck
Wed Jan 20, 2021 3:42 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Re: Copy Complete sheet op excel to another workbook

Thank you,

Unfortunately I get an error:
  • Error description: Error Excel.Application:SHEETS/16389 E_FAIL: COPY
    Args:
    [ 1] = O Object
Enrico Maria Giordano wrote:Try something like this:

Code: Select all

oExcelInput:Sheets( "Network" ):Copy( oExcel:Sheets( 3 ) )
EMG
by Marc Vanzegbroeck
Wed Jan 20, 2021 2:25 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Re: Copy Complete sheet op excel to another workbook

Hi,

In VBA it's like this

Code: Select all

Sheets("Network").Copy Before:=Workbooks("Map19").Sheets(3)
How can I convert it to FWH?
by Marc Vanzegbroeck
Wed Jan 20, 2021 12:31 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Copy Complete sheet op excel to another workbook
Replies: 9
Views: 3585

Copy Complete sheet op excel to another workbook

Hi, I want to open 2 excel-files, and want to copy a complete worksheet to the other excel-file. How can I do this? One excel is object oExcel, the other oExcelInput with this code I can copy it       oExcelInput:Sheets(oExcelInput:Worksheets( 'Network' ):name):Select()       oExcelInput:Sheets(oExc...
by Marc Vanzegbroeck
Thu Jan 14, 2021 3:21 pm
Forum: FiveWin for Harbour/xHarbour
Topic: CMIMEENC (pdf-file to mime)
Replies: 1
Views: 859

CMIMEENC (pdf-file to mime)

Hi, A want to add a PDF-file into a xml-file with mime (base64) encoded. How can I add this? If I use CMIMEENC('C:\Users\Marc\Documents\Factuur 20210005.pdf') then the text 'C:\Users\Marc\Documents\Factuur 20210005.pdf' is converted. Can I use memoread()? Does this also read the special characters o...
by Marc Vanzegbroeck
Tue Jan 12, 2021 4:02 pm
Forum: FiveWin for Harbour/xHarbour
Topic: conditional formatting excel
Replies: 9
Views: 2368

Re: conditional formatting excel

Hi,

I found it :D

Code: Select all

oCond1 := oRng:FormatConditions:Add(xlCellValue, xlEqual, "=$B$2")
by Marc Vanzegbroeck
Tue Jan 12, 2021 3:26 pm
Forum: FiveWin for Harbour/xHarbour
Topic: conditional formatting excel
Replies: 9
Views: 2368

Re: conditional formatting excel

Hi, I'm using this FormatConditions, and it's working fine, but now I want to use instead of for example testing if the content is "Tekst" like this oCond1 := oRng:FormatConditions:Add(xlCellValue, xlEqual, "Tekst") I want to compare it with another field. Using oCond1 := oRng:Fo...
by Marc Vanzegbroeck
Sun Jan 03, 2021 2:09 pm
Forum: FiveWin for Harbour/xHarbour
Topic: Peer to Peer, NAS and NTX -> CDX
Replies: 41
Views: 12765

Re: Peer to Peer, NAS and NTX -> CDX

I also have a Synology DS218 that I use for the backups. I see that this can also be used as server ? I have several clients that use a Synology NAS as server. I have to say that then all are converted to SQL. On a Synology NAS you van install the MariaDB package, and it work very nice with FW :D Y...
by Marc Vanzegbroeck
Sun Jan 03, 2021 10:39 am
Forum: FiveWin for Harbour/xHarbour
Topic: Peer to Peer, NAS and NTX -> CDX
Replies: 41
Views: 12765

Re: Peer to Peer, NAS and NTX -> CDX

I also have a Synology DS218 that I use for the backups. I see that this can also be used as server ? I have several clients that use a Synology NAS as server. I have to say that then all are converted to SQL. On a Synology NAS you van install the MariaDB package, and it work very nice with FW :D Y...