473,396 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Using another XL spread sheet

I am looking for a code that enables me to open another excel spread sheet while i am in my XL form i have this code - Workbooks.Open Filename:= "OtherFilename.xls" - which opens up the XL spread sheet that i need however my form sits ontop of the xl spread sheet and i am unable to do anything to the spread sheet in the back ground.

I need a code which will bring up the other spread sheet and allow me to use it without closing my form?????
Nov 17 '06 #1
5 3172
albertw
267 100+
I am looking for a code that enables me to open another excel spread sheet while i am in my XL form i have this code - Workbooks.Open Filename:= "OtherFilename.xls" - which opens up the XL spread sheet that i need however my form sits ontop of the xl spread sheet and i am unable to do anything to the spread sheet in the back ground.

I need a code which will bring up the other spread sheet and allow me to use it without closing my form?????
hi

Workbooks.Open Filename:="yournewfile.xls"
ActiveWindow.ActivateNext
Nov 17 '06 #2
hi

Workbooks.Open Filename:="yournewfile.xls"
ActiveWindow.ActivateNext
Hi

Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"
ActiveWindow.ActivateNext

This still does not allow me to access the needed worksheet my user form still sits at the front.. any ideas???????
Nov 17 '06 #3
albertw
267 100+
Hi

Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"
ActiveWindow.ActivateNext

This still does not allow me to access the needed worksheet my user form still sits at the front.. any ideas???????
hi

msiunderstood
thought you wanted the loaded form to be on top

just use Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"

this will be the activeworkbook now.
Nov 17 '06 #4
hi

msiunderstood
thought you wanted the loaded form to be on top

just use Workbooks.Open Filename:="I:\MNP Atlas Templates.xls"

this will be the activeworkbook now.
My user form still sits ontop and i cannot access the workbook sitting in the back ground

Sorry to be a pain
Nov 17 '06 #5
albertw
267 100+
My user form still sits ontop and i cannot access the workbook sitting in the back ground

Sorry to be a pain
how abt if you opened the file manually?
the opened file should be on top, at least on my computer it is.

furhter your can minimize the userform by .windowstate=vbminimized
Nov 17 '06 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: WStoreyII | last post by:
Hello, I was wondering if there was a way to open a spread sheet up in a windows mdi form. I have tried the spreadsheet control but that does not work because i wish to open up an exisiting...
13
by: UnaCoder | last post by:
Hi, I'm trying to use client side JavaScript from an HTML file to open and make changes to an Excel SpreadSheet using ADO w/ ODBC. What a pain it is to do this. Anyways, I am able to open the...
1
by: Gonzosez | last post by:
How can I extract data from an excel spread sheet? I know the sheet name but the range varies.
2
by: RICHARD BROMBERG | last post by:
I wrote a small Access application that accepts a City Name and a Street Name and runs a Query based on them . I want to create an Excel Spread sheet that contains all the matches found by the...
2
by: glibo | last post by:
I am trying to change the tab name when i open a excell spread sheet on the run time in c#. I changed it in the code: Response.AddHeader("content-disposition","filename=" + sFileName + ".xls");...
0
by: comp21 | last post by:
Hi, Now, I have retrieved or imported data from excel spreadsheet to vb6 application. Now I want to compare this part of data with the one already existing in mssql2000 server(table name being...
5
by: cdavii | last post by:
Anyone have an idea why i get null values when i import data from a ms spread sheet in a sql tbl. The table elemet(Spread sheet) in question contains alpha numerics. The sql table is populated with...
0
by: yrameshbabu | last post by:
Hi All, I need to build Spread Sheet on Webpage or win form using .NET libraries like excel. I didn't need exactly as excel. but i need to develop some basic fuctionalities. Any body can help me...
2
by: harichinna | last post by:
Hi to all, My name is hari, iam trying to delete the column value of spread sheet using c sharp, iam trying to get the value and compare, when comparing it showing some errors, can any one help...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.