Results for "code macro use substitute text column"

Re,

A Power Query proposal to study.

Regards.

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,

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

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

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 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.

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.

I see. The website site have updated it column to "Reference". Before it was "Blank" no wording under the column. Thanks again. Greatly appreciated.

Hello,

I reviewed the PMI request.

Is this the expected result?

"Hello,

What is the object of the "Added prefix" steps?

Regards."

Is to change the "Reference" column to "DATE" format

Hello,

What is the object of the "Added prefix" steps?

Regards.

Hello Everyone or Anyone.

Can You help me out with something.

I am trying to refresh my data links.

But I am getting an error that says: "expression.error the column of the table wasn't found"

How can I fix this?

Please if you are welling, please view.

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

Welcome enerkey !

Is it possible to get your excel file, if possible a simplified one that show the problem you encountered ?

I have been faced the same excel issue. I could not text align to the right in my excel sheet. I got the solution when I change my code. But I have been faced another excel problem because sometimes

. So excel users also got the error.

May be it depends on your web browser or mail application.

So try this

                             StrBody:="<H3 align= right><B>in honor of " & SendTo & "</B></H3>" & _
                                      "<p align= right>TEXT TEXT TEXT TEXT </p>" & _
                                      "<br/><p align= right>End of TEXT</p>"

This is the result

two things:

The first, variable "sendTo" goes down a line, it should be in the first row.

Second, except for the first line the rest of the text is still on the left.

Begins to despair.

Attached print screen

Thank you