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
Comments
-
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/
-
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
-
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
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives