Easiest Macro Question Ever...

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.

Reply to
CFisher
Loading thread data ...

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

Reply to
Richard Charney

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

Reply to
Richard Charney

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?

Reply to
CFisher

You should be able to open the access DB using the Shell command in a macro.

Kent

Reply to
KCS Development

Thanks - I'll have to do a little research to see how to use the "Shell" command. Thanks for the info.

Reply to
CFisher

PolyTech Forum website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.