Search found 133 matches: vba

Return to advanced search

Re: Corrector ortográfico

hi, as i can say CheckSpelling-Methode is "just" the Start Point https://learn.microsoft.com/de-de/office/vba/api/word.document.checkspelling you need to write a CLASS and include Method ::nextWord() METHOD FwSpellChecker:checkSpelling( cString )LOCAL ...
by Jimmy
Thu Jan 12, 2023 1:09 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Corrector ortográfico
Replies: 3
Views: 445

Corrector ortográfico

... con alt+tabulador para hacerla visible. He visto en la documentación de CheckSpelling() https://learn.microsoft.com/en-us/office/vba/api/word.document.checkspelling que por defecto ignora las mayúsculas pero no se como pasarle el parámetro para que no lo haga. Agradecería ...
by Garbi
Wed Jan 11, 2023 12:19 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Corrector ortográfico
Replies: 3
Views: 445

Re: windows emulator

Thank you for advice. However, RDP (in my case) will not work. I will try to implement the task either on Android Studio or on MS Office Mobile (VBA)
by Natter
Fri Apr 22, 2022 7:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: windows emulator
Replies: 9
Views: 738

Re: Write to OPC

... https://documentation.unified-automation.com/uasdkc/1.8.0/html/clientgettingstarted1.html Also google for IID_IOPCServer vba and you may find some useful examples
by Antonio Linares
Thu Jan 20, 2022 11:57 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Write to OPC
Replies: 3
Views: 473

Re: ID of the current session

Natter,

Here you have the code in VBA. Its easy to port it to Harbour and FWH:

https://visualbasic.happycodings.com/api-and-miscellaneous/code42.html
by Antonio Linares
Thu Jan 06, 2022 5:55 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ID of the current session
Replies: 14
Views: 650

Re: Excel se queda abierto en el administrador de tareas

... poner al final de tu prg release oExcel  Resulta dificil saber las razones por las que excel se queda en el admor. de tareas. Hasta en los foros VBA se recomienda hacer un objExcel.QuitobjExcel= Nothing Mi entorno es rdp. Me da la sensacion de que abrir la misma excel por varios usuarios podria ...
by hmpaquito
Fri Dec 24, 2021 9:02 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Excel se queda abierto en el administrador de tareas
Replies: 5
Views: 720

Re: Quiero leer código de barras con un celular

... que tanto tu computadora como tu celular estén conectados a la misma red Wifi. https://techlandia.com/insertar-cuadros-texto-codigo-vba-excel-como_186800/ Saludos.
by karinha
Thu May 13, 2021 11:33 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Quiero leer código de barras con un celular
Replies: 3
Views: 429

Re: Excel fail when insert OLEObject with Word document

karinha,

No running.

Harbour and VBA, they dancing badly.

thks. Regards
by hmpaquito
Mon Apr 26, 2021 11:56 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Excel fail when insert OLEObject with Word document
Replies: 4
Views: 554

How insert checkbox in Excel

I want to place a checkbox character in Excel (character code E0A2 in font Segoe UI Symbol). This is the VBA code that I captured using the macro recorder     Range("E10").Select    ActiveCell.FormulaR1C1 = "K3  ?"  ...
by hua
Tue Mar 16, 2021 2:47 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: How insert checkbox in Excel
Replies: 0
Views: 278

Re: Copy Complete sheet op excel to another workbook

Hi,

In VBA it's like this
Code: Select all  Expand view
Sheets("Network").Copy Before:=Workbooks("Map19").Sheets(3)


How can I convert it to FWH?
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: 626

Re: Subtotalizar filas en excel

... Disculpa, no había entendido bien entonces. Con "macros" de Excel se puede hacer, pero desconozco si se puede ejecutar "código VBA" en Excel desde FW. Entre los master del foro pude componer la clase que te escribí antes, esperemos que haya alguien que pueda echarnos una ...
by Mike Serra
Fri Dec 04, 2020 3:23 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Subtotalizar filas en excel
Replies: 6
Views: 697

Re: Question about FWH and Excel

... 1 2 3... )oSheet:Name := "the name you want for your sheet"  PM me your mail I'll send you a code you can use to learn more about VBA methods and properties.
by ADutheil
Fri Sep 25, 2020 4:11 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1117

Re: Question about FWH and Excel

And how do you adapt vrom VBA to FWH?
by driessen
Thu Sep 24, 2020 3:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1117

Re: Question about FWH and Excel

Anytime I need something new I search Excel VBA examples and adapt them to FWH. As for RGB colors I don't know. Check below.

https://www.automateexcel.com/excel-formatting/color-reference-for-color-index/
by ADutheil
Thu Sep 24, 2020 3:43 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about FWH and Excel
Replies: 9
Views: 1117

Re: Saving a CSV-file as a Excel-file

... you make a mistake when think you can use Excel SaveAs(PDF). you can only use Constant from https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat PDF is a "End-User" Format that mean you can't load it again to Excel or Word without "Konverter" ...
by Jimmy
Thu Dec 19, 2019 11:15 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Saving a CSV-file as a Excel-file
Replies: 8
Views: 1109
PreviousNext

Return to advanced search