Over 1 million tech questions and answers.

Open Excel workbook in active window rather than first window

Q: Open Excel workbook in active window rather than first window

Hi,

I have recently upgraded to Windows 7 and Office 2010 and though I'm starting to get used to all the changes there is one thing which is really bugging me.

When I have two separate Excel windows open and open an Excel file from Windows Explorer the file will open in the first window not in the active Excel window. If I want to open a file in the second window I need to do it via Open.

Is there anyway of fixing this?

Thanks,

Emmy

RELEVANCY SCORE 200
Preferred Solution: Open Excel workbook in active window rather than first window

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Open Excel workbook in active window rather than first window

When you open a xls-file in explorer both excel windows are inactive, so what do you mean?

Read other 9 answers
RELEVANCY SCORE 85.6

I have posted this problem at four forums and no one has an answer. It is common knowledge to most that when opening multiple windows the top one should stay active,focused. Well that is not the case on this PC as of about two months ago.

As soon as I open a second window it is not active. I am required to click the page to make it active. THis should not be happening. I have another Compaq right next to this one and do not have that behavior. Sure wish I could find out the cause of this. Thanks for any suggestions.

Edit: I might add the same behavior happens with Firefox. Come on people "Put your thinking caps on". Am I not stating the problem clear enough to evoke a response? Right now I don't know how to explain it any clearer.
 

Read other answers
RELEVANCY SCORE 85.6

Top open window does not stay active
I have posted this problem at four forums and no one has an answer. It is common knowledge to most that when opening multiple windows the top one should stay active,focused. Well that is not the case on this PC as of about two months ago.

As soon as I open a second window it is not active. I am required to click the page to make it active. THis should not be happening. I have another Compaq right next to this one and do not have that behavior. Sure wish I could find out the cause of this. Thanks for any suggestions.

A:Top open window does not stay active

Hi needtolearn,

That's an unusual and interesting problem. Not surprising you haven't found a solution yet. That said, why don't you try some stuff.

Here's what I would try.

Do a system restore back to before the problem began, if you have a restore that far back.

See if it happens in the Safe Mode. If not, it is probably something that
that is loading during a normal boot and can be found by going to msconfig and unchecking everything (even your virus and malware applications, but stay off the internet while testing). If that stops the problem, selectively recheck the items until the culprit is found. Again, don't go on the internet until you have re-enabled your virus and malware programs.

Check the startup folder in Start>Programs and see if there is something there that is starting up that might be the problem. You can copy those shortcuts to an adjacent folder to stop them from loading at boot time. Place them back as needed.

Do some malware and virus scanning. Use two or more scanners as some pick up items that the others miss. You can download some free scanner programs here:

http://www.pcworld.com/downloads/fil...scription.html

Hope one of these will help,
Mack1

Read other 7 answers
RELEVANCY SCORE 84.8

Hello,

I am having an issue with Internet Explorer 11. I noticed a few weeks ago that when I use IE 11 that I keep having to click on the window to keep it active, even if I have no other windows open. If I open IE 11 window and start typing a login somewhere I get 4 or 5 characters typed in then window goes inactive and I have to click back in the text box to finish typing my login. If I am browsing I sometimes have to click back on the window somewhere to continue scrolling on a page.

This is getting annoying so I would like to find out a fix if possible. I do have Firefox and Chrome that DO NOT have the same problem. I use different browsers for different tasks and would like to resolve this if anyone can help.

Thanks so much.

Read other answers
RELEVANCY SCORE 84

Hello,

I'm unable to drag and drop icons from desktop to an open window or open window to open window

what happens is when i hold down the left mouse button to drag an icon from the desktop to an open window

*** the cursor changes to a black circle with a diagonal line going through it (like the no smoking sign symbol)

what is causing this to happen?

thx rob
ps: ONLY copy/cut and paste works now
 

A:unable to drag and drop icons from desktop to an open window or open window to open w

Check this setting. Enable Dragging and Dropping
 

Read other 1 answers
RELEVANCY SCORE 82

Hi,

On a PC in our office, there are a number of Excel 97 files which have a problem.
I think they were originally created on a Windows NT, or possibly even Win3.1 machine, resided on a floppy and were eventually given to someone in our office to enter data.
The files are stored in the My Documents folder on a W95 machine.

