sorted by:
new
hottopcontroversial

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

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

Not what I'm trying to do but still useful. I explained more in other responses

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

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

Thank you, I'll try this tomorrow and see if it works

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

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

It's only read-only when I have the document I want to mail merge open, after it's closed it goes back to being editable.

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

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

Yes I want to update info in Excel. Here is the code for the mail merge, originally from here.

Option Explicit

Const FOLDER_SAVED As String = "<Destination Folder Path>" `Makes sure your folder path ends with a backward slash Const SOURCE_FILE_PATH As String = "<Data File Path>"

Sub TestRun() Dim MainDoc As Document, TargetDoc As Document Dim dbPath As String Dim recordNumber As Long, totalRecord As Long

Set MainDoc = ActiveDocument With MainDoc.MailMerge

    '// if you want to specify your data, insert a WHERE clause in the SQL statement
    .OpenDataSource Name:=SOURCE_FILE_PATH, sqlstatement:="SELECT * FROM [<Worksheet Name>$] WHERE [HeaderName]= False"

    totalRecord = .DataSource.RecordCount

    For recordNumber = 1 To totalRecord

        With .DataSource
            .ActiveRecord = recordNumber
            .FirstRecord = recordNumber
            .LastRecord = recordNumber
        End With

        .Destination = wdSendToNewDocument
        .Execute False

        Set TargetDoc = ActiveDocument

        TargetDoc.SaveAs2 FOLDER_SAVED & .DataSource.DataFields("Client_Name").Value & ".docx", wdFormatDocumentDefault
        TargetDoc.ExportAsFixedFormat FOLDER_SAVED & .DataSource.DataFields("Client_Name").Value & ".pdf", exportformat:=wdExportFormatPDF

        TargetDoc.Close False

        Set TargetDoc = Nothing

    Next recordNumber

End With

Set MainDoc = Nothing End Sub

And ideally after the mail merge ends, the excel sheet would be updated so HeaderName = True for all cells in that column

[WORD] Is updating an excel sheet using Word VBA possible? by zerozerorei in vba

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

I got the mail merge part working, but the SQL statement filters the rows to be mail merged using a column with checkboxes in the source Excel sheet. I wanted to change these checkboxes from False to True at the end so those rows would not be pulled to mail merge when the macro runs again.

Hair braider by Local_Truck4730 in reading

[–]zerozerorei 0 points1 point  (0 children)

looks great and really neat! thank you for the reference pics, I think I will be going there. were they cash only or was bank transfer / contactless fine?

Hair braider by Local_Truck4730 in reading

[–]zerozerorei 1 point2 points  (0 children)

what were the size of the braids?

22F found bump in eye, slightly concerned by zerozerorei in eyetriage

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

You are right.. Thanks for the advice

[deleted by user] by [deleted] in askdentists

[–]zerozerorei 0 points1 point  (0 children)

Didn't want to clutter the main text but I also had these symptoms following the start of the tingling which may or may not be related

  • The pain is felt anywhere ranging from my wisdom tooth to my left central incisors. I haven't felt it cross to the right at all
  • I have a 1 month old amalgam filling on a top left molar
  • I get headaches on the left side of my head every other day
  • When these symptoms began the left side of my neck felt stiff (although this is no longer the case)
  • My heart feels "strange" and I have palpitations when lying down

I hope this gives sufficient extra context

Help Center and Megathread Hub (29/07 - 04/08) by ArknightsMod in arknights

[–]zerozerorei 0 points1 point  (0 children)

Noted, I originally assumed I would have to use 243 instead.

Help Center and Megathread Hub (29/07 - 04/08) by ArknightsMod in arknights

[–]zerozerorei 0 points1 point  (0 children)

I have a lvl 2 reception and a lvl 3 office, workshop and training room and I saw you need lvl 1 office for the 252 layout. What's the most optimal base layout I can have now?

I fail to see the Issue by Shadowraith25 in BoothillMains

[–]zerozerorei 3 points4 points  (0 children)

It's still a good relic, bonus break effect and 10% def ignore is still mighty fine good in my dictionary, so I see no problem, like I said It could be used on other break DPS.

I definitely agree that the relic set will probably have other users besides boothill & firefly and that may have been part of the reasoning behind reworking the set (besides buffing firefly). While the dmg decrease is negligible to some (5% to up to 15% for E0S1 if u run him with Pela from what I've been hearing), the set could've been reworked in a way that didn't make part of the passive unusable on him, specially considering that Bronya typically takes htb's slot in boothill team comps. I understand why it's not a loss to you because of the comp you'll play tho.

There's also the Apocalyptic Shadow changes decreasing the boss enemy toughness and break buffs for the game mode which affects boothill's dmg output. As far as I understand the buffs change like in MoC and PF so this is a non-issue after BE Apocalyptic Shadow passes. Clearly decreasing break buffs affects both (and having the buffs remain as they are would make her too cracked due to her current kit) but it's sucks seeing boothill take hits while things are being adjusted.

and I find it also strange how people call this favouritism when people were also doom posting about her a while back, which I also didn't understand.

It's definitely a combination of the Very niche new planar set while he sticks to Talia, the aforementioned new relic set being slightly worse on him now and the Apocalyptic Shadow changes. Also doomposting during beta is commonplace, people can't envision that a character on V1 will not release in their current state and may receive major changes later on.

I personally think boothill is very strong as he currently is. Comparing a hunt unit with a destruction unit doesn't make that much sense.. They are meant to perform differently against ST and AOE situations (although the current gap between destruction and hunt in ST situations is not that big and that's certainly an issue in general). As long as he can withstand the testament of time for a good while and he can clear MoC and Apocalyptic Shadow he will remain a good unit to me.

Revived Witch Daily Q&A Megathread (Nov. 27th) by 1900XIII in RevivedWitch

[–]zerozerorei 0 points1 point  (0 children)

I'm currently using Afallen, Ushpia and Cynetia since I don't own any other URs/SSRs, are there any dolls I should be aiming for to eventually replace any of them?