Loading...

Follow Excel Help Forum on Feedspot

Continue with Google
Continue with Facebook
Or

Valid


Im trying to pass data from an Excel sheet to a Word doc, I've created the most basic of test code but no matter what I try I always get the same "ByRef Argument Type Mismatch" error.
In Excel
Code:
Private Sub CommandButton1_Click()
Dim Wd, Doc
Dim aaa As String
aaa = "a,b,c,d,e,f,g,h,i,j,k,l"
Set Wd = CreateObject("Word.application")
Set Doc = Wd.documents.Open("C:\CompC10 Cust Excel2.docm")
Wd.Visible = True
Wd.Application.Run "test", aaa
Doc.Close
Set Doc = Nothing
Wd.Quit
Set Wd = Nothing
End Sub

While the Word doc has
Code:
Sub test(aaa as string)
msgbox aaa
End Sub
I've tried adding ByRef, ByVal etc but always the same error

Anyone tell me what Im doing ridiculously wrong?
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi Folks,

I have a spreadsheet that keep league stats on our local pool team.

Each player has their own tab with stats on who they have played. Where the player has played on a doubles game I would like to bring show who they were partnered with for the game. In the attachment I have inserted a column (L) in the tab entitled Phil Barber. So far I can VLOOKUP the game from the 'Results' tab but can't figure a way to bring through who he played with.

In the results tab the doubles games always have a blank line both above and below the game. I can VLOOKUP to bring through Phil but I need a formula to check if the cell above Phil is blank or not. If it is blank bring through the value below the VLOOKUP and if it is not blank bring through the value above the VLOOKUP.

I appreciate this doesn't make much sense but maybe the attachment may help.

Thanks
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi All,

Day Greetings,

Have Query regarding comparing two week Cell value and if the current week sale is less then past week so want to highlight in red text.

Have Attached Excel file with desired result, please help for same as now time i am doing it manually.

Response are highly Apprenticed
Attached Files
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi All

I have a piece of code that works great but I would like to know how I can call it from a hyperlink. But this needs to be applied if i copy the hyperlink to the cells below it.
I.E. C1 will have the hyperlink which pulls reference from A1 & B1. I need to copy the hyperlink to the cells below so that clicking on the hyperlink in C2 now, will pull info from A2 & B2....and so on.

Any assistance would be greatly appreciated
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi,

I am trying to construct a spreadsheet that calculates what notes/coin to give as change.
Under a specific set of calculations, even though both INT and TRUNC functions return a "1" result, when nested into an IF function they return a zero.
In the last entry line of the attached workbook, everything is fine until you enter $500 as the amount tendered. The formula in cell O4 then falls over and I get a zero result, even though the nested TRUNC function has a result of 1.
What am I doing wrong?
Regards,
Gary
Attached Files
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hello,

I'm looking for a few different formulas to find the max, min and average for a range.

I have every date from January 1 to December 31 down Column "K" with a list of numbers beside the date in the next column.

I'd like to find the average (excluding zeros), min (excluding zeros) and max for all of the Sundays, Mondays, Etc.
Thanks.
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hello,

I have one data sheet (tst1.xls) and by power query, i transfer data to another excel document (tst2.xls) where i add manually one column.

Problem occurs filtering the data in tst2.xls. For example, first i filter power query data (column data - value 1) and after that column data3 - value x. Then all information is messed up.
Is there any trick to avoid the mess?

Thanks,
Siim
Attached Files
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Safed Musli health benefits are also regarded as healer of asthmatic conditions. If you are looking for a product to solve your problems in bed then Zenerx male sexual enhancer may just be the answer. Aside from having a soothing and pleasing aroma, it works as an aphrodisiac like Clary sage. Its a must for any man recovering from a reversal process.

Are you ever embarrassed when it comes time to make love to your lady and you can't or you just do not have the energy? An apple a day keeps doctor away and increases the sperm count as well. These symptoms include depression, thinning hair, diminishing sexual ability, irritability, and feelings of doubt.

They can be very harmful and do not create a favorable atmosphere for the baby in the mother's womb. A eating plan that is higher in sugar, cholesterol, processed meat, and refined grains produce conditions unfavorable for male libido enhancement. Even though it may have enhance male some good benefits there are side effects. Worst case scenario you get to check out a brand new recipe. The first type of pill is called Sinrex L-Arginine HCL time release capsule.

https://wrinklerewindfrance.com/phytolast-france/
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Reducelant Garcinia There is a very obvious physical connection between weight loss and dating. To do this, she should split the 500 calories between her nutritional needs and additional cardio - reducing her 2,100 calories by an additional 250 calories and doing 250 calories worth of additional cardio every day. Since 1 lb of body fat equals 3,500 calories Judy will need to create an additional caloric restriction of 3,500 calories over 7 days, or 500 calories per day. As a mother of two who's been struggling all life with popular diets, Acai changed my life forever!


https://acaiultralean-france.com/reducelant-garcinia-france/
Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Hi Forum,

I am using the following code to send a file to an Outlook contact group I created myself which has a unique name, e.g. "List Europe":

Code:
Public Function Sendout(strRecipients As String, strSubject As String, strPDF As String) As Boolean
   
    Dim wbCC    As Workbook
    Dim wsMain  As Worksheet
    Dim wsSO    As Worksheet
   
   
    Set wbCC = Workbooks("Control-Center.xlsm")
    Set wsMain = wbCC.Worksheets("Main")
    Set wsSO = wbCC.Worksheets("Sendout")
   
    With Application
        .DisplayAlerts = False
        .ScreenUpdating = False
    End With
   
    If strPDF <> "" Then
        wsSO.Activate
        wsSO.Range("A1:B1").Select
       
        With Selection
            ActiveWorkbook.EnvelopeVisible = True
           
            With ActiveSheet.MailEnvelope
                .Item.To = strRecipients
                .Item.Subject = strSubject & strDate
                .Item.Attachments.Add strPDF               
                .Item.Send
            End With
           
            ActiveWorkbook.EnvelopeVisible = False
        End With
       
        With Application
            .DisplayAlerts = True
            .ScreenUpdating = True
        End With
       
        Sendout = True
        Else:  Sendout = False
    End If
       
End Function
When running my code, the Outlook "Check names" box pops up and offers more than just the list I handed over to my function, but other lists containing the words "List" and/or "Europe", e.g. "Europe second list".

My question is, how can I suppress this pop-up and force the code to use just exactly what I handed over?
Thanks!
Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free year
Free Preview