Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Storyteller

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

    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 =...
  4. Storyteller

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Error 9 - Subscript out of range selecting sheets from UserForm

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

    Earned Value calculation using Baseline1 or Baseline"x" values

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

    Earned Value calculation using Baseline1 or Baseline"x" values

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

    Another error when opening attached email

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

    Error opening email attachments

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

    Another error when opening attached email

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

    Error opening email attachments

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

    Using variables with ParamArray

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

    Using variables with ParamArray

    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)...
  18. Storyteller

    Using variables with ParamArray

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

    Mail merge with attachments (v2009)

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

    Question during Advanced course

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

Part and Inventory Search

Back
Top