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

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…