Excel VBA Macro to Send a Worksheet File via Teams

Yes—but Excel VBA has no built-in command that sends a worksheet directly to Microsoft Teams. A practical Windows method is to export the sheet as a PDF into the synced SharePoint folder for a Teams channel, let OneDrive upload it, and then share it in Teams; automatically posting a message requires a separately configured Microsoft Graph or Power Automate workflow.

What “send a worksheet via Teams” can mean

People use “send” to mean a few different things: attach a workbook to a chat, add a file to a channel, post a message containing a file link, or send a static snapshot that recipients can read without editing. These are different actions. Excel VBA can create or export a file, but Teams does not expose a simple native VBA method such as SendToTeams.

That distinction matters because a file can be placed in a channel’s document library without a message being posted to the channel. Conversely, a message can contain a link to a file that is stored elsewhere. Decide whether recipients need an editable workbook, a read-only snapshot, or simply a notification before choosing an approach.

PDF snapshot: useful for a report that should look the same for everyone and is not intended for editing.
Excel workbook: useful when recipients need formulas, data, or the ability to collaborate on the spreadsheet.
Message or notification: useful when people need to know that a new file is available, but it is a separate step from saving the file.

A straightforward approach: export to the channel’s synced folder

Files shown in a Teams channel are stored in SharePoint. If the relevant document library or channel folder has been synced to the computer with OneDrive, it appears as a normal local folder. VBA can save a PDF there using Excel’s standard export feature. OneDrive then syncs the file to SharePoint, where it becomes available through the channel’s Files area.

This approach avoids automating the Teams window and does not require a custom app registration. It is a good fit for a user-run macro that prepares a report for a known channel. It is not an instant-delivery guarantee: the file must finish syncing, and the macro does not itself notify channel members or create a Teams post.

In Teams, open the target channel and its Files area, then use the option to open or sync the associated SharePoint library with OneDrive, if your organization allows it. The exact labels can vary with the Teams interface and your organization’s settings. Use the local folder OneDrive actually created rather than assuming a particular folder name.

Example VBA macro: save the active worksheet as a PDF

This example exports the active worksheet to a timestamped PDF in a folder you configure. It assumes Excel for Microsoft 365 on Windows and that the destination folder already exists and is the synced folder for the intended Teams channel. Replace the sample path with the real local path on your computer. The macro creates a PDF; it does not post a Teams message.

Sub ExportActiveSheetToTeamsFolder()
    ' Save a copy of the workbook before running this macro.
    Dim ws As Worksheet
    Dim outputFolder As String
    Dim filePath As String
    Dim fileName As String

    ' Replace this example with the synced channel folder on this PC.
    outputFolder = "C:\Users\YourName\Contoso\Sales Team - Documents\General\"

    If TypeName(ActiveSheet) <> "Worksheet" Then
        MsgBox "Select a worksheet before running the macro."
        Exit Sub
    End If
    Set ws = ActiveSheet

    If Dir(outputFolder, vbDirectory) = vbNullString Then
        MsgBox "The destination folder was not found:" & vbCrLf & outputFolder
        Exit Sub
    End If

    fileName = ws.Name & "_" & Format$(Now, "yyyymmdd_hhnnss") & ".pdf"
    filePath = outputFolder & fileName

    On Error GoTo ExportError
    ws.ExportAsFixedFormat Type:=xlTypePDF, _
        Filename:=filePath, _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=False

    MsgBox "PDF created. Check OneDrive sync before sharing:" & vbCrLf & filePath
    Exit Sub

ExportError:
    MsgBox "The PDF could not be created: " & Err.Description
End Sub

The timestamp helps prevent a later run from silently replacing a prior PDF. The macro respects the worksheet’s print area and page setup, so check Print Preview first if the sheet has many columns or an unusual layout. Excel macros cannot be undone with Ctrl+Z; save a copy of the workbook before running one.

How to install and run the macro

In Excel, open the workbook and select the worksheet you want to share. Check its print layout and confirm that it contains only information appropriate for the channel.
On Windows, press Alt+F11 to open the Visual Basic Editor. Choose Insert > Module, paste the code, and change outputFolder to the full path of the synced Teams folder.
Save the workbook as an Excel Macro-Enabled Workbook (.xlsm). If Excel displays a security warning, run macros only when you trust the workbook and its code.
Return to Excel and run ExportActiveSheetToTeamsFolder from Developer > Macros, or press Alt+F8, select the macro, and choose Run.
Check the destination folder and OneDrive’s sync status. Once the upload completes, locate the file in the channel’s Files area. Create or send a Teams message with the file or its link if recipients need a notification.

