Results for "crash different use cases"

Good afternoon frostzen,

As your file is too heavy for this forum, can you copy your file in this shared folder (only shared with you)?

Do all of your colleagues use the same version of Excel as yours?

Hello everyone

I built a file template for quite a few colleagues. Until now, I never had an issue with it such as this one.

Just before to go in the detail, I want to pinpoint the fact it is not occuring for all the people using my template and that my colleagues are quite allergic to VBA and so I am pretty 100% sure they did not modify any code by themselves.

ISSUE:

- if a file using my template is opened with another Excel file (even a just newly empty one), if I close the file using the template, it will also close the second Excel file (without any warning). -> NOK

- It does this even after I cleared all the content of object "ThisWorkbook" (where we can write routines to excecute actions on closing or opening -> in this case I do not write anything) -> NOK

- deleting a module of that file using the template with macro activated will cause the crash of all Excel files (the entire Excel application in other words) -> NOK

- if now I disable the macros (using the Excel advanced security options), I can delete a module without the file to crash. And even re-enabling the macros (still using the Excel advanced security options) and closing the file, Excel does not crash. It does not matter which module is deleted, it could be any, but the ISSUE would not be present anymore -> OK

- if I try to delete a module using ''Application.EnableEvents = False", it does not work (Excel still crash). In order to delete a module without a crash, I must deactivate macros in the security settings of Excel -> NOK

The file using the template is quite light (5.7Mo) even if I coded quite a lot in different modules.

From my point of view, I feel like having too many modules overall is making Excel to crash. I hope I am wrong as then I would feel like VBA coding is disappointing.

Please help me. Your help will be very much appreciated.

Hi,

If you're new to VBA, you can find a course here:

https://www.excel-pratique.com/en/vba

Re,

A Power Query proposal to study.

Regards.

Hello there! I've been using Excel regularly for about a year now and I'm keen to expand my skills and explore more of what Excel can do. Could anyone offer some tips or point me in the right direction to boost my Excel proficiency, particularly in terms of VBA.

Jean-Eric

I love you, I love you, I love you...

Thank very much.

Much thanks to you and your patience, working with me especially with my English language.

You should become my excel teacher.

Greatly appreciated

Thank you again. God Bless You.

Hello Jean-Eric,

Thank you for your swift response.

Please view the sample file below.

Please note: the raw data is on cell "A1" and

The extracted data example is on cell "N" and cell "O"

There are many excel workbook I need to extract data.

How can I create a universal code to extract each one.

Thanks in advance. Greatly appreciated.

Hello,

Please attach a small file at your request.

Regards

Hello Fans.

Currently I have Many Raw Data as an example below to section out.

What's beautiful, all the following data are similar:

Here is an example in row "1", in column "A" only :

0: {c: 9, close: 9, yield: null, referenceDate: null, date: "1997-03-01T00:00:00", …}

In this Case: How can I Keep the values of The following:

9 1997-03-01

I have multiple data similar like above. The comparison with the others are, values and dates.

What is the effective way to get the data?

Or what code can I use? How do you want me to proceed?

Thanks in advance

Hi MatthieuB08,

test this file if it's you're wondering.

Good evening.

Dear all,

I wondering if there is a formula that could help me to obtain the following output (in orange) table :

Thanks in advance