Recent content by Storyteller

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