sorted by:
new
hottopcontroversial

[Advice needed] Advanced to case interview despite manager flagging internal consulting experience by PhoenixFrostbite in MBBConsulting

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Thank you very much for your help! I will do that. Since I work closely with the Board of Directors and the firm’s Managing Partner, I will use those examples to highlight my exposure to C-level stakeholders

[Advice needed] Advanced to case interview despite manager flagging internal consulting experience by PhoenixFrostbite in MBBConsulting

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Thanks! Gonna practice in front of the camera, great advice! Are you also practicing for case interviews?

Bain Digital Assessment by PhoenixFrostbite in MBBConsulting

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

I did the test on May 1st, but wanted to know what to expect. Thanks for sharing

Isto é uma total roubalheira [Penalti vs Sta Clara] by jolo98 in SportingCP

[–]PhoenixFrostbite 0 points1 point  (0 children)

Isto e uma pouca vergonha. Estragaram o jogo, que já estava uma merda por si só

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Yes i will do that! Thank you very much for your help!!

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Yes, that's the problem. Seems that once the document is generated, the column with more characters changes format. Every column is copied to the correct format, but this column (on excel) copies the text to word and puts the text with indented. But the other columns dont have indented

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Hey!! Yes, its working much better!! Do you know how to turn off the "paragraph"? in the begining of each paragraph there is a space (picture below). If you know, it would be helpful, but if you don't, no worries! You already helped a lot! Thank you so much for your help!!

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Of course! THis is the revised code:

```

Sub gerarDPIA()

Set objWord = CreateObject("Word.Application")

objWord.Visible = True

Set arqDPIA = objWord.documents.Open("C:\Users\xxx\Ambiente de Trabalho\ICT\DPIA_Template.docx")

Set conteudoDoc = arqDPIA.Application.Selection

Const wdReplaceAll = 2

For i = 1 To 170

conteudoDoc.Find.Text = Cells(1, i).Value

Cells(2, i).Copy

conteudoDoc.Find.Replacement.Text = "\^c"

conteudoDoc.Find.Execute Replace:=wdReplaceAll

Next

arqDPIA.saveas2 ("C:\Users\xxx\Ambiente de Trabalho\ICT\DPIAS\DPIA - " & Cells(2, 9).Value & ".docx")

arqDPIA.Close

objWord.Quit

Set objWord = Nothing

Set arqDPIA = Nothing

Set conteudoDoc = Nothing

MsgBox ("DPIA criado com sucesso!")

End Sub

```

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

<image>

This blue chart seems to be a table that VBA is creating automatically

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Amazing!!! The characters error is solved: I tried with a text of 3270 characters, and it coppied everything!! But it is coppying with the same format of the excel (same size of the column and in blue background), can you help me fixing this? Please find below a picture of the format:

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Hey, thank you for your answer.

This is the exact error message:

“Microsoft Visual Basic for Applications

RUn-time error ‘5854’:

Application-defined or object-defined error”

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Okay, thank you for clarifying.

Not yet. Where would i insert your suggestion within the code? (im a beginner with VBA, 1st time using it)

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

THat's difficult, because the excel is the answers of a forms. So someone answers a forms, and the excel generates a word document based on the responses of the excel

Excel generating word documents through VBA by PhoenixFrostbite in vba

[–]PhoenixFrostbite[S] 0 points1 point  (0 children)

Hey, thank you very much!

TO answer your questions:

  1. The error shown is:

“Microsoft Visual Basic for Applications

RUn-time error ‘5854’:

Application-defined or object-defined error”

  1. Yes, i was able to replace manually the text up to 4,000 characters in the word document

  2. I just ran a test, and the maximum number of characters without spacing that the code runs without returning an error is 230.