enable import of xlsm by data shuttle

AK_AK

Hi community,

the idea is to enable import of macro-enabled xls workbooks (xlsm) by data shuttle,

this can prove really useful by importing /handling advanced project-related documents or business models !

Currently only csv and xlsx are allowed to be imported.

Cheers,

Andrey

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Matt Molland

I am working through a solution for this right now. I had to create a new workbook, then use the .xlsm sheet with your macros to open the .xlsx file, copy contents, then close the file. Then I use Data Shuttle to link to the other sheet.

Dim FilePath As String

Dim wbk As Workbook

Dim oldStatusBar As String

FilePath = "C:\Box\Shared Documents\SmartSheets Reference Sheets\Metrics Smartsheet.xlsx"

Set wbk = ActiveWorkbook

Application.ScreenUpdating = False

Workbooks.Open FilePath

Range("A1").Select

wbk.Sheets(1).Range("1:63").Copy Destination:=ActiveCell

ActiveWorkbook.Save

ActiveWorkbook.Close

Application.ScreenUpdating = True

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.