How To Open Two Windows Of Excel

Jan 24, 2014

Every time I open a new file in excel it opens up the file and the other file I have open disappears. Can I open a file so that there will be two separate windows?

View 3 Replies


ADVERTISEMENT

Excel Macro - Open Windows Explorer Window Using VBA?

Jun 6, 2002

What's the code for opening a Windows Explorer window from within an Excel Macro?

View 7 Replies View Related

Minimize Windows And Allow Other Excel Work Books To Open

Apr 30, 2012

I have created a userform template and is working fine, the problem is the users are not able to minimize the template nor open any other excel files.

How to allow the template to open any other excel files or macro enabled files and also to minimize the windows.

View 1 Replies View Related

Save All Open Excel Windows After Respective Cell Names

Feb 17, 2009

I am trying to do something which is very slow and manual. What i have is like a seperate spreadsheet from every day and have to save each one down manually in the respective date. so for example column C has the date in already. Can you tell me how to save all the excel workbooks which are open (if i open them all) and then use the date in column C (which is in the format 20090217) and save it as a xls in the format 170209 and then close the workbooks?

sorry this is a huge question, just takes me so long to save them all.

View 10 Replies View Related

Open Windows

Mar 29, 2007

i'm having trouble with the following code. The first if statement works fine, it's on the second pass that get problems, i get a 'ERROR 13 type mismatch' on the Windows(NewFN).activate line and i cannot figure out why.

Private Sub cmdsave_Click()
Dim NewFN As String

Range("B5:G21").Select
Selection.Copy

If Module3.firstTime = "y" Then
NewFN = worksheets "Recalculate").Range "G5").Value
".xls"
Workbooks.Add

View 7 Replies View Related

Cant Open Spreadsheets From Windows

Oct 1, 2008

I've had a new machine, and for some reason if i try and open excel files by double-clicking on a .xls file, excel tries to open each part of the filename individually!!!!

For eg, if i have a file called week 1 report.xls, and i double click that, it gives me 3 messages saying:

cant find c:filepathweek.xls
cant find 1.xls
cant find report.xls

I can get round it by going into excel first, and opening the files from there but it's a right head-doer!!!

I'm on windows XP, and using excel 2003 to open the files...

View 9 Replies View Related

Open My Computer In Windows Explorer

Nov 19, 2009

The following 3 macros do the following.

1st macro . . . When the button is clicked for this macro, Windows Explorer is opened and the folder MyMenuFiles is selected. Works Fine.

2nd macro . . . When this button is clicked, the windows explorer opens with My Documents selected. Works Fine.

3rd macro . . . THIS IS THE PROBLEM ONE. When this button is clicked, windows explorer opens, with the C: drive selected. I want My Computer selected.

View 3 Replies View Related

Close ALL Open Windows Folders

Jul 10, 2012

I use the below code to close ALL open Internet Explorer pages. Im trying to adapt this to close ALL Windows Explorer Folders.

Dim Shell As Object
Dim IE As Object
Dim i As Variant
Set Shell = CreateObject("Shell.Application")
i = Shell.Windows.Count
On Error Resume Next
Do While i > 0
i = i - 1
Set IE = Shell.Windows(i)
If TypeName(IE.Document) = "HTMLDocument" Then IE.Quit

Loop

View 3 Replies View Related

How To Open A Folder In Windows Explorer

Apr 5, 2007

I'm sure this is really easy, but I'm learning and not having luck in the search option for previous posts. Thanks for your patience in advance.

I want to open a windows explorer window by using a button in Excel.

View 9 Replies View Related

Allow User To Choose From List Of Open Windows?

Mar 27, 2009

I have a few macros that need to work with various worksheets which are in different windows.

1. Make the user name the files a certain way for consistency
2. Make the user type the name of each window at the start of execution

I was wondering if there was a more flexible option though: one which would allow the user to choose from a list of open windows (similar to the Window>More Windows>Activate function in Excel).

Ideally the macro would run and say something like, "Which of the following open windows contains dataset1?" "Which of the following open windows contains dataset2?"

View 2 Replies View Related

Adding Folder To 'Open' And 'Save As' Windows

Aug 28, 2009

I had this set up in Excel 2003, but our main shared drive just went down and after remapping this link didn't work. How do I do this in Excel 2007?

I want a folder to show up on the left hand side of the "Open' and 'Save As' windows under My computer, desktop, My Documents, etc.

View 2 Replies View Related

Open Windows File Chooser At Default Location

Feb 14, 2012

Is there any way of making the default directory location for application.getopenfilename work properly with shared locations?

Presently I use ChDrive then Chdir but I cant use ChDrive if workbook is opened from a link in email for example. Please see below

