Search results

It used as database the own Workbook .exe and SQL via DAO connection, making the call to the database with the code below: Set db = OpenDatabase (ThisWorkbook.FullName, True, False, “Excel 8.0”) I used PathToComplileFile as you indicated in your last answer, but it didn’t work either. When I...

How to update, save attached .xlsm file inside .exe?

Grateful for the answer. But it didn’t work out for what I need, it was my fault that I didn’t explain better. In the same Workook some spreadsheets are front end and others are backend (database). This is the process: 1.Enter the value in the cell (Spreadsheet-Frontend) 2.The value is copied...

How do I access the .xlsm of the virtual drive to write information? If possible I may communicate between two protected workbooks (.exe). I use the active workbook itself as a database, and to connect it I use: db = OpenDataBase (ThisWorkbook.Fullname, False, False, Excel 8.0) But it is not...

I create at runtime Combobox, Textbox, Checkbox. works, but does not save changes or additions to text in .exe

Hello! I use static ActiveX controls and also create them at run-time, but Workbook.exe does not save the changes made in Frontend. How do I save the changes? Thanks!.

Hello! I use static ActiveX controls and also create them at run-time, but Workbook.exe does not save the changes made in Frontend. How do I save the changes? Thanks!.

Sorry, I speak basic English, I used the translator to correct the post and the title. Waiting for your help. Grateful!

Hello! I use static ActiveX controls and also create them at run-time, but Workbook.exe does not save the changes made in Frontend. How do I save the changes? Thanks!.

Grato pela resposta. Funciona quando a extensão não é .exe O 1º Arquivo é .exe e necessita abrir e referenciar célula no 2º Arquivo, também .exe Tentei o código fornecido por vocês mas não obtive êxito. O que estou fazendo de errado? Public Function PathToFile(Filename As String) Dim...

Tenho um executável (.exe) Excel que necessita em tempo de execução abrir outro executável (.exe) Excel. O 1º .exe chama rotinas do 2º .exe, que executa uma consulta SQL e retorna ao 1º .exe o restultado. Como .xlsm está funcionando, mas ao compilar para .exe não consigo. É necessário que os...