Search results for query: *

Hello All, In the interest of helping other people who are searching for a similar solution. Here is the code to ExportToPDF using an Array. Sub ExportToPDFArray() 'December 2019: Uses an Array to collect which sheets have been selected to be exported to PDF Dim strPDF() As String...

Hello All, I truly appreciate all the help and feedback to my question. I have taken combo's suggestion and wrote the following: Sub ExportToPDFBoolean() 'December 2019: I like this one as it is clean and short, and I can explain how it works :) On Error Resume Next Dim strPDF As...

Hello combo; Using the Split() and iif(), I wrote the following: Sub ExportToPDFString() Dim strPDF As String Dim ClientName As String Dim ClientFilename As Variant ClientName = Range("Client_First") & Range("Client_LasT") 'Non Reg Client If Me.chkNonRegClient =...

Hello combo; Your comment about checking to see if anything was selected before exporting makes sense. So, I followed your example and wrote the following: Sub ExportToPDF() 'On Error Resume Next Dim strPDF As String Dim bSelReplace As Boolean Dim ClientName As String Dim...

Hello All, I have reworked my code as per strongm's suggestion: 'Non Reg Client If Me.chkNonRegClient = True Then strPDF(UBound(strPDF)) = "Non_Reg_Client" ReDim Preserve strPDF(UBound(strPDF) + 1) End If 'Non Reg Spouse If Me.chkNonRegSpouse = True Then...

Hello combo, I will have to try Sheets(Split(strPDF,",")) when I get back to my production computer to test this out. I will respond with the results later.

Hello mintjulep, I agree . . but, I am working within my current skillset and "directly populate an array" is what is eluding me. I have done a variation of the above code with: dim strPDF(9) as Variant If me.chkNonRegClient = True Then strPDF(0) = "Non_Reg_Client" End if If...

Hello strongm, That could be the case. However, when I select items and include the Dep_WD_Summary option this is what I get in the immediate window: ? strpdf "Non_Reg_Client", "TFSA_Client", "InvestmentAccountSummary", "Dep_WD_Summary" Given the above I am not sure why...

Hello All, I have a form that allows the users to select (via checkbox) which sheets they would like to combine into one pdf output. As my title says I am getting an "Error 9 - subscript out of range" error. Any help would be greatly appreciated. Private Sub cmdPDF_Click() 'On Error Resume...

Hello Julie, Using both Project 2010 and 2013. Thank you for the information. This is a setting that I was not aware of. Regards, Michael

Hello All, The various tables, views and reports all use the "Baseline" field value for their calculations, including "Earned Value". Has anyone created a custom table/view or report showing Earned Value data using Baseline1 or any of the other Baseline"x" values. I can create a custom table...

Hello Mike, I have read similar postings on this topic and I have even added a batch file for the user to run which will delete all files in the OLK folder. The user reported that he had run the batch file and had even navigated to the Temporary Internet Folder (TIF) to confirm there were no...

Hello Mike, I will have to get back to you about opening the email from the attachment folder. The version of ACT! is v10 Regards, Michael

Hello All, A client has been having difficulty opening attachments that are part of an email which ACT! has stored. The email settings are to save the entire email plus attachments as a history item. When he attempts to open the attachment he gets the following error message: I have found out...

A user (Fred) has the following error message appear when attempting to open an email in the contact history: The email was added to the contacts history from a different user (Tom), however other users are able to successfully open the message. The user in question (Fred) is able to open...

Hello PHV, It works!!! Thank you. Now, all I have to do is figure how/why it works :-) Here is the complete working code in case someone else is looking for a similar solution. Sub CreateSubtotal() Dim arrCol() Dim FC As Long Dim i As Integer FC = Cells(1...

Hello PHV, Thank you for your reply. This is the (updated) code using your example: Sub CreateSubtotal() Dim arrCol() Dim FC As Long Dim i As Integer FC = Cells(1, Columns.Count).End(xlToLeft).Column '<--This value is 8 ReDim arrCol(FC - 6) For i = 6 To FC arrCol(i)...

Hello All, I am using the "subtotal" menu command to group and subtotal a list of information. The code created is the following: Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(6,7,8), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True The issue is that the...

Hello All, When doing a mail merge with output to email and with an attachment we have noticed each contact has a copy of the attachment in the history. Is it possible to do the mail merge with an attachment but only have the history created, but not have the attachment included in the history...

Hello Andy, When teaching I tell the class that "there will be someone in this room that knows more about this Office product in one specific area than I do, as they are using that specific feature all the time. What I bring to the class is a better overall knowledge of the product." I actually...