I have a VBA routine that asks the user to load an existing file on startup.

I want the window for the file selection to open at the same folder every time. (the folder is on a shared drive)

The workbook to run the code will always be located on this same share at a fixed location.

My present code builds the path to the desired opening folder by collecting the drive letter from the current working directory (which has to be done as everybody maps there shares to different letters here, its not guaranteed to be the same! )

then i ChDrive to this letter.

Then I ChDir to letter plus myKnowndirPath

This works fine, the window always opens at my required folder. But only as long as the user has navigated to the folder containing the spreadsheet and then ran it from there. Because that way a drive letter is available.

However i found that if i sent a link to the workbook or its home folder. And the user opens the link or a windows explorer from that link and then runs file from there.

Then it stops working beacause there is no local drive letter in the working directory path. i.e. working directory shows as

'network \shareddrive
ootafolderanother arget

instead of something like
J:afolderanother arget

View 2 Replies View Related

2 Instances Of 2007 Slow To Open A File By Double-clicking And Entering From Windows Explorer

Sep 20, 2007

i use excel 2007, it s slow to open a file by double-clicking and entering from windows explorer, by googling i fould a fix by adding "%1" at the end of command in "Application used to perform action" (folder options/file types/xls/advance/open). however, to open files in the same instance, i have to keep "DDE message" with [open("%1")]. With both "%1", excel now opens twice.
How to fix it?

View 3 Replies View Related

Excel 2003 :: Slow Startup On Windows XP SP3

May 4, 2009

I'm currently running MS Excel 2003 on Windows XP SP 3. When I launch Excel from the start menu, it starts right up. When double-clicking an Excel file, it takes approximately 45 seconds to a minute to launch and open the file. This happens no matter what the file size.

View 1 Replies View Related

Excel 2007 :: No Secondary Windows Appearing?

Apr 18, 2013

My Excel gets stuck in a strange world sometimes where it seems like a pop-up blocker is turned on. By this I mean that i can't get question alerts to show in Excel. My only relief has been to reboot.

Here's what I mean - I generally see this two different times:

If I'm in a document that I've modified and click the "X" to exit the file - it never asks me to save, just closes without saving.

When I do a "find" on an item, I do get the first box where I can specify my search criteria. If there is a match, it will take me to the match if I do a find next. However, if I do a find all or there is not match, nothing else happens. I can see the cell addresses flickering in the name box.

View 2 Replies View Related

Excel 2010 :: Macros Not Working In Windows 7

Apr 29, 2014

I have a macro to collate data from multiple workbooks to a single sheet. The folder path to the source files can be chosen thorugh the macro. It runs perfectly in my system running on Windows XP. But it doesnt run on Wondows 7 system. Both are using MS Excel 2010. In Windows 7 system, while choosing the folder path where source files are located, it says "No items match your search" (screenshot attached). I would want the macro modified so that it runs on any platform. The macros that I'm using is given below:

[Code] .....

Untitled.png‎

View 10 Replies View Related

Launching Excel In Separate Windows As Default?

Aug 16, 2012

Each time I click on an Excel file the worksheet will open up within an existing Excel worksheet that I have open. This is frustrating when you are working with two monitors or screens (laptop screen and additional monitor) and want to view each worksheet separately in separate screens. What I end up doing, which is not efficient, is I'll open the second worksheet which will open up in an existing worksheet that I have open and then I'll close it, and then launch a separate Excel worksheet and pull open the recent file and I'll have two open worksheets (not within same Excel worksheet I already have open). This allows me to grab and pull one worksheet in a separate screen and leave the other as I need both open on two monitors.

Question: is there a way to default Excel when opening or double clicking an Excel file to automatically open in a separate instance of Excel and not in an existing open worksheet?

View 2 Replies View Related

Build Windows 8 App Based On Excel Macro?

Feb 24, 2013

I write a excel file (with macros included) to tackle the datas regarding stock market.

The excel file encompasses some information about financial reports, and some functions (macro) like sorting and filtering.

I'm wondering if I can build it as an windows 8 App and put it on the App market.

Or, in other words, can I make a windows 8 App by the functions in Excel ?

Can I do that ?

View 1 Replies View Related

Excel 2010 :: Macros From Windows To Macs?

May 30, 2013

I developed a tool in Excel 2010 using macros and launched it to a group of dozens of users. Turns out one of them uses a mac and says it is incompatible. I have never used Excel for Mac or tested my tool in it. Next I plan to test it on a mac but how to make this work?

View 4 Replies View Related

Cannot Access Minimized Excel Pages From Windows Task Bar

Sep 3, 2013

