azure

  1. Jeffrey Mahoney

    Change Sensitivity Label Programatically

    This code will allow you to change a workbook's Sensitivity Label using VBA. It seems that each company gets to decide what those labels are. I also believe that each of those has a ID unique to that company. Each ID needs to be in this format: "12345678-1234-1234-1234-1234567890AB" with...
  2. E

    Replicate ODBC Connection on the Fly with ADO String in VBA

    Is it possible to replicate this connection setup on the fly with ADO Connection string in VBA and not have go through a preestablished DSN setup? Connect to Azure Databricks from Excel, Python, or R It's an Azure Databricks connection. DSN is working and I know how to connect using it, just...
  3. P

    Prevent Popup Window when Opening Azure RMS Protected Files

    Hi all, I'm currently working on a project to run through a list of files on a network drive and report the SQL connections and VBA Modules within each file. I am running into an issue where a file is protected using Azure RMS and I do not have access to the file - I am presented with a popup...
  4. R

    How to find a range of words in a list of row?

    <tbody> Hello All, Here is the sample strings in (A2:A11) result(B2:B11) Lorem ipsum dolor sit amet, amber amber consectetur beige adipiscing elit. amber|beige Nunc azure dictum black odio light blue quis nunc imperdiet viverra. black|light blue|blue Sed at beige beige beige amber...
  5. N

    VBA ADO and Azure Sql server

    Hello, first I want to say that, I'm very new with Azure and Sql server. second, I have an VBA ADO code with a simple select query from an Azure SQL SERVER db. On my main PC (the PC with my SSMS that i use to contacat the sql server) the code works perfect, but on any other PC (I used the same...
  6. M

    Can't view SQL database tables in Data Connection Wizard

    Hello We have a SQL database in Azure setup but we can't connect to the tables in Excel 2007. We're selecting Data, From Other Sources, then From SQL Server and enter the server address / port alongside the relevant username and password. We can see the database "HS" in the database...
  7. E

    Link SQL Server Azure to On Premise SQL Server

    I am building a Access Web app in office 365 (something I have never done before). I think by default the tables created in the app are stored in sql server azure. Can I specify or define the names of the sql server azure and link to our on-site sql server? I am trying to sync the data tables...
  8. D

    PowerPivot and MS SQL Azure

    Has anyone tried to use PowerPivot with MS SQL on the Azure cloud? If not, would anyone like to test it with me?

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top