provider

Trying to help a friend. A, B, C. etc. are names of software providers and ID numbers are assigned to customers. Friend has this data set and is trying to get a list of all the software providers that a given ID number has (not just a count). I tried copying the data and then saying if B2>=1...

Hello, I have to use some excel files as sources for a Power Pivot I can't connect to the excel files. The files are already tested on another computer and they work The error message is (more or less) the provider information are not included in the connection string. Please add them and...

=IF(Checklist!B27="","",VLOOKUP(A176,Features,2)) I have the above formula on my worksheet A176 has the value Feature 10. The Named Range is the following; <colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"...

I am trying to set up a file to auto log into Hypersion. Declare Function HypConnect Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtUserName As Variant, ByVal vtPassword As Variant, ByVal vtFriendlyName As Variant) As Long Declare Function HypCreateConnection Lib "HsAddin" (ByVal...

I'm having issues with retrieving data fro access and putting it in excel. I am using the Microsoft.ACE.12.0 provider and it is saying that it isn't installed although I am using Excel 2016 which should work.

Hi all, i'm usually good with formulas but this ones got me crazy, i'm trying to add up a bill because i think my network provider is pulling a fast one: I'm trying to add a these sort of formats: http://imgur.com/a/U2FyN Thanks for your help guys!

I need to calculate the total amount due for a client. I have a range of cells that list the service provider (C9:E39), the amount of hours provided (B9), and the provider's hourly rate (Total Hours J6) which corresponds to the provider (Total Hours B6). Total hours B6 and J6 vary by provider...

Hi everyone, I'm hoping someone here can help me (after spending hours of researching, I cannot find the solution to this). I am working on a project around tracking certain items being sent out to certain providers and monitoring if we get anything back from the providers. However, the...

Here is my scenario: I have a need to find a particular percentile from a header row on another sheet in a separate tab within the same workbook, based on criteria from two columns in another worksheet. See example below: <colgroup><col width="101" style="width: 76pt; mso-width-source...

Hi All, My issue is that I get a error message "The file you have chosen is in use. Please close the file before you import". I am in Diagram View, go to existing connections and double click the source file that is an xls, file saved on the share point. My goal is to import a new column I...

Hello guys, I am learning VBA by myself and I saw some codes that have the expression provider in it, like this one Connection.Provider = "Microsoft.ACE.OLEDB.12.0" I can not understand what is the function of the Provider in this case and where I can find the code in the...