After minimizing my Excel form, I'm trying to re access it from the windows task bar. If I click on the Excel tab it shows me the 2 excel files I have open. I would normally just click on one of those and that sheet would be brought up, but I can't get either of them up - as soon as I click on one or other of them the window just minimizes again.

View 2 Replies View Related

Excel 2010 :: VBA Macro To Synchronize Windows Folders

Apr 19, 2013

Working with Windows 7 and Office 2010

I've created a Excel workbook with VBA code to synchronize an Access database between a laptop and a server. One of the fields in the database is a shortcut to a jpg for each record. (The Access stuff is not too important here)

Now I'd like to add the ability synchronize the photos between the laptop and the server; so people who use the server can view the photos added by the laptop and vice versa.

Something like:

Code:
For each [JPG] in [LaptopFolder]
If not [JPG] exists in [ServerFolder] then
filecopy [LaptopFolder][JPG], [ServerFolder][JPG]
end if
next [JPG]

That code wouldn't work.

View 4 Replies View Related

Excel 2013 :: Saving / Opening Workbook With Multiple Windows

Aug 7, 2013

With excel 2013 you're now able to open multiple windows or views of the same workbook. However when a workbook is saved with multiple windows open, the next user to open the spreadsheet will also open it with multiple windows. Which can be very annoying when most people work off of one window vs. multiple. Is there a way to disable saving the multiple windows or a macro to force open excel in 1 window?

View 2 Replies View Related

Excel 2011 :: Mac Recorded Macro Does Not Work With Windows - Runtime Error 1004

Nov 20, 2013

I have been given a macro recorded on a mac and it works fine with Mac Excel 2011. Unfortunately, I need to make it to work on a windows machine, but it comes up with an error message "macro unable to set width property of the window class. Run-time error 1004". When I press debug it takes me to the line .Width = 1456.

Below is the chunk of the code that becomes highlighted when pressing debug.

With ActiveWindow
.Width = 1456
.Height = 795
End With

View 3 Replies View Related

How To Overcome The "Formula Too Long" Error On Windows Excel...

Jul 9, 2009

I have worked on this really difficult long formula, but the problem is, I have been working from my Mac. And my office, which this formula was made for, is all PC. Now generally this isn't a problem, but apparently PC's have a limit on how long the formula can be. Is there anyway to overcome this? I really need this formula to work..

View 9 Replies View Related

VBA Open All Text Files In Excel In Folder And Save Them As Excel File

Dec 7, 2013

I have some daily text files in a folder (so about 30 of them each month), which in the end of month, I need to open them up in excel, format them so that I can use the information for my analysis.

I would like to create a macro, to quickly open them all up at once and save them each individually in .xls or .xlsm format.

I am new to VBA and after some research online, I was able to have the files open with the following code. but now I don't know how to proceed further to save them one by one with the same name but in .xls or .xlsm format.

Sub Opentxtfiles()
Dim MyFolder As String
Dim myfile As String

[Code].....

View 2 Replies View Related

Excel 2008 :: Cannot Open Structure Protected Excel Document

Mar 25, 2013

******** type=text/javascript>*********>******** type=text/javascript src="http://pagead2.googlesyndication.com/pagead/show_ads.js">*********>

I tried locking an excel document and i ticked a box that said protect structure, and then entered my password and now I cannot open the document. It is a white square on my desktop now with no options to do anything, it cannot even be attached to an email or deleted. This was on excel 2008 on a macbook.

View 1 Replies View Related

Why Does Excel Open Some Files As Csv

Dec 16, 2008

I receive excel reports every day. But the last couple of days when downloading the reports I get them as csv. Also older reports I have saved on the hard disk open as csv.

Well, the ones I have saved have are now csv files and I haven't done anything (knowingly) to change them to csv.

View 9 Replies View Related

Excel VBA - How To Get ID From NEW OPEN IE Window

Apr 21, 2014

I'm trying to find an ID from a new open Internet Explorer Window.

I know that the ID that I'm trying to search for is "rBeginMonth_BeginDate", but my code always says that it's empty.

The code below is partially of what I've done.

[Code] .....

View 1 Replies View Related

Open Excel File With VBA

Feb 18, 2009

I have a folder that contains many excel files. Each excel file is named as that date it was created, i.e. 02/18/09.xls

I would like to have some vba code that will open 'todays' file. Here is what I have so far:

An Excel file with the date founction in A1, =today(). I'd like to have a button that reads cell a1 and opens an excel file in a specific folder.

View 8 Replies View Related

Excel Documents Won't Open On First Try?

Nov 17, 2007

I am having problems opening Excel documents on first try. If I double click a excel doc icon it will start excel, hang for about a minute and a half then just display a excel blank doc. If I then go back to the original doc icon with excel still open and double click it again the document appears.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved