connect

  1. 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
  2. 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
  3. 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)...
  4. 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
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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...
  15. 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)...
  16. 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...
  17. 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...
  18. 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...
  19. 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.
  20. T

    How to connect to Snowflake server?

    Hi everyone, I'd like to know if someone tried to find out any solution, how to connect desktop MS Excel to Snowflake server (as well as we connect to this server via Tableau). Is there any possibility how do that? Thanks, Tomas.

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top