Recent content by Valentine

This is what I have currently and it does SOME of what I want. The Initial Report that I want to insert pages into prints properly and the CNF reports print properly, but the part of the code that tries to insert the CNF Reports into the Nominations report is not working. I do get the...

I am trying the easiest route haha and I have already done the array way, but if there is a way to merge from Dir() I will definitely like to try that. Everything I have seen on merging pdfs is print them and then merge them as an array I have no idea how to do it otherwise.

How do I put that into an array though without knowing the total number of files? If I go files = Dir("C:\Users\Justin\Documents\", "CNF*") How do I get them into the array to merge them?

Switching gears slightly, I am now trying to loop through the folder and grab all the pdfs with "CNF" in the front. I want to create an array with this but don't know how to write it. Public Function LoopThrough(strDir As String, strType As String) Dim file as Variant If Right(strDir, 1) <>...

I found this: https://wellsr.com/vba/2017/word/combine-pdfs-with-vba-and-adobe-acrobat/ But again I don't know the exact number of files to be merged each week, is there a way to do this without knowing how many files?

Neither of those worked for me. I made a Report that reads like a Word document and when I push the button it prints that report to a folder in pdf format as well as 1 - n of my requirement reports. I want to be able to combine those pdf files into 1 using VBA. I don't know the exact number...

Good afternoon, I currently have a button that prints 1-n reports in PDF format. I know how to combine those PDFs into 1 using VBA if I have the exact number of reports being printed. Some weeks I will print 1 and some weeks I can print up to 6. My question is: Can I make an array count...

No I am trying not to split, I want it to scroll down through the data.

So I have an Excel spreadsheet that has 4 title rows that I want to freeze when they are at the top of the screen when scrolling. For easy lets say my title rows are 1, 100, 200, and 300. When I scroll down the spreadsheet I want row 1 frozen until I hit row 100 which I want to take over as...

wow that was more then I expected it to be but it works now I had to do a little more work but mine looks like this: Forms("Copy of CAPESform").[Subform Capes to Validation].Form.[Validation Date] my main form is called "Copy of CAPESform" Subform called "Subform Capes to Validation" field...

I have a subform that has 1 item in it, the Validation date of my item. On the form the subform is linked through item and displays the date properly. I have a button that I am using to send out an email but want to include the date value in the email. I cannot use Me.value because it is in...

Thank you it works perfectly now. I spent like 3 hours trying multiple different things OTHER then removing the parenthesis, these little things make me feel like a moron.

Functions confuse the hell out of me. xlSh.range("D3").Autofill Destination:=xlSh.range("D3:ND3"), Type:=xlFillWeekdays 'Set months title With xlSh.range("D1", "AH1") .Font.Bold = True .Font.Size = 12 .VerticalAlignment = xlVAlignCenter...

I have : Set xlApp = CreateObject("Excel.Application") Set xlWB = xlApp.Workbooks.Add Set xlSh = xlWB.ActiveSheet I want to pass that through a function that fills in the rest of the information into the spreadsheet depending on if its a leap year or not. currently : If...

NM I am dumb just select the 3rd option when I create the combobox and move over what i want to sort by. I have never done that before and didn't know it was that easy.