These files can only be opened by starting Excel and using the Open command and locating them.
If I try to open them directly from the My Documents folder, I get a series of error mesgs, splitting the name of the file and path:

Cannot find file C:\My.xls
Cannot find file Documents.xls
Cannot find file \Cold.xls
Cannot find file Repairs.xls

and the file refuses to open.

If I save the file to disk and try running it from another PC, it says "file may be read only", which it is not.

The file contains no VB code and no add-ins are loaded.

I also tried copying all the data from the file into a new file. This worked until I moved the old file out of My Documents and renamed the new file "Cold Repairs", upon doing so, the same errors occurred again.

Any ideas?

Cheers,
Gram
 

A:Excel 97 file only opens from open Excel window. Help!

Read other 8 answers
RELEVANCY SCORE 81.2

Somehow my Excel is not behaving as I would like it.

Previously I could open multiple documents and each would open in it's own window -- I could easily switch between documents by selecting the file on the Task Bar.

Now, however, if I have a document open and proceed to open another, it opens in the same window and I have to select my documents within Excel (Window pull-down). I said <b>New Window</b> but it just keeps opening my docs in the same window

Please help me retain my sanity....
 

A:Excel - Open New Window

Read other 10 answers
RELEVANCY SCORE 80.4

I know before we upgraded, I could open two separate excel files in their own windows, so I can compare, etc without switching back and forth.

I have the newest MSO and running Windows 7 Home Premium.

Thanks so much in advance! b(^_^)d

A:How to open two Excel sheets in their own window

I am guessing you have MS Office 2010. I don't have that version but try this. Open two spreadsheets, click on "Window" and you will see "Compare Side By Side". That will put both of them on the screen at one time.

Read other 6 answers
RELEVANCY SCORE 78.4

I used to be able to hit cntrl-n and open multiple windows, but now, it opens in the same window. I was pretty sure there was an option in internet tools to change this setting, but cannot find it. Can someone please help me?

I'd greatly appreciate it!

Thanks in advance!
 

A:Only able to open one browser window at a time..cntrl-n opens page in same window

Read other 6 answers
RELEVANCY SCORE 78.4

Whenever I search in W7, I want to have the ability to open found folders in a new window. If I r-click, that option is not there. Is there a way to add this to W7?

Also: When I go to 'open file location', the file's folder opens in the same window - highly annoying. In Vista, it opens in a new window. Anyway to change this behvior in W7 to act like Vista, so the file opens in a new window?

Thanks!

A:Adding 'open in new window' to search results, & opening in new window

assume this option was there on your windows 7 earlier? did you make any changes to your computer recently?

Read other 6 answers
RELEVANCY SCORE 78.4

I would like to be able to open a new browser window in Firefox which would start at the identical location to the one that's open rather than opening at the home page.

In IE, File / New / Window works well for this purpose, and then if you wanted it to start at the Home Page, you could just run Explorer a second time.

It gives the flexibility of going off on other trails with the additional window, but still having the original window open. I'm not crazy about tabs which take up extra space in the browsing window. However, is there even a way to open a new tab at the same location as the current window? Maybe I'm missing the joy of tabs somehow and am stuck in my old way of thinking. Still, I would like to know if what I want is possible.

Thanks.

A:[SOLVED] Open new browse window at same location as current window

Hi I don't think that is an option but I understand what your after and this is the way I do it with keyboard short cuts of

Ctrl + C = copy (While holding down Ctrl tap the C key once)
Ctrl + V = paste
Ctrl + T = new tab
Ctrl + N = New page

OK starting with tabs which I think is the best thing since sliced bread. You have the page open that you want to start with go up to the URL at the top of the page (do it with this page) click only once on the URL this will highlight it or if you like to say select it.

Now to copy the URL Ctrl + C your computer will remember this link until you either copy something else or you shut down the computer.

Now we open a new tab Ctrl + T a new blank tab will open and the URL location is blank but with the cursor already in it so we paste the URL there by Ctrl + V and tap the enter key and you have the duplicate page

Now working with a new page there is just a couple of small differences.

You have the page open that you want to start with go up to the URL at the top of the page (once again do it with this page) click only once on the URL this will highlight it or if you like to say select it.

Now we open a new page with Ctrl + N a new page will open but the difference is it will not be blank it will be your home page so as there is already a URL that we want to get rid of. The simple way is to once again click on it only once to select it then paste the saved URL by Ctrl + V and tap the enter key and ... Read more

