Rarely do I play with macros - maybe I should more often...but I'm trying to open an Access DB from within Solidworks. Don't need to copy anything over I just want a quick way to open the DB without leaving the SW screen. I've got a shortcut on my desktop and tried to record a macro to open the shortcut - that woulda made things really simple - no joy though, doesn't work that way.
Are SW macros only operational within SW or am I simply doing something wrong? Thanks in advance.
You could link the Access DB to a string of text or a single word. I've done this linking an Excel spreadsheet.
Type a single word of text in the drawing, click on the text. In the feature manager window, where it shows the properties, look at the "Test Format" box. There are three buttons in the middle. The first is "Insert Hyperlink". If you click it, it will let link the text or text string to a file.
Richard
I forgot to add, after you link the file to the text, all you need to do is double click on the text and the linked file (AccessDB) will open in it's own program.
Richard
Thanks Richard - I was hoping for something a little different - I'm shooting for someting a little more global I guess. I tried adding the hyperlinked text to a drawing template so it would be available everytime a drawing was opened...but links don't work through there that I can see.
Any other suggestions?
You should be able to open the access DB using the Shell command in a macro.
Kent
Thanks - I'll have to do a little research to see how to use the "Shell" command. Thanks for the info.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required