My Visual Database — Does not run Excel evev when is in AUTO selected

Re: Does not run Excel evev when is in AUTO selected

null@example.com (jean.brezhonek) — Mon, 12 Aug 2024 06:33:18 +0000

Hello pozidis, Derek, Sparrow
1 - You install on your machine Excel or Calc of LibreOffice or both.
2 - You place on a form the possibility to choose your spreadsheet
3 - If Excel, you select in Action the Excel option - If Calc, you check in Action the Libre Office option
4 - In Action, the Auto mode lets MVD select the spreadsheet already present on your machine (Excel or Calc) (if this is the case)
5 - If no spreadsheet is present, you are out of the game and MVD will wait for you to resolve your case.
See in PJ how I do it and it works every time
JB

Re: Does not run Excel evev when is in AUTO selected

null@example.com (v_pozidis) — Sun, 11 Aug 2024 22:21:10 +0000

Hi sparrow. Thanks for the link. If I understand correctly it checks if there is a program to execute xls files. Because I can not understand the script can I just copy and paste it or must I modify it?

Re: Does not run Excel evev when is in AUTO selected

null@example.com (sparrow) — Sat, 10 Aug 2024 19:05:09 +0000

https://myvisualdatabase.com/forum/view … hp?id=5403

Re: Does not run Excel evev when is in AUTO selected

null@example.com (v_pozidis) — Sat, 10 Aug 2024 19:00:19 +0000

Thank you sparrow, fyi the link doesn't work. Anyway I will try to uninstall and install it again.
Thank you.

Re: Does not run Excel evev when is in AUTO selected

null@example.com (sparrow) — Sat, 10 Aug 2024 18:47:42 +0000

If the program does not find registry entries about Excel or Calc on your computer,
it cannot call and execute export functions (OLE automation).
I previously gave a link to what parameters and how they are checked.
I checked the operation of MVD on a clean virtual machine with LibreOffice x64 24.2.5.2 installed.
MVD works and performs export in auto mode.

Solutions for you may be:
- uninstall and reinstall LibreOffice on your computer
- save to a CSV file and open in the desired program

Re: Does not run Excel evev when is in AUTO selected

null@example.com (v_pozidis) — Sat, 10 Aug 2024 17:17:07 +0000

Is there a script to open the tablegrid in excell or better Auto (excel and openoffice) ?

Re: Does not run Excel evev when is in AUTO selected

null@example.com (v_pozidis) — Thu, 01 Aug 2024 06:39:57 +0000

Hi, I tested my program in another pc and works fine. Conclusion..my pc must have some problem... Must find now where!!!
Thank you all.

Re: Does not run Excel evev when is in AUTO selected

null@example.com (sparrow) — Wed, 31 Jul 2024 12:06:34 +0000

Hi v_pozidis, hi Derek

https://myvisualdatabase.com/forum/view … hp?id=5403

Re: Does not run Excel evev when is in AUTO selected

null@example.com (derek) — Wed, 31 Jul 2024 11:43:20 +0000

Hi,
Like you, I do not have Excel but both options of 'Auto' and 'OpenOffice' work for me without any issues (Windows 10 / MVD 6.5).
Perhaps attach your project to see if something else is the problem.
Derek.

Does not run Excel evev when is in AUTO selected

null@example.com (v_pozidis) — Wed, 31 Jul 2024 10:24:13 +0000

Hi all,
I got an error "The system cannot find the file specified, ProgID: :Excel.Application" . I don't have installed the MSOffice but I have the LiebreOffice installed, and in the Button I have select AUTO to work with both office suites. Does anyone knows how to solve it ?