Versions Compared

Old Version 4

changes.mady.by.user Smita Nair

Saved on

compared with

New Version Current

changes.mady.by.user Nisha Shantilal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...


Note
titleParameters removed

Description

This article illustrates how to create a profile in the Excel macro with a URL.

Info

Before you begin:

  • Know what is a complete URL.
    • A typical path for looks like:
      /something/another_thing/projects/files/file.ext

    • If the host address begins with:
      http://www.site.com/

    • The complete URL, in this example, looks like: 
      http://www.site.com/something/another_thing/projects/files/file.ext

  • The process for adding a profile and using it in macros remains the same for other public repositories and external sources.

...

Methods to create a profile

There are two ways to work with profiles and URLs where you can use:

Using an absolute URL in a profile

...

  1. Navigate to Settings > ATLASSIAN MARKETPLACE > Excel Configuration > Profiles.

  2. Click Add Profile.

  3. Enter the following values for the appropriate parameters:

    Profile namePopulation data repository
    Profile typeURL
    URLhttps://download.microsoft.com/download/5/b/d/5bd4a709-de6e-4586-883f-9701ab94e3e5/population.xlsx

  4. Click Save profile to create the profile.

...

  1. Navigate to Settings > ATLASSIAN MARKETPLACE > Excel Configuration > Profiles.

  2. Click Add Profile.

  3. Enter the following values for the appropriate parameters:

    Profile nameExcel files repository
    Profile typeURL
    URLhttp://www.principlesofeconometrics.com


  4. Click Save profile to create the profile.

...