Jump to content
Fivewin Brasil

COMO SUBESCREVER E FECHAR PLANILHA EXCEL NO FIVEWIN


bortot

Recommended Posts

A PLANILHA DEPOIS DE ALTERADA COM VALORES DAS CELULAS  NAO SUBESCREVE A ORIGINAL CASO NAO

FOR  SALVA E FECHADA PELO EXCEL DA MICROSOFT

TRECHOS DA PROGRAMACAO:

 oExcel:= TOleauto():New( "Excel.Application")
 oExcel:Workbooks:Open(endereco file.xls)

ALTERACOES NAS CELULAS

oExcel:Visible = .F.

oExcel:AlertBeforeOverwriting = .F.
oExcel:DisplayAlerts = .F.

oExcel:Workbooks:Close()

oExcel:Quit()
 

Link to comment
Share on other sites

Acho que vocês se esqueceram do principal, salvar:

oExcel:ActiveWorkbook:Save()

Contatos profissionais:
Site | Facebook | YouTube

 

Em 26/03/2023 at 10:31, bortot disse:

A PLANILHA DEPOIS DE ALTERADA COM VALORES DAS CELULAS  NAO SUBESCREVE A ORIGINAL CASO NAO

FOR  SALVA E FECHADA PELO EXCEL DA MICROSOFT

TRECHOS DA PROGRAMACAO:

 oExcel:= TOleauto():New( "Excel.Application")
 oExcel:Workbooks:Open(endereco file.xls)

ALTERACOES NAS CELULAS

oExcel:Visible = .F.

oExcel:AlertBeforeOverwriting = .F.
oExcel:DisplayAlerts = .F.

oExcel:Workbooks:Close()

oExcel:Quit()
 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...