1. R


    XERROR allows for conveniently generating most of the Excel errors as output to functions With XERROR, it is very easy to generate all but four of the Excel errors as output to functions. Error types 0, 1, 2, 3, 4, 5, 6, 7, 8, 13, and 14 (i.e. #EXTERNAL!, #NULL!, #DIV/0!, #VALUE!, #REF...
  2. A

    connect exiting workbook to a SharePoint Lists

    Hi All, I've been googling a way to connect an existing workbook to a sharePoint list I have a maro enbled workbook and I'd li to connect to 5 different SharePoint lists on different sheets in the workbook.S
  3. K

    Connecting to Oracle DB without oracle client

    Hi All, Kindly provide an example to connect oracle database without oracle client installed in system. TIA
  4. R

    Macro to change VLookup Range

    Hi Guys, I want to update Vlookup range in the report with respect to sheet name in cell A27. <tbody> <tbody> Business Solution </tbody> Connect Status <tbody> Business Retail </tbody> =VLOOKUP($B$11,Oct!C:J,4,0) <tbody> Business Digital </tbody> =VLOOKUP($B$11,Oct!C:J,6,0)...
  5. K

    Connecting Oracle DB using Oracle.DataAccess.dll

    Hi All, Good Day! I want to know how to connect to Oracle DB without oracle installed on the system. When check in google it was told to use Oracle.DataAccess.dll. But could not do that can any one suggest how to use this dll and connect to oracle db. Using VBA macro. TIA
  6. A

    Trying to connect to a Fluke 789 V2.02 Processmeter

    Hello, This is similar to a previous post of mine, but a different question. I have gotten a hold of 2 Fluke 789 multimeters. 1 was version 1.01 and the 2nd was Version 2.02 With the code below, I can connect to the version 1.01 all day long. But it will not connect to the version 2.02...
  7. B

    Keeping ADO connection open at all times

    Hi, I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database...
  8. L

    Connect a slicer to ALL pivot tables in a workbook

    Hi, I have a workbook with tons of pivot tables. How can I use one slicer to connect to all the pivot tables without having to tick each pivot table check-box individually? I find it hard to believe that there is not a 'select all'/'deselect all' option. Thanks in advance
  9. T

    Connect to SAP from excel and download one one parameter (weight)

    Hi, I am tryig to dwnload at least one thng from SAP. The code I am using to connect you can see below. The target is to download something to excel workbook from MM03, for instance weight or base uint of measure for the materil number 1234567. I need support. Dim Logon As Object 'Logon...
  10. R

    Connect two tables

    Hi I am curerntly trying to connect two tables, if to the first table one column will be added the second table will automatically grow to the same size and automatically transfer the formulas from the previous columns in table two to the newly created column. Would be happy if you have a...
  11. K

    Use a cell value to query an external Access DB

    I use this forum all the time and it is awesome but couldn't find an answer this time. I got the below vba macro to work but want to use a cell value as the search value instead of typing it directly in the macro. I tried several different things but always returned an error I changed the...
  12. S

    Slicer connection to different source

    Hi All Im trying to connect a slicer to 2 pivot tables with different sources Both data tables have been sorted and have duplicates ie Table 1 Name Week FTe A 1 7.2 A 2 7.3 B 1 7.3 B 2 7.3 Table 2 Name Month Fte A Jan 2.6 A Feb 3.2 A Mar 4.4 B Jan 2.2 B Feb 6.4 B Mar 2.2 etc I have...
  13. D

    Power Query to iqy

    Does anyone know how to connect to an iqy through Power Query? Currently I'm using Power Query to connect to separate Excel file that contains the iqy. I would really like to skip the "middleman" and use Power Query to direct connect to my iqy. Thanks in advance.
  14. B

    Connect SQL Database to Forn Activation

    Hi, I'm new Userform and when the form activate a dropdown list must be populate. I can't get my project to connect to the SQL database. With all my searches I found these code but I have no idea where to place these code. I have tried to place them in Userform activate but I get an error...
  15. M

    Essbase / Smartview VBA - Connect Code?

    Hello, I'm hoping someone has some experience with VBA code with regards to Essbase/Smartview. I'm looking to connect to my cube without entering my login information manually (i.e. have username and password in the code and it'll login by that). I've tried reading the Developer's Guide below...
  16. O

    quering access report from excel vba

    Hi guys, can someone help i am trying to do vba/access link for the first time, and its quite hard! I am trying to access a report in access (which has a password) called R_UCITS-AIFM_Summary via an excel VBA, my first issue is normally input two dates, start and end date (normally the same)...
  17. C

    VBA to find file in alternative drive

    I have a database and associated excel files which connect to each other through the office network when I am there, but I need to have available on the C drive of my laptop when I'm away and can't connect to the network. Could someone help me with VBA for macros that I have to open certain...
  18. V

    Connect Excel to Access , both saved in sharepoint, through VBA

    Hello Its becoming a pain since few days. I am trying to connect to Access database saved in sharepoint through vba Excel is also saved in sharepoint Code i am using is Conn.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & dbname & ";" sconnect = "Provider=MSDASQL.1;DSN=Excel...
  19. FalconBLUE

    Looking Up a Value Multiple Tables in Access Data base

    Hi everyone, I have a problem with Excel VBA code related to Access tables. My Access database includes many tables, fields etc. and I want to find a value that is Excel B2 cell, through Access tables. I can connect to a certain name table but I could not make For Each structure. Can you please...
  20. D

    Power Query - Get and Transform connection to Magento Databases Directly

    Hello Guys Has anybody found a way to connect directly to Magento databases to extract data on a read-only connection basis? I have seen some $600 rip off pieces of software but I am sure there must be a direct connection excel can connect. I have searched on here and Google with no luck.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back