Search results for query: *

...'Save selected worksheets as a PDF ClientFilename = Application.GetSaveAsFilename( _ InitialFileName:=ClientName, _ filefilter:="PDF, *.pdf", _ Title:="Save As PDF") ReDim Preserve strPDF(UBound(strPDF) - 1) Sheets(strPDF).Select...

...worksheets as a PDF ClientFilename = Application.GetSaveAsFilename( _ InitialFileName:=ClientName, _ filefilter:="PDF, *.pdf", _ Title:="Save As PDF") 'Export to PDF ActiveWindow.SelectedSheets(1).ExportAsFixedFormat _...

...'Save selected worksheets as a PDF ClientFilename = Application.GetSaveAsFilename( _ InitialFileName:=ClientName, _ filefilter:="PDF, *.pdf", _ Title:="Save As PDF") Sheets(Split(strPDF, ",")).Select Selection.ExportAsFixedFormat _ Type:=xlTypePDF, _...

...'Save selected worksheets as a PDF ClientFilename = Application.GetSaveAsFilename( _ InitialFileName:=ClientName, _ filefilter:="PDF, *.pdf", _ Title:="Save As PDF") If bSelReplace Then MsgBox "Nothing to print selected" Else...

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

...'Save selected worksheets as a PDF ClientFilename = Application.GetSaveAsFilename( _ InitialFileName:=ClientName, _ filefilter:="PDF, *.pdf", _ Title:="Save As PDF") Sheets(Array(strPDF)).Select Selection.ExportAsFixedFormat _ Type:=xlTypePDF, _...

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