Results for "tips starting intermidate use vba"

Hi,

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

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

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.

Re,

A Power Query proposal to study.

Regards.

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.

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 ! Lisa Nguyen,

Here, your Excel File is back, with automatic conversion.

If you agree, you can display the corresponding color with your VBA Module3. Sub RGB_TO_HEX_COLOR()

See my Note in Sheet1.

Hi,

a proposal. select the day in L5, check if this works for your excel version.

You speak french, don't you? you can post your message in the french speaking part of this forum.

hi,

code fixed for the update.

Hi,

You need to enter your VBA code here (for example, the sample code):

Then, list the names to be replaced below:

And you will then get the obfuscated code:

Breaking News,

Excel File Version2 is coming Now.

Best Regards.

Thank you for the solution, Merci beaucoup!

Sorry for not clearing the things, it's something like this , so what i'm looking for is a fucntion that allows me to see the content of each day only by clicking on the day ( like when i click on Monday, it shows automaticly the subject and its content..)

Hi,

Your request is quite short. Can you explain a little bit more and provide us with a sample excel file with some basic datas and the expected results ?

I have to create a Time table including the Subjects + their content, and i need to combine between all these elements.. anyone can help?

I understand you. Thank you

Dear,

To solve your problems, I would completely redesign and rework your application, but that's not the kind of application I want to spend time on.