On a Mac, the Visual Basic Editor is commonly opened with Option+F11; some keyboards require Fn+Option+F11. Mac Excel can run VBA, but the Windows folder path in this example will not work there. Use the actual local OneDrive-synced folder path for the Mac, and verify that the library is syncing. Teams and SharePoint access policies are controlled by the organization, not by the macro.

What happens after the macro saves the file

Saving the PDF to the correct local folder is only the first part. OneDrive watches synced folders and transfers local changes to SharePoint when it can connect and the account has permission. A file may take time to appear in Teams, especially if the client is paused, offline, signing in, or processing many files. Do not tell colleagues that the upload is complete until the sync status indicates it has finished and the file is visible online.

Standard channel files are held in the team’s SharePoint site. Private and shared channels can have separate SharePoint sites, so their synced folders may be different from the team’s General folder. Confirm the destination by opening the exact channel’s Files area and its associated SharePoint location. A similarly named folder elsewhere in OneDrive may be personal storage and not visible to the channel.

Adding a file to a channel folder also does not necessarily grant access to everyone you expect. Membership, channel type, sharing settings, retention policies, and sensitivity labels can affect who can open it. If a recipient receives an access-denied message, check the file’s location and permissions rather than assuming the export failed.

Other ways to automate or share the worksheet

If the file must be posted with a message automatically, there are more involved options, but they are not equivalent to a basic VBA macro. Microsoft Graph can be used by a properly configured application to work with Teams messages and files. A robust implementation generally has to authenticate securely, obtain the right permissions, upload the file to the appropriate SharePoint or OneDrive location, and then post a link or message. Organization policies and API permission requirements apply. VBA alone is not a safe place to store an app secret or a user’s password.

Power Automate may suit a managed workflow: for example, a flow can react to a file appearing in a SharePoint folder and post a channel notification containing a link. The flow needs to be designed with the organization’s connectors, permissions, and governance rules in mind. A Teams webhook-style workflow can be useful for posting a message or card, but sending a local Excel file as a Teams attachment is not the same operation; the file still needs to be stored somewhere accessible and linked appropriately.

For occasional use, a manual upload is often simpler: in the Teams channel, choose its Files area and upload the workbook or PDF, then post a message in the channel. For an email-style one-to-one handoff, use Teams chat’s file sharing controls or share a SharePoint link. These options make the destination and audience visible to the person doing the sharing, while a macro that writes into a synced folder is better for repeatable file preparation.

Common problems and how to prevent them

The macro says the folder is missing: the example path is only a placeholder. Copy the actual local synced-folder path from File Explorer, include the final backslash, and confirm the folder exists while OneDrive is signed in.
The file is local but not in Teams: wait for OneDrive to finish syncing, check for sync errors, and confirm that the folder belongs to the intended channel’s SharePoint library.
The PDF pages are cut off or tiny: adjust the worksheet’s print area, orientation, scaling, and page breaks in Excel before exporting. A wide data sheet may be more useful as an editable workbook than as a single-page PDF.
Recipients cannot open the file: check channel membership and SharePoint permissions. A link copied from a personal OneDrive location is not automatically accessible to channel members.
The macro is blocked: use an approved, trusted macro source and follow your organization’s Office security policy. Do not lower macro security settings broadly just to run one file.

A useful safeguard is to test with a non-sensitive worksheet and a test channel first. Confirm the exported content, filename, location, sync behavior, and recipient access before relying on the process for a recurring report.

Frequently Asked Questions

Can VBA send a worksheet directly into a Teams chat?
Not through a built-in Teams method in Excel VBA. VBA can export or save a file, while chat upload or automated message posting requires a supported Teams workflow, Graph integration, or a separate sharing step.

Will saving a PDF to a Teams folder notify the channel?
Usually, saving the file into the synced SharePoint folder makes it available in the channel’s Files area after OneDrive syncs it, but it does not by itself create a channel post. Send a message with the file or link if people need an explicit notification.

Can I send the worksheet as an editable Excel file instead?
Yes, but an isolated copy of a sheet can behave differently from its original workbook. Formulas that refer to other worksheets, named ranges, queries, connections, macros, and linked data may not transfer cleanly. For collaboration, consider sharing the original workbook from its proper SharePoint or OneDrive location, subject to permissions.

Does the macro work in Excel for the web?
No. Excel for the web does not run VBA macros. Open the macro-enabled workbook in the desktop Excel app to run this code. Excel for Mac supports VBA, but you must change the Windows folder path to a valid synced path on the Mac.

Can the macro post the Teams message after exporting?
Not as written. It only creates a PDF in a local synced folder. Automatic posting requires an additional, authenticated integration such as an approved Power Automate flow or Microsoft Graph application, plus a way to provide the uploaded file’s accessible link.

Try it: the Column Letter to Number: aA is 27, XFD is 16,384. Converts both ways.

More in VBA & macros

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.