Read other 8 answers
RELEVANCY SCORE 78.4

I have a Lenovo N580 laptop. Last week, I had to do a factory reset (with help from Lenovo Tech Support) because of compatibility problems with new software from my employer and windows 8.1 which is actually worse than windows 8. The compatibility problems caused my screen to go black. When booting, the Lenovo logo appeared and I had a cursor, but nothing else accept a black screen. I tried suggestions found here and the Lenovo help forum, but none worked and the factory reset was the last resort. Now I am back to using Windows 8 (this was actually the second factory reset due to other problems caused by win 8.1).

Anyway, everything is working (for now) and I also have Classic Shell installed. HOWEVER, before this second factory reset, when I had multiple windows open, aero peek worked fine. Now, it doesn't. I followed earlier suggestions of right clicking the taskbar, then clicking Properties, but the box for "Use Peek ..." is dimmed (grayed out) so I cannot check it to enable aero peek.

I got used to this feature in Win 7 and was glad to see it in Win 8, but it is the only feature about Win 8 and 8.1 that I like. Thanks for your help.

A:Window doesn't open full screen when hover over IE window

Right click on the Taskbar and select Properties.

Read other 2 answers
RELEVANCY SCORE 77.6

windows 10 fall creators update - windows 2016 office 365 - own software developed on delfie now on sql

i use a own program to export information to excel -

i use two screens one bigger than my laptop - when i use to open it it was always a small window and had to expand always

today i googled and read that you have it right click top page select size and drag to new size - great i thought until i moved my excel sheet to my laptop - now i can not get it sized again - is there a way to reset to original settings

if i open a excel sheet from excel it is as usual the correct size - just this way above it gives me the pic attached
 

Read other answers
RELEVANCY SCORE 77.6

I can't open MS Office application files from the Explore window or from Desktop.

The MS Office applications icons, such as WORD or EXCEL, have been replaced. All my Word files now bear the Wordpad icon and when clicked open as such. My Excel files now bear some other icon that no application on my machine can open.

However, when I open an office app, such as WORD or EXCEL, and then try to open a related file that now has a funny icons, they open properly.

Have MS xp; Excel 2002; Word 2002.

Grateful for advice.

A:[SOLVED] Can't open Word or Excel files from Explorer window

You probably need to set the file assocations.

If you go into your Control Panel > Folder Options > File Types (tab), then scroll down until you locate those file extensions (.doc, .xls, etc...).

Alternatively, there is probably somewhere in Microsoft word, or excel where you can automatically set file associations, but it would depend on which version you have.

Read other 2 answers
RELEVANCY SCORE 77.6

Hi Team,
we are facing issue while using showModalDialog window in IE11 and EDGE, so we have replaced windows.open method,
but its not working modal dialog window.
please let us know how create window.open window as modal dialog window. we are not interested in
JQUERY

Thanks


Srinivas

Read other answers
RELEVANCY SCORE 77.6

I just got a new laptop with Windows 7, 64 bit system.
When I open an email...it opens correctly, but when I want to double click for the next window to open, I have to have toRIGHT click that window and instruct Windows to "Open to new Window".

Is there any global command that can activate this procedure automatically.
Thank you
Dieter
 

Read other answers
RELEVANCY SCORE 77.6

As Edge browser doesn't support modaldialog, I want to pass some value to another window using window.open
From a parent window say A, trying to open another window - ChildWindow.htm using window.open. I am unable to pass string value from A.


var dialog = window.open("Child_Window.htm?", "title", "width=550px, height= 350px,left=100,top=100,menubar=no,status=no,toolbar=no");

dialog.MyVariable = "some string value";
dialog.opener = window;

In Child window, I get undefined reading the variable in the second window.


window.MyVariable 

Read other answers
RELEVANCY SCORE 76

Hello,
I am currently working on a genealogy project.
I am entering 1700+ names and dates into a awesome open source software.
My set up is .... Wordpad open to text I am entering from on the left side of screen. Website open on right side of screen.
I am trying to streamline this process as much as possible, but when I click to enter a "new person" a new window pops up with the "form" to fill in and it opens in the middle of the screen which covers half of both files.

How can I set this to open directly over the window that it opens FROM ? so that my internet windows stay on the right and my text file on the left and nothing is covered when entering the data?

