Opening a program from excel Help.

**richardv24** · 12-21-2011, 06:14 PM

Hi guys, I am sort of new to excel and do not know many of the features. Here is what I am trying to do.

I am trying build a list of items in excel. Each listed item will have an appropriate AUTOCAD (.dwg) file associated with it. I want to make it so that I can eventually sort this list by several different specs. and I want to have it so that there will be something like a button next to each list that when I click it will make AUTOCAD open up and display the .dwg file IN AUTOCAD associated with it.

I am absolutely clueless on how to do this. I have searched many sites to have none of them do what I want. I would appreciate a dumbed-down version of how I can go about to achieve this.

Thanks to everyone in advance

**richardv24** · 12-21-2011, 06:36 PM

I think I figured it thanks anyway

**Paul** · 12-21-2011, 06:53 PM

Hi Richard, welcome to the forum.

Please post your solution so it may help others.

One option, in case it's different from your method, would be to put the full path/filename into a cell and then use the Worksheet_BeforeDoubleClick event. You can then double-click on that cell and it will open the program and file specified. (Full path/filename like: c:\users\Paul\desktop\diagram.dwg)

1. Add the following to the worksheet code module (right-click on sheet tab and choose View Code):

Please Login or Register  to view this content.

2. Add the following code to a standard module (in the VB Editor, click Insert > Module):

Please Login or Register  to view this content.

Change the program path/filename to your actual Autocad program executable path/filename.

Opening a program from excel Help.

LinkBack

Thread Tools

Rate This Thread

Display

Opening a program from excel Help.

Re: Opening a program from excel Help.

Re: Opening a program from excel Help.

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions