Excel Modeless Dialog Box

Excel Modeless Dialog Box

Civil3DReminders_com
Mentor Mentor
760 Views
1 Reply
Message 1 of 2

Excel Modeless Dialog Box

Civil3DReminders_com
Mentor
Mentor

I want to create a modeless dialog box that is associated with Excel instead of AutoCAD. The program will run in AutoCAD and then it will open an instance of Excel. I want the ability for the user to then select a button on the modeless dialog that will import in data from the Excel Worksheet into AutoCAD. My preference is for the modeless dialog to be shown in Excel and not necessarily be tied to AutoCAD. Is this possible? My search so far hasn't been successful. 

 

Thank you,

Civil Reminders
http://blog.civil3dreminders.com/
http://www.CivilReminders.com/
Alumni
0 Likes
Accepted solutions (1)
761 Views
1 Reply
Reply (1)
Message 2 of 2

Civil3DReminders_com
Mentor
Mentor
Accepted solution

This appears to be the solution:

ExcelApplication = New Excel.Application
' Add the import export dialog box to load from Excel.
Dim excelLinkFrom As frmExcelLink = New frmExcelLink()
Dim xlMain As New NativeWindow()
xlMain.AssignHandle(New IntPtr(ExcelApplication.Hwnd))
excelLinkFrom.Show(xlMain)

 

Civil Reminders
http://blog.civil3dreminders.com/
http://www.CivilReminders.com/
Alumni
0 Likes