HELP! Moving the window every single entry is frustrating and time consuming not to mention if I move it a little too far right the slider is hidden.

A:Need NEW Window to open directly on top of Previous window

is the "new person" popup a open and close type thing? or can it just be left open behind another windows and then brought to the front when needed

Read other 2 answers
RELEVANCY SCORE 74

Using Excel 2010. I regularly download data from a database which have to be sorted by

column 1 - cell color blue on top, then
column 1 - cell color orange on top, then
column 4 - value, from newest to oldest

the data is always downloaded automatically to a workbook named "ABC", and the worksheet is always automatically named ABC#, with the # changing automatically.

the macro is saved in the personal folder. I tried to record using absolute and then as relative reference. the macro NEVER works when I tried to run in any new downloaded workbook or even I recreated the same data in a new untitled workbook.

the number of columns is always the same but the number of rows varies. there are about (7) cell colors, but only the blue and the orange need to be on top

the recorded macro always indicate the name of the worksheet and workbook on which it was created. is this why it does not work on any other workbook or worksheet?

any help will be appreciated
 

A:Excel Macro Won't Open in Different Workbook

Read other 14 answers
RELEVANCY SCORE 74

Hi There

I have recorded a macro that opens up a workbook from my C drive as follows:

Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

I also recorded a macro that opens a workbook from windows as follows:

Windows("Salem's Point 1L 40M-2423.xls").Activate

I want to combine these two macros to do the following:

If Salem's Point 1L 40M-2423.xls is aready open then do the code Windows("Salem's Point 1L 40M-2423.xls").Activate

If Salem's Point 1L 40M-2423.xls is not open then do the code Workbooks.Open Filename:= _
"C:\Documents and Settings\Mario Pincivero\My Documents\Homes\Salem's Point 1L 40M-2423.xls"

Please help

Mario
 

A:Excel Macro to open a workbook

Hi Mario,

When you say you open a workbook from your C-drive.
Are you executing your macro from within an Excel workbook or how?
What do you trigeer it with or where do you trigger it from?
 

Read other 1 answers
RELEVANCY SCORE 74

Good Day Moderator,
just got to the core... I've problem to open an excel workbook which contain macros from visual basic at run-time. Thats it, I don't know what properties or method that I should used.

