FiveTech Software tech support forums

Michael,

Code: Select all  Expand view

oBook:SaveAs("Test.xls",xlExcel8)

Format saveas
https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas

List fileformat:
https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat

driessen wrote:Can you tell me where I can find all this necessary information?

Create a macro in Excel and look at the generated VBA.

See http://wiki.fivetechsoft.com/doku.php?i ... aq&s=excel . There are 2 links to excel related FAQ that you can use as a starting point

I don't think there's an online complete guide for FW/Harbour. My advise is you search VBA + Excel and adapt your findings to Hb/Fw. That's the way I did. If you have other specific questions about this topic I may be able to answer because I've done many OLE routines. ...

... de gráfico. Y para saber los gráficos disponibles (apuesto a que no te los acabas), consulta : https://docs.microsoft.com/en-us/office/vba/api/excel.xlcharttype Saludos //---------------------------------------------------------------------------METHOD Save2XLS( nTypeGraph ) ...

... de gráfico. Y para saber los gráficos disponibles (apuesto a que no te los acabas), consulta : https://docs.microsoft.com/en-us/office/vba/api/excel.xlcharttype Saludos

Hi, all !

VBA (Excel) has an AscW() function. It is used to obtain the Unicode character code. How do I do this on FW ?

... sé adolecemos de eventos en nuestras clases OLE y por tanto no puedo definir el evento Send. https://stackoverflow.com/questions/2533066/vba-outlook-mail-display-recording-when-if-sent-manually Me pareciera que lo que otros compañeros hacen, cuando han de editar el mensaje a enviar, es ...

Hi guys, I'm trying to open multiple pipe delimited text file into the same excel file albeit within different sheets. How to convert VBA macro code generated below to FWH/[x]Harbour's code? With ActiveSheet.QueryTables.Add(Connection:= _        "TEXT;C:\test\pay32\LHDN\E9139122309 ...

... ole error. Is there a way to block Excel from executing if is already running in memory ? Or to intercept the errors inside the program like in VBA with the "On Error" statement ? Thanks a lot. Massimo

Otto,
This is cool. I have a similar requirement.
Do you have a VBA script that can post an email body and its attachment into a dbf?

TIA

... "MAPI" )    oInbox := oNameSpace:Get( "GetDefaultFolder", 6 ) // Enumeration: https://msdn.microsoft.com/en-us/vba/outlook-vba/articles/oldefaultfolders-enumeration-outlook    oExplorer := oOutlook:Explorers():Add(oInbox, 0) // Enumeration: https://msdn.microsoft.com/en-us/library/microsoft.office.interop.outlook.olfolderdisplaymode.aspx  ...

Amigos tengo esto y funciona bien : local oExcel := CreateObject( "excel.application" ) local oBook := oExcel:Workbooks:Add() local oSheet oSheet:=oExcel:ActiveSheet oSheet:=oBook:Worksheets( 1 ) oSheet:Shapes:AddTextbox(1, 50, 125, 250, 130):TextFrame:Characters:Text = "EMPRESA PRINC...

...   On this desktop are 50 emails comfortably. 2.1. HOW DOES eMailDeskTop WORK Incoming emails are copied with by VBA script to the folder eMailDeskTop in Outlook. A Fivewin – program copies these emails as a msg and rtf file and a INI file to a folder on the disk. ...

SGS, veja o link https://msdn.microsoft.com/pt-br/librar ... 94819.aspx
tem um exemplo em VBA

algo do tipo
ActiveWorkbook.Close SaveChanges:=False

talvez ajude


e

http://www.pctoledo.com.br/forum/viewto ... =4&t=14925

oExcel:ActiveWorkBook:SaveAs(cARQ,50)

... https://github.com/Fedict/eid-mw/wiki/SDK40#Introduction Here is a VBA wrapper: https://github.com/jdt/EID.Wrapper I did't try it yet.