I am trying to run a VBA macro in Excel 2016 for Mac (v. 15.25) The macro works on Windows platforms with Excel 2016, and on Mac platforms with earlier than the 2016 version.
The issue appears specific to Excel 2016 for Mac when trying to export a CSV. The code is supposed to allow the user to click a button, which will then export an active worksheet to a CSV file. While a similar issue was documented here and here , neither of the solutions worked for me (one solution was changing the FileFormat parameter to 6 from xlCSV and the other was to replace / in a file path with:). The code works up until the ActiveWorkbook.SaveAs Filename:=newFileName, FileFormat:=6, CreateBackup:=False line, which then throws the error: Run-time error '1004':Method 'SaveAs' of object 'Workbook' failed If I change FileFormat to 51 (.xlsx) or 53 (.xlsm) the code will successfully finish. However, if FileFormat is set to 6 (.csv) the code will throw the error above. I am unable to SaveAs xlCSV or xlCSVMac.
The full script is: Sub btnExportCSVClick Dim oldFileName As String Dim newFileName As String Dim timeStamp As String Dim fileAccessGranted As Boolean Dim filePermissionCandidates Dim wsPath As String timeStamp = Format ( Now, 'yyyymmddhhmmss' ) wsPath = Application. Path oldFileName = ThisWorkbook. FullName newFileName = Mid ( oldFileName, 1, InStrRev ( oldFileName, '.' ) - 1 ) & timeStamp & '.csv' ' Check if software is Office 2016 for Mac ' Documentation for this comes from # If MACOFFICEVERSION = 15 Then filePermissionCandidates = Array ( wsPath ) fileAccessGranted = GrantAccessToMultipleFiles ( filePermissionCandidates ) # End If Application. DisplayAlerts = False Sheets ( 'OfflineComments' ).
Activate Sheets ( 'OfflineComments' ). Copy ActiveWorkbook. SaveAs Filename:= newFileName, FileFormat:= 6, CreateBackup:= False ActiveWorkbook. Save ActiveWindow. Close MsgBox ( 'Offline comments exported to ' & newFileName ) Application.
DisplayAlerts = True End Sub I have tried:. Adding a full path to the input/output file names. Ensuring that version of Excel is checked for and permissions allowed by user. Various file types for the FileFormat parameter, but as mentioned, only two types actually worked. Trying the code mentioned in the above-linked article, which did not help (and which is why I am posting the original code here). Changing the problematic line to Sheets('OfflineComments').SaveAs Filename:=newFileName, FileFormat:=6, CreateBackup:=False which throws the error Run-time error '1004': SaveAs method of Worksheet class failed. For some reason, it worked randomly about 10 times (only in one directory, if the workbook was moved to another directory and I tried to run the code, it would throw the 1004 error) and then when I commented out a line of code, tried something else, and then reverted back to the working code, it stopped working.
This issue is also documented here: and here. Ron, thanks for your help.
It does work to save it in the Office folder, but that folder only. Creating other directories anywhere else on the computer and trying to save will not work. Other users of our workbook using Office 2016 for Mac have had the same complaints (which is how we became aware of the issue) so unfortunately it's not just my machine. I am not sure why it works on some but not others. As I mentioned before, it started randomly working briefly (10-15 times) on my machine, but then inexplicably stopped. While it's great that saving to the Office folder is a potential solution, it's not really a solution that we can ask all of our users to do if they want to use our macro-enabled spreadsheet.
At this point, the best solution I can think of is to use VBA to check if the user is running Office 2016 for Mac (up to at least version 15.26) as the code currently does, and if so, run the script and prompt them to save as a CSV manually. An interesting twist to the story. I included in the If statement a prompt for the user to save manually as a CSV.
In doing so I had to use the GetSaveAsFilename prompt. When the user enters the file name and clicks the 'Save' button, this will not actually save anything unless you call SaveAs (code below) (h/t ) Sub btnExportCSVClick Dim oldFileName As String Dim newFileName As String Dim timeStamp As String Dim fileAccessGranted As Boolean Dim filePermissionCandidates Dim wsPath As String Dim cell As Range Dim s As String Dim wFileName As String Dim nWB As Workbook timeStamp = Format(Now, 'yyyymmddhhmmss') wsPath = Application.ThisWorkbook.Path oldFileName = ThisWorkbook.FullName newFileName = Mid(oldFileName, 1, InStrRev(oldFileName, '.'
I've been there I found a new macro that promised to automate a particularly annoying task, save me a ton of time and make me significantly more efficient in Excel. I tried to run the macro. And then Something like this happened: Sigh The first time I saw such a message in Excel, several questions popped immediately in my head:. What security settings is this message referring to?.
What does it mean that macros have been disabled?. Did I disable macros in Excel by mistake?. How do I enable macros in Excel?
Needless to say, I eventually learned how to enable macros in Excel. Otherwise, I wouldn't be writing this Excel tutorial now.
However, since I know that I'm not the first (or last) one to raise those questions, I decided to write this post. My purpose with this tutorial is to answer the questions above and explain to you the most important things you need to know regarding how (and when) to enable macros in Excel. This way, when Excel displays a dialog saying that macros have been disabled and you need to enable macros, you'll know exactly what to do. More precisely, in this Excel tutorial we'll cover the following topics. Table of Contents. I assume that, if you're reading this Excel tutorial, the version of Excel you're working on still has its default settings.
Therefore, let's start by understanding Excel's Default Macro Security Setting: Disable Macros With Notification Excel's default setting is to disable all macros with a notification. This is the reason why, if you that contains macros, you may see a message warning you that “macros have been disabled”. You can generally modify the macro security settings of Excel to determine what happens when you open an Excel workbook by determining:. Which macros can run. Under which circumstances can macros run. In any case, please note the following:. As explained by, you're not able to change the macro security settings if an administrator in your organization has changed the default settings with the purpose of preventing modifications.
If this is the case, get in touch with this administrator. Any changes that you make macro security settings in Excel are only applicable to Excel. The first question you may have is Why Are Excel Macros Not Enabled By Default? This may sound like ancient history to most of you, but: Once upon a time, Excel (along with the other Microsoft Office applications) enabled macros by default. But then: Kwyjibo came. In case you're a Simpsons fan and are wondering whether I'm referring to Homer Simpson. The answer is no.
I'm also a little bit disappointed. I also like the Simpsons and would've enjoyed writing about them. I'm referring to, also known by other names such as Kwyjibo. This was a that propagated via a. The virus became famous back in 1999.
Certain large corporations were affected. What do you think was the consequence of this? That's right. As explained in Excel 2013 VBA and Macros by Excel experts Bill Jelen and Tracy Syrstad, Microsoft changed the default security settings of the Microsoft Office applications. Under the current setting macros are, by default, not enabled. Nowadays, macro security is very important. The reason for this, as explained by Excel authority John Walkenbach in Excel VBA Programming for Dummies is that VBA is a very powerful language.
Walkenbach goes on to explain that: A macro can delete files, send information to other computers, and even destroy Windows so that you can't even start your system. Therefore, you want to understand what you're doing when enabling macros. This way you'll be able to enjoy the benefits of macros while minimizing the risk of having your computer infected with dangerous. Let's assume, that you want to enable macros in Excel because you want to.
The following sections explain the different ways in which you can enable macros in Excel and the most important aspects of macro security settings you'll need to understand in order to be reasonably protected from macro viruses. How To Change Your Global Macro Security Settings In Order To, Among Others, Enable Macros In Excel By Default Excel allows you to determine whether macros are enabled or disabled automatically. You determine these default settings through the, which is where you can see and set all the security and privacy settings for Excel. If you enable macros in Excel through the Trust Center, those settings become the new default and apply globally. If you want to enable macros for only certain Excel workbooks, you can do so by saving them in a trusted location, as I explain in the next section of this Excel tutorial.
Let's see how to change your global macro security settings in 2 easy steps. This allows you to, for example, enable macros in Excel by default.
Step #1: Access Excel's Trust Center The easiest way to access Excel's Trust Center is by simply clicking on “Macro Security” in the Developer. Alternatively, you can get to the Trust Center through the Excel Options dialog. Do this in the following 4 simple steps.
Step #1: Access the Excel Options dialog. You can get Excel to display the Excel Options dialog by:. Clicking on the File tab of the Ribbon. Click on “Options” on the left side of the Backstage View. You can also access the Excel Options dialog:. Alt + T + O. Alt + F + T.
Step #2: Go to the Trust Center tab. When Excel displays the Excel Options dialog, click on “Trust Center” on the left bar of the Options Dialog. Step #3: Click on “Trust Center Settings”.
Once you're in the Trust Center tab, simply click on the “Trust Center Settings” button on the right side of the Excel Options dialog. This takes you to the Trust Center. Step #4: Go to the Macro Settings tab. Once you're inside the Trust Center, make sure you're on the Macro Settings tab. This tab appears on the left side. If you're not already there, click on “Macro Settings”.
Step #2: Select The Macro Setting You Want To Enable At the top of the Macro Settings tab in the Trust Center, you'll find the “Macro Settings”. Excel allows you to choose 1 out of 4 separate settings to set whether Excel enables or disables macros.
To choose the macro setting you want to enable, simply click on the circle on the left side of it and, then, click on the OK button on the lower right corner of the Trust Center. Let's take a look at what each of these options means and does. Option #1: Disable All Macros Without Notification This option is self-explanatory. It:.
Disables all macros, excluding those in trusted locations. Doesn't notify you that a macro has been disabled. As you may've guessed, this is not the option you want to choose. As explained by Mr.
Excel (Bill Jelen) and Tracy Syrstad in Excel 2013 VBA and Macros: This setting is for people who never intend to run macros. Note that this macro doesn't prevent absolutely all macros from running. As I mention above, macros in trusted locations can still run without going through the checks of the Trust Center system. Option #2: Disable All Macros With Notification As you've probably noticed the difference between this option and option #1 is that, now, Excel notifies you that a macro has been disabled. This is the default option in Excel and, as explained in Excel 2013 VBA and Macros, it's also the recommended setting. Excel's notification that macros are not enabled allows you to determine, on a case-by-case basis, whether you want to enable macros for a particular Excel workbook.
More precisely, if you open a file that has macros (and isn't open), you'll see the following message below the Ribbon. If at the time of opening the workbook with macros the Visual Basic Editor is also open, Excel displays a security notice: Regardless of which of the 2 messages you see, you have 2 options.
Option #1: Enable Macros. You have 2 possible ways to enable macros. Possibility #1: Simply click on “Enable Content” or “Enable Macros”. Which of the 2 options above applies depends on whether the Visual Basic Editor is open or not. If the VBE is open, you'll see the Microsoft Excel Security Notice that appears in the second screenshot above. Otherwise, you'll see the security warning that appears in the first image.
How Do I Issue An Http Get From Excel Vba For Mac Mac
Possibility #2: Enable the macros using the by following the 3-step process below. Gt s3350 drivers for mac. Step #1: Click on the File tab in the Ribbon. Step #2: Once you're in the Backstage View, make sure that you're in the Info tab. You can get there by clicking on “Info” on the left navigation pane.
Step #3: You've probably noticed the prominent security warning which mentions that macros have been disabled. To enable macros, click on the Enable Content button on the left side of the warning and, in the drop-down menu that expands, select “Enable All Content”. Option #2: Keep Macros Disabled.
If the VBE is not open, ignore the message or close it by clicking on the cross at the right side of the security warning (as shown in the image below). If the VBE is open, click on “Disable Macros” or close the security notice. In all of these cases, the macros are not enabled. What Happens If You Ignore Or Dismiss The Security Warning Without Enabling Macros And, Later, Try To Run A Macro? If you try to run a macro even though you've not enable them, Excel displays the following dialog box to inform you about this: In order to solve this issue, follow the indications that appear in the dialog. Namely:. Step #1:.
Step #2: Open the workbook again. Step #3: When the security warning informing you that macros are not enabled appears again, click on “Enable Content”. What Happens The Next Time You Open An Excel Workbook In Which You Have Enabled Macros. Excel remembers when you enable macros in an Excel workbook.
Therefore, if you enable the content of such workbook following the process described in this section, the next time you open it all the macros are automatically enabled. In other words, that particular Excel file becomes a. You can enable the macros in a particular Excel file for a single time, without turning that Excel workbook into a trusted document, by following the process I explain below. As explained by Microsoft, there are some situations in which you can't make a particular Excel workbook a trusted document. In those cases, macros are not automatically enabled the next time you open the relevant Excel file. Some of the reasons why a file can't be made a trusted document include:.
That particular file was opened from a location that is deemed unsafe, such as the Temp Folder. The system administrator of your organization has disabled certain content or has turned off the trusted document feature. The file is a template, usually identified by the extensions.dot,.dotx or.dotm. When a file can't be made a trusted document, the macros that you enable by following the steps described above are only enabled for a single time. When you open the file again, Excel shows the security warning or security notice again and ask if you want to enable the content (as explained above). Option #3: Disable All Macros Except Digitally Signed Macros This option, just as the previous 2, generally disables macros automatically.
However, in this case, the process is slightly more complicated due to the existence of an exception for digitally signed macros. If you choose this setting, Excel proceeds as follows when you open an Excel workbook with macros:. Macros that are digitally signed by a publisher that you've already trusted are automatically enabled. In the case of macros that are digitally signed by a publisher that you've not yet trusted, Excel notifies you. This allows you to enable the signed macros or add the publisher to your list of trusted publishers. Unsigned macros are not enabled and there is no notification.
The question is, then, when should you choose this option? In Excel 2013 VBA and Macros, Excel authorities Mr. Excel (Bill Jelen) and Tracy Syrstad provide a good general rule to determine whether you should choose or not to disable all macros except those that are digitally signed:. This macro setting may be useful if you're planning to create and somehow distribute to third parties, or if you use add-ins from third parties.
Despite the above, this option is likely unnecessary (and even annoying) if the macros that you'll be creating are for your own use and you only use the macros you create. Option #4: Enable All Macros This setting enables all macros automatically.
However, notice the clear warning that Microsoft includes within the parenthesis: If you remember the explanation I provide above as to why Excel macros are not enabled by default, you'll see the problem with enabling absolutely all macros automatically. This macro setting leaves your computer vulnerable to macro viruses. In other words, unless you have a very compelling reason to do otherwise, its best to avoid option #4. How to Enable Macros For Certain Excel Files In addition to setting global settings to determine whether macros are enabled or not, you can determine the individual macro settings for particular Excel workbooks. You do this through creating and managing, which are particular folders in your hard disk or network. As explained by Microsoft, Microsoft Office creates several trusted locations during the installation process.
Excel expert Ankit Kaul, at, lists the 4 locations:. Program Files Microsoft Office Templates. Program Files Microsoft Office Office12 Startup.
Program Files Microsoft Office Office12 Library. Program Files Microsoft Office Office12 XLSTART.
Excel files that are in a trusted location are not checked according to the security settings of the Trust Center. Therefore, the macros of all the Excel workbooks that are saved in trusted locations are automatically enabled. In Excel VBA Programming for Dummies, Excel guru John Walkenbach writes that designating one or more folders as trusted locations is: Perhaps the best way to handle macro security. You can add a trusted location by following these 8 easy steps. Step #1: Access The Trusted Locations Tab In The Trust Center You can access the Trusted Locations tab in 2 simple steps. Step #1: Enter The Trust Center. The most straightforward way to get to the Trust Center is by clicking on the Macro Security button in the Developer tab of the Ribbon.
You can also access the Trust Center through the Excel Options dialog, as I explain above. Step #2: Go To The Trusted Locations Tab. Once you're inside the Trust Center, make sure that you're on the Trusted Locations tab.
Otherwise, you can get there by clicking on “Trusted Locations” on the left navigation pane. Step #2: Set Whether You Want To Allow Trusted Locations On Network Trusted locations can be both on your hard drive and on a network location. Is that you don't have trusted locations on your network as locations outside your computer are less safe.
The default setting reflects this. Additionally, according to Microsoft, you should avoid adding public folders on network shares as trusted locations. You can, however, choose to trust locations on your network by selecting “Allow Trusted Locations on my network”. Step #3: Click The Add New Location Button This step is self-explanatory.
Click on the Add new location button on the lower part of the Trust Center. Step #4: Click The Browse Button After you've clicked the Add New Location button, Excel displays the Microsoft Office Trusted Location dialog. Here, you'll want to click on “Browse”. Step #5: Select The Folder You Want To Add As A Trusted Location After you've clicked on the Browse button, Excel opens the Browse dialog. This probably looks familiar. This is the dialog box you'll use to select the folder you want to add to your trusted locations. You do this by following 3 steps:.
Step #1: Browsing to the folder that is the parent of that which you want to add as a trusted location. Step #2: Selecting the relevant folder to be added as a trusted location. Step #3: Clicking the OK button. The following screenshot shows how the Browse dialog looks if, for example, you wanted to add the Trusted Locations folder which is stored in the Examples folder: Step #6: Set Whether You Want To Trust Subfolders Of The Selected Location After you've selected the folder to be added as a trusted location, Excel takes you back to the Microsoft Office Trusted Location dialog. Excel allows you to trust the subfolders of the location that you've selected in step #5 above by selecting “Subfolders of this location are also trusted”. If you want, you can also add a description of the trusted location, using the Description field on the lower part of the dialog. Adding a description is optional.
Step #7: Click The OK Button Once you've completed the 6 steps explained above, you're ready to go back to the Trust Center. To close the Microsoft Office Trusted Location dialog and go back to the Trust Center, click the OK button on the lower right corner. Step #8: Click The OK Button Once you're back in the Trust Center, you'll notice that the location that you've selected by following the 7 steps above has been added to the list of trusted sources for opening files. You've pretty much completed the process to add a trusted location.
Simply click the OK button on the lower right corner to finish. When To Use And When Not To Use Trusted Locations You're probably already aware of the following, but I'll say it anyway: You should be very careful when selecting which locations you add to the list of trusted sources for opening files in Excel. Remember that all Excel workbooks that are stored in trusted locations have their macros enabled automatically, regardless of what the global setting for macro security is. As explained at, trusted locations can “act as loopholes in your security setting and any hacker can easily take advantage of those loopholes”.
One example of something you don't want to do appears in Excel 2013 VBA and Macros. Here, the authors explain how Outlook stores email attachments that you double-click in a temporary folder. This temporary folder is within the local drive C:. If you were to add C: and all its subfolders as trusted sources for opening files, your computer would be quite vulnerable to a macro virus. In a similar vein, that you avoid designating your entire Documents or My Documents folders as trusted locations. In this case, is better to create subfolders and add those subfolders alone to the list of trusted locations.
So when does it make sense to add a trusted location? In the webpage I link to above, Microsoft provides a good rule of thumb. Basically, it may make sense to use trusted locations when you have certain Excel workbooks that you don't want the Trust Center security feature to check before opening. Doing this is safer than changing your default macro security settings in the Trust Center to something less safe. For example, let's assume that:. Your default macro security setting is Disable all macros without notification.
However, you have a few (very few) Excel workbooks with macros that you want to use. In this case, instead of changing your global macro security setting to Disable all macros with notification, it may make more sense for you to create a trusted location. You can then save your few Excel workbooks with macros on that trusted location and, when you open them, their macros are automatically enabled. How To Enable Macros For A Single Time What can you do if you receive an Excel workbook that contains macros which you want to use but you don't want to do any of the following?. Modify your global macro security settings.
Turn the Excel file into a trusted document where, in future opportunities, macros are automatically enabled. Use trusted locations. The answer is that you enable the macros for a single time in 3 easy steps, as explained below. Note that this process only works if Excel has notified you that macros have been disabled. If you have, for example, disabled all macros without notification, you'll need to change your default settings before being able to enable macros for a single time. A similar thing happens if you have disabled all macros except digitally signed ones, and open a book containing unsigned macros (in which case there is no notification). If you follow this process, for as long as you keep the Excel workbook open.
Since the Excel workbook doesn't become a trusted document in this scenario, if you close the file and later re-open it, the macros are not automatically enabled. Step #1: Access The Backstage View Go to the Backstage View by clicking on the File tab in the Ribbon. Step #2: Click On The Enable Content Button And Select Advanced Options Once you're in the Backstage View, you'll notice the prominent security warning which Excel uses to inform you that macros have been disabled. Click on the Enable Content button that is to the right of the security warning. Excel displays a drop-down menu. Select “Advanced Options”. Step #3: Select “Enable content for this session” And Click The OK Button After you've clicked on “Advanced Options”, Excel displays the Microsoft Office Security Options dialog.
Select “Enable content for this session” and click “OK”. That's it, macros are now enabled for that particular session. Conclusion The quote in the image at the beginning of this Excel tutorial (from Excel authority John Walkenbach) states that Visual Basic for Applications is a powerful language. Both good and bad consequences stem from this power:. On the one hand, macros are extremely useful for automating repetitive tasks and improving your efficiency and productivity when using Excel. On the other hand, they can create a lot of damage when used inappropriately.
Should the potential risk of using macros stop you from using them? Generally, no. As explained by technology writer Chris Hoffman at: Macros are still potentially dangerous. But, like a lion at the zoo, you'd have to go out of your way to be hurt by them.
This Excel tutorial has explained the most important things you need to know regarding how and when to enable macros. Therefore, by now, you probably have a good understanding of what activities and macro security settings are most appropriate for your particular situation. Additionally, you've also seen how you can enable macros in Excel in different situations, ranging from having them always enabled to enabling them for a single time. These different methods to enable a macro should be able to cover most of the situations that you find in your day to day work. Books Referenced In This Excel Tutorial Click on any of the images below to purchase the book at Amazon now. PowerSpreadsheets.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. I love reading and sharing success stories from amazing members of the Power Spreadsheets community, like you.
If this (or any other) Tutorial has helped you, please share your success story below. This only takes few seconds and, by doing it, you help the future development of Power Spreadsheets. Any improvements I make to this or the other free Tutorials in Power Spreadsheets based on your feedback will benefit you too. To share your success story, please do the following:. Fill the form below (required fields are marked with an asterisk (.)); and. Click the Share my success story button.
I made the switch to Mac and now some of my old Excel macros that are depended on the operating system do not work. One particular item is the ability to fetch data from the Web. So here I am after many years using Office and Excel learning again.
Ok, let’s get series nowToday’s goal is to build a user defined function that can be called from the Excel datasheet and fetch a web page. We will call that function getHTTP and it will work on Mac (but not on Windows). Luck is on my side as there are many others looking for the same solution. I found an entry called “How do I issue an HTTP GET from Excel VBA for Mac 2011” (See it ) and it has exactly what we need. Navigation in Excel on Mac is just a little bit different so here are steps by step instructions: 1.
Open an Excel file or create a new one. Save as “Excel Macro-Enabled Workbook (.xlsm)” file. From the menu navigate to Tools-Macro-Macros 4. In the “Macro Name:” field type the name of the new Macro we want to create. In this case getHTTP.
You should see a screen like this: 5. Click “Create” and you will find yourself in the VBA editor with an empty Sub called getHTTP. Ok, did a review again with the thought of “let’s follow the instructions one by one and see what can go wrong”. I really should have done that from the beginning I think I got it! When you follow step 5 and create the new macro, VB will create an empty function for you. Something like this: Sub getHTTP End Sub You have to delete these lines and make sure that the edit area is completely empty before you paste the content. Once you do that the Macro should work.
Please try and let me know if it works so i can update the post with better instructions One additional discovery. The specific example of how to use getHTTP uses weather API. While the example still return positive response and some content, it is not returning what you ask for. Let me explain this further: The original example uses version 2.1 of the API. Since that time openweathermap.org released version 2.5 of the API. The new API requires registration and specific API key (annoying). You can still use version 2.1 of the API but it will ignore the q=Boston and instead return a large response with multiple cities and not what you searched for.
Tip: Using a previous version of Excel? If so, take a look at for an overview based on previous versions of Excel with the.
The content and premises are similar but some screens and steps are slightly different, and we want you to clearly see how these features work in your version of Excel. To see these features in action in previous versions of Excel, take a look at. Your Resources The following links and information can get you started, and help you understand these new data import and transformation features in Excel. The sections and links are presented in the order you’d need if you were just starting out – the first link describes where to find the new functionality in Excel, the next section points you to a Getting Started Guide, and then you find links to tutorials, and community connections.
We update these links when additional resources are available, so check back often. How do I use Get & Transform?
How Do I Issue An Http Get From Excel Vba For Mac Free
To use Get & Transform in Excel, you create a query in your workbook. A query enables you to connect to, preview, and transform data from a wide variety of available data sources.
You can then load that transformed data into a table, or into the built-in Data Model in Excel, and even refresh that data later on. You can also edit the query whenever you need to, and share your query, too. To create a query in Excel, use the Data tab in the ribbon, then select the Get Data button from the Get & Transform Data ribbon group. From there, choose your data source. Related Get & Transform features are also available from the Get & Transform group. For more information, and to see these steps in action, take a look at. Getting Started with Get & Transform Want to see how a query can transform your data?
The page explains how to connect to and transform data in Excel, with understandable categories and steps that show you how to create a query, and also how to share it. Tip: The collection of data import and transformation features available in the Get & Transform ribbon group in Excel are available in many Microsoft products. These features are often referred to as Power Query. Many links in the following sections refer to Power Query, and the functionality described in those articles also applies to the collection of features in the Get & Transform group in the Data ribbon of Excel. Tutorials Seeing how a query is created can boost your learning around how to use Get & Transform features.
Here are a few tutorials that can get you started, as well as links that guide you through more challenging and interesting scenarios:. Additional information about Query If you want more in-depth information on Get & Transform, the following resources can help:. Community, Forums, and Feedback There are all sorts of people using these data gathering and transformation capabilities, and they like to share what they’ve learned.
Take a look at the following resources to get involved with others in the community.
I have Excel 2016 for Mac (Version 15.28) and I’m curious about something I see when using the VBA Editor. I have not used the VBA Editor before but I’m hoping to learn how to use it as I want to create my own Excel functions.
When I call up the VBA Editor using alt & F11, the list on the left-hand side of the box includes something labelled Solver (Solver.xlam). If I click on the arrow for this, I am asked for a VBA Project Password.
As I have never before used VBA Editor or Solver, I wonder why I am asked for a password for something I haven't yet used. None of my passwords work - well, as I have never before seen or used this I'm not surprised but my curiosity has been awakened!