For your illustration, perhaps I should write some of them in here ( hope you don't getting bored with this )

dim strFile as String
dim objExcel as Excel.Application

strFile = InputBox("Please input your excel file full path :","C:\")

Set objExcel = CreateObject("Excel.Application")

With objExcel
.DisplayAlerts = False
.Workbooks.Open strFile

MsgBox "Your name is : " & .ActiveSheet.Range("D1")

.ActiveWorkbook.Close False
.Quit
End With

While trying to process the Msgbox's function, it said that "Object variable or With block variable not set", just like if the object has not successfully created.

Do you have any idea with this ? I really don't know what to do.
Thanks a lot for your help and have a nice day

Best Regards.
 

A:Open an excel workbook which contain macro from vb

I don't claim to do VBA, but I dabble.

In the first place, if you are creating this code in an Excel file, I don't think you need to declare Excel as the application at all.

I think you should be creating a workbook object and not an application object.

I just tried it out, and I get that darn Error 429, but I think that's better than what you're getting.
 

Read other 1 answers
RELEVANCY SCORE 73.2

One particular Excel workbook takes approximately a minute to open and is slow to respond to commands. The problem existed when I used Office 97 and still exists now that I use Office XP. I have checked Add-ins and scoured the threads for a possible solution. All other workbooks open as normal.
 

A:Excel Workbook slow to open and respond

Read other 10 answers
RELEVANCY SCORE 73.2

I have an Excel workbook. What I would like to happen is find some way to open and close the workbook first thing in the morning. There is code that runs when the workbook is opened.

Does anyone know a good way to perform this operation?
 

A:Solved: Excel Open and Close Workbook

Read other 16 answers
RELEVANCY SCORE 73.2

I open an existing workbook. When I do it opens a blank workbook and the file I chose?
Is there a known reason this is happening?

I am using:
Windows 7 and
Office 7

Thank You,
Michael D
 

A:Why when i open Excel workbook a 2nd blank opens?

Read other 6 answers
RELEVANCY SCORE 73.2

I have created a userform within a workbook that contains a command button. The comman button on the user form is coded to open another workbook.

This all works fine. The problem is that the code behind the Workbook_Open event in the second workbook does not run.

Hoe can I get the code in the Workbook_Opem event to run when the second workbook is opened?
 

Read other answers
RELEVANCY SCORE 73.2

    // open new pop up window
    this.childWindow = window.open("about:blank", "_blank");   

    this.childWindow.document.write("<p>Loading..</p>");
    this.childWindow.focus();

    // submit form to cross origin domain from the pop up


    this.childWindow.document.write("<form name='xform' method='POST' action='" + this.url
+ "' enctype='multipart/form-data'><input class='form-control' type='hidden' name='msg' id='xml'></input><input class='form-control' type='submit' id='formSubmit' style='display:none' ></input></form>");         this.childWindow.document.getElementById('xml').value = response.message;
    this.childWindow.document.getElementById('formSubmit').click();
    // window closed event


    this.timer = setInterval(() => {


      if (this.childWindow && this.childWindow.closed) {
     // logic here when window closed
   

        clearInterval(this.timer);
&nbs... Read more

Read other answers
RELEVANCY SCORE 73.2

hello. Everytime i open a new window in IE another blank page pops up. I have tried reading other threads about this issue but i get totally lost and have no idea where to begin. If someone can please help me get rid of this dang problem i would appreciate it greatly.

Thanks!
Kim
 

A:new window pops up when i open a new IE window

Hi, thadiiva.

Welcome to TSG.

Click here to download HJTInstall.exe

Save HJTInstall.exe to your desktop.
Doubleclick on the HJTInstall.exe icon on your desktop.
By default it will install to C:\Program Files\Trend Micro\HijackThis .
Click on Install.
It will create a HijackThis icon on the desktop.
Once installed, it will launch Hijackthis.
Click on the Do a system scan and save a logfile button. It will scan and the log should open in notepad.
Click on "Edit > Select All" then click on "Edit > Copy" to copy the entire contents of the log.
Come back here to this thread and Paste the log in your next reply.
DO NOT have Hijackthis fix anything yet. Most of what it finds will be harmless or even required.

 

Read other 1 answers
RELEVANCY SCORE 73.2

I have Windows 7, IE 8, 8gig RAM, 208gig Hard Disk Free Space.
When opening a Website I get the initial window OK. But when I attempt to open a window that has an Icon indicating next window, I try to double click that Icon...nothing happens. I have to Left click my mouse and initiate the command, Open with new Window. I do that and the new window does open the site.
However, I want to just double click the link Icon and have it automatically open the new window.

Is there some setting that I must correct to get the appropriate window to open when I click on the icon for the next window to open?

I certainly can go ahead and left click my mouse as it points to the link I want to open...but it is a little bit of time-wasting.
Any suggestions in how I can properly set the opening of windows with just a mouse click?
 

A:Trying to access Next Window, I must go to OPEN IN NEW WINDOW

Read other 6 answers
RELEVANCY SCORE 73.2

I just replaced my old W2K HD with a newly purchased HD and installed
Windows XP Pro/SP2 with all the latest updates from MS.

In MS Word document, say, myTest.doc, write a hyperlink line like this:

http://www.google.com

When opened this web page by placing cursor on the line and click, the Google
page appears briefly on the myTest.doc window but immediately closes and
opens a new, different size window for the Google web page.

Problem 1: In the old Windows 2000, the Google page remains opened on the same
window overlapping the myTest.doc window and no new window is opened.
Apparently this is a setting problem but donít know what that is.
Please help.

If this problem can be corrected, the following question may be automatically
answered and corrected.

Problem 2: On the new Google window, clicking Back button opens the myTest.doc,
but the Google window remains open. In Windows 2000, it closes.

Please help.
 

Read other answers
RELEVANCY SCORE 72.4

Client has SharePoint 2010 project server.
When the user clicks on a Excel file, the file open in the browser and when the user click on "open in Excel" we receive the below message 
"To open this workbook, your computer must have a version of Microsoft Excel installed and your Web browser must support opening files directly from Excel in the browser."
Below is the browser version 


However when the same is tried/accessed through a browser deployed on a dev machine, it works normally. Below is the version of the IE on the DEV server

What is causing this to happen?
Is there any tool to check the difference between the IE settings on my Desktop and the dev box.

Satyam....

Read other answers
RELEVANCY SCORE 72.4

Hello,
I work with Excel 2010 and have a series of workbooks (preop_management_AAA.xlsm, preop_management_BBB.xlsm, preop_management_CCC.xlsm) that each have a worksheet named 'Medications.' From the 'Medications' sheet, I have a macro in each which opens a common workbook named bridging.xlsm. After doing calculations in bridging.xlsm, the user returns to the workbook from which they started and proceeds to the next worksheet in the original preop_management_xxx.xlsm workbook via a macro named 'NextFromMedications.' Only one of the preop_management workbooks will be open at any one time.

I need help writing code that will call the 'NextFromMedications' macro in the open preop_management_xxx.xlsm workbook from the bridging.xlsm workbook. While the name of the macro is the same in each of those workbooks ('NextFromMedications'), the file name is variable so if I write (in bridging.xlsm) something like
Application.Run "'preop_management_AAA.xlsm'!NextFromMedications"
the macro would only work for one of my three "originating" workbooks. I am looking for a way to "generically" refer to the file name in the 'NextFromMedications' macro.

I cannot put the 'NextFromMedications' macro in my PersonalMacro workbook since these workbooks will be used by multiple users on multiple computers.

As always, I thank you in advance for your time and consideration.
 

A:Solved: Running a macro in a different open Excel workbook

Read other 10 answers
RELEVANCY SCORE 72.4

Hello everyone. I've done a search on this forum and although there are similar threads, there isn't one that quite fits the bill...

The attached spreadsheet is something that I aim to have as an automatic email generator, based on information I input. The spreadsheet will be opened daily, and upon opening it generates the emails so that all I have to do it hit 'Send' on my Outlook for each action.

(Open the attached spreadsheet)

The first thing I do is to enter the date (column C). I then populate the email name in column D. Once I have this information I then need to input how many priority (1-5) actions there are for that person in columns F-J.

So... (I'm taking Row 4 as the example here)

An email is sent out initially to Joe Bloggs, informing them that they have two priority 1 actions, three priority 2 actions, one priority 3 action, and two priority 4 actions. (see note 1 below).
Once the initial email is sent out, the spreadsheet waits until the next action point is triggered. In this instance it is 24 hours later, because Joe Bloggs has two priority 1 tasks. As you can see, this trigger is column K, which populates automatically based upon column C. The text to be sent out is in Note 2, at the bottom.
The above process is completed for each action, so that a separate email is sent out depending on the dates in columns K-O (the timescales are given in the comment in cell F2.
Finally, when an email is sent out (using columns K-O as their pro... Read more

Read other answers
RELEVANCY SCORE 72

Hi All,

I am running Windows Vista Home edition and have Mozilla and Windows IE 8.0 installed. Whenever I start up the computer and turn on Mozilla, after a few minutes IE opens a window saying that it is unable to open the window "Favorit". It doesn't conect to the internet, even though it should be able to. This happened before and after I installed IE 8. I've run Symantec Virus Scan with 0 results. I've posted this before, but nobody has been able to fix the problem. Does anyone have any ideas?

Thanks,

SteveG297
 

Read other answers
RELEVANCY SCORE 71.6

I have an Excel 2010 workbook (named bridging.xlsm) which can be opened from one of several other open workbooks. I am trying to write code that will re-activate the workbook (which will always have "preop_management" as part of its file name) which opened bridging.xlsm after I am finished working in bridging.xlsm.

I have found code which lists all open workbooks and copies their file paths into a worksheet in the bridging.xlsm workbook. From there, I added code which looks for the path which contains "preop_management" as part of its file name and pastes that entire path name into a cell named 'ReActivate.'

Sub ListWorkbooks()
Dim wb As Workbook
Dim j As Single

For j = 1 To Workbooks.Count
Sheets("Logs").Range("C1").Cells(j, 1) = Workbooks(j).FullName
Next j

Cells.Find(What:="preop_management", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Copy
Range("ReActivate").Select
ActiveSheet.Paste

End Sub

I am unsure of the syntax which will open the path/file which was pasted into an Excel cell. My question is, how can I use VBA to activate/re-activate the workbook named in the cell 'ReActivate?'

As always, the expertise and time of this forum's members is much appreciated.
 

A:Solved: Re-activate an Open Workbook from a List in Excel Worksheet

Hi

If the workbook is still open you cannot use the full path - just the file name and extension e.g.
Code:
Windows("File Name.xlsm").Activate
or

Code:
Workbooks("File Name.xlsm").Activate
You can change your macro to record the file name without the path with
Code:
Sheets("Logs").Cells(j, 1) = Workbooks(j).[COLOR=red][B]Name[/B][/COLOR]
Or, add it to the next column with
Code:
Sheets("Logs").Cells(j, [COLOR=red][B]2[/B][/COLOR]) = Workbooks(j).Name
but if you are always going back to the original file that opened all other files you can simply do
Code:
Workbooks(1).Activate

 

Read other 2 answers
RELEVANCY SCORE 70.8

I am on Vista and Ecel 2007

Everytime I open an existing work in excel it opens that workbook and a new "BOOK 1" This started after I installed aspa utilities. Can someone tell me where to go to stop the extra Book from opening each time?
 

A:Solved: Excel 2007 extra book 1 when I open an existing workbook

Read other 15 answers
RELEVANCY SCORE 70.8

I have seen this question posted but no good answer.  I have a Excel 2016 generated web page (.mht) and an Excel workbook all stored on a SharePoint 2016 site.  I have generated .png's on one of the Excel worksheets in the workbook and published
that page only as an .mht file.
I need to be able to insert a hyperlink on the .mht page that corresponds to a specific tab (worksheet) in the workbook.  When I create a hyperlink in Excel it will only open to the last page viewed and ignores the syntax to open to the specified sheet.  
Does opening a link to a specified Excel tab work from the browser to an Office application such as Excel.

Read other answers
RELEVANCY SCORE 70.8

Hello Everyone

I am having some difficulties finding a solution to my problem. I am hoping someone can help or lead me to the right direction.

I have a workbook called Data.xlsm, below is a sample:

ID, Name, commission
1 john 1000
2 eric 2000
3 ryan 3000

Now I have another excel file called Temp.xls which looks pretty much the same as Data.xlsm.

ID, Name, Commission
1 john 200
2 eric 300

I need a macro that will read the Temp.xls and grab the commissions and bring them to Data.xlsm. The commissions need to be summed based on ID.

The final Result on Data.xlsm should be as follows:
1 john 1200
2 eric 2300
3 ryan 3000

Any help would be greatly appreciated.

Thank you
 

A:Solved: Excel Macro - Upload Workbook value from Another Workbook based on ID

Just a quick and dirty solution

Make sure you place this in the same folder as your Temp.xlsm file and press the button

It will open Temp
update the data, if a new Id is in Temp it will add the data and set the commission values in Temp to 0 to avoid running it twice.

I hope the code explains itsefl.

Think of a macro of a step by step instrcution as you would say it out loud.
 

Read other 3 answers
RELEVANCY SCORE 70.4

Hello,

When I'm working sometimes the current window I am working in will shift/move behind another open window. It will continue to move till I minimize all open windows. A friend suggested it was a memory issue but I don't think so because I'm the only user on the computer to have the issue.

Thank you

A:Open Window moves behind another open Window

How many windows are you getting?

You can hit ALT and TAB key together, that will show all the windows open, then click on the one you want on top.

Read other 6 answers
RELEVANCY SCORE 70.4

Hello,
I have a master workbook with 20 worksheets. 5 worksheets in the worksbook are distributed to field reps, but the remaining 15 worksheets are not. What is the best practice for receiving the 5-worksheet workbook from the field rep and importing the data into the 20-worksheet master workbook? If I merely use Copy Sheet I am able to copy the worksheets into the master workbook but then I have to remove the pathname references in each of the copied worksheets in order to map the data in the master workbook - which is quite cumbersome. Suggestions?
 

A:Populating data from one Excel workbook to a master workbook

Hi jpirhalla, welcome to the forum.

Have you tried moving the sheets over. Dragging the sheet from the field reps back into the now-15-sheet book?
 

Read other 2 answers
RELEVANCY SCORE 70

Issue in IE11:

when parent window had a alert triggered, that makes the child window lose focus and go behind

Scenerio:

There is a button in parent page (domain A) and on click of the button Popup window (Domain B) will open and child window will communicate back to parent window. when parent window had a alert triggered, that makes the child window lose focus and go behind
only in IE11 browser.

IE edge and other browsers we can see the popup window on top of the parent window. 


is there any fix to retain popup window on top of parent window until user closes the popup(child) window.

Read other answers
RELEVANCY SCORE 69.2

I use two monitors when I browse, and for some reason recently something seems to have changed. Now it seems that when a browser finds the website to which it was directed that browser becomes active, so whatever I happen to be typing on the other monitor suddenly is being typed on the newly active window. I know this sounds trivial, but it is very annoying, and has been the cause of some serious disruptions. As I said, this is a recent occurance, but I have not made any changes to IE, no one else uses this system and I update and run a full system scan with Norton's Anti-Virus every Friday.
It seems to me to have a simple solution, but I have been unable to locate it myself.

Thanks,
JTN
 

Read other answers
RELEVANCY SCORE 69.2

How can I keep a window (not maximized) on top when it isn't the active window? ie: small progress bar on screen while working in another application. (I am developing a VB app.)
 

Read other answers
RELEVANCY SCORE 69.2

Have an unusual wish maybe... used alot of linux before and edit a lot of textfiles in separate windows and miss a very handy setting.
I want to just point on the active window an be able to write in it, if just a bit of it is visable. I don't want it to popup in front of other windows which are covering parts of the active window.
I found the "make window active by just pointing on it" but that popups the window... Minor problem but...is it possible?

Janner

A:Keep active window behind

Originally Posted by janner


Have an unusual wish maybe... used alot of linux before and edit a lot of textfiles in separate windows and miss a very handy setting.
I want to just point on the active window an be able to write in it, if just a bit of it is visable. I don't want it to popup in front of other windows which are covering parts of the active window.
I found the "make window active by just pointing on it" but that popups the window... Minor problem but...is it possible?

Janner



Well, no, you cannot have an active window without it popping up to the front of the screen. The only time that this is possible is if there is another application window that has been specifically created by the developer with the "Keep on Top" flag. An example is the Task Manager that can be opened using <CTRL>+<SHIFT>+<ESC>. Task Manager is always at the top of the stack, whether it is the active window or not.

Sorry I couldn't give any other help on this...

Read other 1 answers
RELEVANCY SCORE 68.8

I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?

A:Excel 2010 - Workbook to Workbook Reference?

  
Quote: Originally Posted by Lewiedude


I have two workbooks that I am using and I am trying to add one cell's data to another cell in another Excel workbook. It used to be as simple as beginning to "add" another cell's data(from another workbook you just migrate to the other workbook) into a different workbook. It isn't working like it used to in Excel 2003. Cant' speak of it for Excel 2007 as I never had it.

Any thoughts on why it won't work? Any way to make it work?


Merging Data from Multiple Workbooks into a Summary Workbook in Excel

Looks like it's possible.

Also I would look at the DATA Tab under DATA TOOLS - CONSOLIDATE.

Read other 3 answers
RELEVANCY SCORE 68.4

While typing along in word or an email, the window I'm using becomes inactive. To get it back I have to click it. This happens every couple of minutes. At this rate I'm getting nothing done. It has happened twice since I began typing this message. What's happening and how do I fix it?
 

A:Active window becomes inactive

I suspect some scumware is lurking taking focus

SpywareBlaster http://www.javacoolsoftware.com/spywareblaster.html
AdAware SE http://www.majorgeeks.com/download506.html
SpyBot S&D http://www.safer-networking.org/en/download/

DL them (they are free), install them, check each for their definition updates and then run AdAware and Spybot, fixing

anything they say.

Do these before the next step.

Then get HiJack This http://www.majorgeeks.com/download3155.html, put it in a permanent folder, run it , DO NOT fix
anything, post the log here.
 

Read other 1 answers
RELEVANCY SCORE 68.4

When I start a new program etc. it appears behind the window that is open. I then need to shrink the front window to view the new one I just opened. How do I get the latest window to automatically appear in the front?
 

A:How to get active window to appear in the front

ecpool said:

When I start a new program etc. it appears behind the window that is open. I then need to shrink the front window to view the new one I just opened. How do I get the latest window to automatically appear in the front?Click to expand...

Well you could in IE tools>options>advanced and under Browsing check "reuse windows for launching shortcuts".
 

Read other 1 answers