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...
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
I want to update Vlookup range in the report with respect to sheet name in cell A27.
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.
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...
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...
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
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...
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...
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...
Im trying to connect a slicer to 2 pivot tables with different sources
Both data tables have been sorted and have duplicates
Name Week FTe
A 1 7.2
A 2 7.3
B 1 7.3
B 2 7.3
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
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.
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...
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...
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)...
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...
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...
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...
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.