Macro or VBA funtions

I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet.

The VBA code in Access looks like this:

Private Sub cmdCreateCaseFolder_Click()

If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" & Me.Company.Column(1) & "-Case " & Me.ID, vbDirectory) = "" Then

MkDir ("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" & Me.Company.Column(1) & "-Case " & Me.ID)

End If

End Sub

I'd also like to be able to create a hyperlink to the folder using a macro similar to the shortcut key Control-K in MS Excel or Access.

Is there a way to accomplish this in SS?

Thank you,

Jim

Find more posts tagged with

Construction

Sheets

Support

Solution Center

Community Platform

IT & Operations

Project Management

Cell linking

Enhancement Request

Comments

Shaine Greenwood

Hi Jim,

You'd likely need to build this using the Smartsheet API, as Smartsheet doesn't have macro/VBA functionality at this time.

Our full API documentation is available here: https://smartsheet-platform.github.io/api-docs/

Richard Rymill SBP

Jim

Our development team at SBP are working with VBA & Access and finding better ways to work using the API with some excellent results so far.

If you would like to discuss your needs with the head of our Developer team, I can introduce you and it may help us both refine what is desired by the many and what may just be a one off, and so have limited potential?

Having launched our Smarter Dropdown List Manager solution in September which is selling well, we are deciding on the functionality for our next release we are calling Mini Control Center. You or others may wish to contribute?

Regards

RichardR

Ccruse

Richard

I came across your thread on the use of Excel type macros is SS. I've spent the last few days trying to build one in Excel thinking it could be used in SS (where I need it). Is this type of function available?

Embarrassingly, mine is simple but the solution is not forth coming.

Thanks

Richard Rymill SBP

Hi CCruse

I have good news for you. Mainly because the tool of choice for many of our clients .... after Smartsheet ofcourse ! is Excel and so over the last few months our development team have been using all the available tools to create Automation between Excel and Smartsheet. What you describe is just one of them. We are even using APIs to uplift data from SQL and MySQL, Excel or CSV into Smartsheet for action.

I am just taking a week or so off to recover from a Hip replacement operation but we now have a team of 14 who can resolve this for you.

Can I suggest you email my colleague Sean.Power@smarterbusinessprocesses.com who will arrange a screenshare Call to discuss the solution your need?

Sign in to join the conversation!

Quick Links

Trending discussions

Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…