Asked by duncanb7
at 2024-08-04 10:09:23
Point:250 Replies:9 POST_ID:828362USER_ID:11059
Topic:
Microsoft Excel Spreadsheet Software;Visual Basic Programming;Miscellaneous Programming
I would like to know how to run other new excel application in seperate Excel program window in VBA. When I try to use Application.Run "'new.xls'!smain" to run
smain module that will run the application in
my orginal VBA active excel window and not on a new Excel window. Some
people give me advise using Shell command to activate other application. Is it
right ? Run the new excel application in seperate Excel window will run faster
than two applications in one Excel Windows that I tested it before by manually open
two Excel files in two seperate Excel Windows
Please advise
Duncan
smain module that will run the application in
my orginal VBA active excel window and not on a new Excel window. Some
people give me advise using Shell command to activate other application. Is it
right ? Run the new excel application in seperate Excel window will run faster
than two applications in one Excel Windows that I tested it before by manually open
two Excel files in two seperate Excel Windows
Please advise
Duncan