Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kuhni
 
Posts: n/a
Default Display form from an VB application in Excel

Dear All,

I have the following problem with a macro. I hope somebody may help me.

Problem:
I want to display a VBA form created in an VB application on top of an
Excel worksheet to enter some information. But when I show the form
after opening the Excel workbook, the macro automatically switches back
to the application showing this form (and not on top of the Excel
workbook).

Code:
....
'Open Excel workbook
Set xlS = clsApp.GetApplication("excel.Application")
Set xlsWB = xlS.Workbooks.Open(filename)
xlS.Visible = True
'Show form on top of that Excel workbook
frm.Show vbModeless
PROBLEM OCCURED: the macro switches back to the VB application showing
this form instead of staying with Excel
....

Purpose of the macro:
I have this VB application which provides Visual Basic Editor for
writing VBA macros. In order to import data from any Excel sheet, I
open an Excel workbook with the macro and then want to show a VBA form
on top of the opened Excel sheet. The Excel sheet itself cannot contain
any macro at all. Those Excel sheets will have the data always in
different columns so the user needs to see the Excel sheet as well as
the form in order to enter the proper column names in the form.

I would appreciate any help of you guys. MANY THANKS in advance!

Best wishes,
kuhni

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there way to enter multiple values into excel cells w/ a form? grassfed Excel Discussion (Misc queries) 1 June 22nd 05 05:26 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
How to..use worksheet form and save data to an Excel list Jan Excel Discussion (Misc queries) 2 June 10th 05 04:45 AM
View of Excel form is different on different computers. SJuker Excel Discussion (Misc queries) 1 March 9th 05 02:47 PM
Excel workbook fails to display when selecting from my documents. 4jjgolly Excel Worksheet Functions 1 March 9th 05 01:48 AM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"