When I open an existing workbook, a blank sheet opens as well

Any ideas? Any time I launch a spreadsheet from a desktop folder for example, it opens it up but also opens a blank workbook. I am using Excel 2007, thank you.


On Oct 12, 10:35 am, "Bernard Liengme" >
wrote:
> In this workbook in the XLSTART folder? All XLS file in that file open when
> Excel starts.
> Also use Tools | Options; open the General tab and see if you have anything
> in the box "At start-up, open all files in:"
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVPwww.stfx.ca/people/bliengme
> remove caps from email
>
> "spmu" > wrote in message
>
> ups.com...
>
> > when opening an Excel Workbook, another blank workbook also opens.
> > How do I stop this extra workbook from opening?

Already check these options, so they are not the problem

I have recently upgraded to Excel XP and when I open an existing workbook,
Excel opens but the workbook does not, I have to go to file-open-workbook
name and then the workbook opens. Any suggestions why it will not open when
directly clicked on.

Hey all,
I have a template that needs to prompt the user to open an existing workbook
and then be able to reference that workbook's worksheets in order to copy
various columns from worksheets in the template over to the existing workbook
that was just opened.
Can anyone offer the best way to do this?

This morning when I tried to open an existing Excel workbook, it tells me that it is already open. There is nothing on the screen. I closed Excel (using 2003 version) and restarted computer also. I tried to open the file again - nothing shows up on the screen. When I attempt to open the file again I get a message that says "(file name).xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen (file name).xls?". Even if I reopen the file, it still does not show up on the screen. Can anyone tell me what has happened to my file that I was using yesterday? And how can I remedy this issue?

Thanks so much in advance,
DCoates

Recently excel starting opening a blank workbook when I open an existing one.
How do I make this go away? Thanks.

When I open an existing workbook there are no worksheets showing. There is
only a gray screen.
If I open the Excel Application first, then open an existing workbook
through File > Open, then I can see the pages.

When I open an existing workbook there are no worksheets showing. There is
only a gray screen.
If I open the Excel Application first, then open an existing workbook
through File > Open, then I can see the pages.

Hi,

I am trying to find a way of opening another workbook when the user selects add or update or find data. As each user potentially has a different drive letter for the same location it is proving difficult. I have looked a various answers on this site and I'll be honest I am not sure how to fully implement them in my coding.

an example of my code is below. Any help is most appreciated

An example of the location to save would be

G:CommsMaster1.xls and another users could be X:CommsMaster.xls and so on...


	VB:
	
 test_Click() 
     
    Dim iRowfnd As Long 
    Dim ws As Worksheet 
    Set ws = Worksheets("Master") 
    Dim sFindIt2 As String 
    Dim sfindit3 As String 
    Dim sfindit4 As String 
    Dim i As Integer 
    Dim r As Range, ff As String 
     
     
    sFindIt2 = txtdate.Value 
    sfindit3 = listwma.Value 
    sfindit4 = listasa.Value 
    If sFindIt2 = "False" Or sFindIt2 = vbNullString Then Exit Sub 
    iRowfnd = 0 
    lRowFnd = 0 
    With Worksheets("Master") 
        Set r = .Columns(1).Find(What:=sFindIt2, After:=.Cells(1, 1), LookIn:=xlValues, _ 
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, _ 
        SearchFormat:=False) 
        If Not r Is Nothing Then 
            ff = r.Address 
            Do 
                If r(1, 2).Value = sfindit3 And r(1, 4) = sfindit4 Then 
                    Me.txtnumber1 = r(1, 7) 
                    Me.txtnumber2 = r(1, 8) 
                    Me.txtnumber3 = r(2, 7) 
                    lRowFnd = r.Row 
                    Exit Do 
                End If 
                Set r = .Columns(1).FindNext(r) 
            Loop Until ff = r.Address 
        End If 
        If lRowFnd = 0 Then 
            MsgBox "Not Found" 
            For i = 1 To 40 
                Me.Controls("txtnumber" & i).Value = "0" 
            Next 
        End If 
    End With 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Many thanks

I believe a setting/s has been changed in my computer. I used to be able to
open an existing/saved excel document and all the information would be there.
Now I open an existing document and all I get is a blank excel spreadsheet.
How do I revert to the old settings so that when I open a saved document, the
spreadsheet opens with all the previously saved information?
--
Thanks for your help

Personal.xls is in the right path and opens, hidden, when I start with a new
workbook. However, when I open an existing workbook, I have to manually open
personal.xls. This problem started earlier this week and the workbooks I'm
using were created last year.

When I attempted to open an Excel Workbook that I had worked on earlier in
the day all that remained was a BLANK workbook. I have no idea what happened
to it but I would like it back. I attempted the procedured in Recover Files
with no luck. Is there a way to get this workbook back? I do have a backup
that is from the end of the month and can recreate the workbook if necessary.

How to avoid opening an empty workbook every time I open an existing EXCEL
file?

Word and Excel 2007 Hang for 15-45 minutes when open an existing document.

Hi
One of the computers on my network has started stalling when opening an existing document. If I open word/excel normally and go file open and select a document it opens perfectly, but if I double click on a document when office is closed it hangs. I must then end the explorer process before I can do anything on the machine. I've done a repair install and loaded the latest service pack for windows and office. The computer is running windows XP with office 2007 SBE.

I have a user who is trying to use <EDIT><MOVE OR COPY SHEET> to copy a sheet to an existing workbook. She has them in the same directory and has them both open, but when she tries to copy a sheet from either of them to the other, the only workbook listed in the "TO BOOK" drop down menu is the one she is in. NO other workbooks show up as an option for her to copy to. If you have any suggestions on why this would happen, please let me know. Thanks!

Hey guys, thx in advance for any knowledge you share. And sorry in advance if I confuse anyone with my ramblings. Here is what I am trying to accomplish. I have an excel report that is saved to a file share once a day via SSRS (lets call it Report.xls). This file is overwritten each time the report runs so any macro's that are contained in that spreadsheet will be overwritten. This spreadsheet has numerous tabs that I run a macro against to rename each sheet according to a specific cell. I then run another macro that saves off each sheet as it's on workbook and then a VBS file e-mails each new workbook to individuals. My problem lies in the fact that I cannot save these macros in the work sheet Report.xls because it will be overwritten. So Ideally I would have a VBS file (I do but it doesn't work) that opens Report.xls and runs the 2 macros from the Personal Workbook but for some reason when the vbs file opens Report.xls, my personal workbook macros do not show up. If I open Report.xls manually they show up and can run the macros no problem. Does anyone know how to get them to show up when opening an excel file via a vbs file?? If not then my alternative is to create a macro in a blank excel file (lets call it "Template.xls") that I save the macros in. I would then need a macro that does the following:

Copies data into a BLANK excel document (The blank doc IS Template.xls) and then saves off as a new document. Where I'm having trouble is writing a macro that opens an existing workbook and copies all sheets and all data OUT of it and into the BLANK excel workbook.

I would rather just fix the issue with the Personal Macro Workbook not showing up when I fire off my vbs but will take the alternative listed above. I've found plenty of macros to copy data OUT of a workbook with data and into a new blank one but none for copying data INTO a blank document from another document with data. Can anyone help me with either solution?? Thanks guys!!

I need to add a page to an existing workbook.

I have an Excel workbook that I want to edit. -------> PAS for Modification.xlsm The workbook is used for looking at real estate and conducting some financial analysis. I have received help creating the macros and added some on my own. I need to make adjustments to it. Here is what I am trying to do:

1) Delete columns F, S, W, AB, AD, and AF. When I delete it the VBA codes break.

2) I want to remove the restrictions when entering a new property. I would click on Tool Box and in Userform 1 I am required to enter certain variables consistent with the code. I want them all removed because when I add properties I may not have all the information (Say: MLS #) which does absolutely nothing to affect the financial calculations.

3) On the add new property tab of userform 1 (opened by clicking "Toolbox" button) I want there to be options for selecting either Single Family, Duplex, Triplex, Quadplex, or Apartment Complex respectively which ever I click should highlight the row it paste to the color matching the blocks at top of spreadsheet. The code copies the last line and then inserts the new info if I remember correctly.

4) I have another sheet that I am going to attempt to have it linked to this sheet. Once the first three can be accomplished I can send the other sheet. I may just combine the two sheets because the idea is to have the "Add New Property" data from userform 1 to auto populate in the other sheets which will draw a pro forma for that property. For the new sheets that I will get help with after this, once the macro populates the pro forma I want the "Pro Forma" sheet to move to a new workbook and save it to specific folder using the property address as the workbook name.

Any help with this would be greatly appreciated. I am looking forward to seeing those gurus out there crank something incredible out... I am jealous of your abilities and hope to take VBA classes when I get back from Afghanistan. Thanks guys!

Need your help from you experts.
Please give me suggestion how to fix the problem with my excel file.
I'm not able to add or remove worksheet from my existing excel
workbook. When I right click on the tabs, it gives only two options:
"Select All Sheets" and "View Code", other choices are grayed out. The
file has about 17 tabs, but I could remove or add worksheet to it
before. I did save it with a password to open it and running the macro
RowLine.xla, but I now can't add or remove sheet, so I remove the
password and the macro, and I still can't add or remove sheet.
Is there a way to check if there're still macros in the file, and want
to remove them all. Thank you much

--
beginer1
------------------------------------------------------------------------
beginer1's Profile: http://www.excelforum.com/member.php...o&userid=30810
View this thread: http://www.excelforum.com/showthread...hreadid=504723

I would like to insert a blank worksheet between two exisring worksheets in a
workbook. How is this accomplished?

Hello Everyone,

I have a Sub in an add-in which when called (via a keyboard shortcut
CTRL+SHIFT+G) opens an existing workbook, gets some data out of it and
puts that data on the sheet. The function is driven by data in the
comment of the Activecell. Now it works when I step through it, it
works when I run through it (ie hit F5), (presuming in both cases the
activecell is the correct one) but it will not execute properly in
response to the keyboard shortcut. It stops after opening the existing
workbook. Here is the offending code:

For k = 1 To UBound(s, 1)
Set wbk = Application.Workbooks.Open(fileName:=s(k), AddtoMru:=False,
IgnoreReadOnlyRecommended:=True)
If (wbk Is Nothing) Then Err.Raise vbError + 2001, FUNCTION_NAME,
"Unable to open correlation source."
i = j
With wbk
..IsAddin = True
While (vToGet(i, 3) = s(k))
vToGet(i, 6) = wbk.Sheets("grid").Range(oMyTx.getAsXLColumn(vToGet(i,
5) + 2) & CStr(vToGet(i, 4))).Value
i = i + 1
Wend
subscriptStart:
j = i - 1
End With
wbk.Close SaveChanges:=False
Set wbk = Nothing
Next k

wbk is declared: Dim wbk as Workbook

I don't know if a reference to wbk is ever set, it seems like it isn't
but I can't tell why. When execution stops, the workbook (ie s(k) in
the above code) is open and active and when I press ALT + F11 to go
into the debugger it is sometimes in design mode and sometimes not.

Can anyone shed any light on this problem.

Thanks everyone,

chilli

Need your help from you experts.
Please give me suggestion how to fix the problem with my excel file. I'm not able to add or remove worksheet from my existing excel workbook. When I right click on the tabs, it gives only two options: "Select All Sheets" and "View Code", other choices are grayed out. The file has about 17 tabs, but I could remove or add worksheet to it before. I did save it with a password to open it and running the macro RowLine.xla, but I now can't add or remove sheet, so I remove the password and the macro, and I still can't add or remove sheet.
Is there a way to check if there're still macros in the file, and want to remove them all. Thank you much

Hi,

im new to vb6, and i have a problem on how to retrieve a particular column from an existing excel file and append that as another column to another existing workbook...

also, what about if you want to store the data on that column to appear every other row...

for example:

original column
hello
hi
there
how's
life

transferred column
hello
<blank cell>
hi
<blank cell>
there
<blank cell>
how's
<blank cell>
life

need help...
thanks:D
thanks

Is there a way to copy a sheet in one Workbook to and Another Existing Workbook?

I have attachment two Workbooks to this thread.

The one entitled: Copy a Sheet to An Existing WorkbookI would like to copy any Sheet to Workbook "Create PowerPoint"I would like it to be the first sheet in the Workbook "Create PowerPoint"
The one entitle: Create PowerPointIt has three sheets that have data already in it

I have an existing excel document to which, when opened from file covers half
the main excel window. There is no minimize, maximize or close button a
standard window should have. I cannot double-click the title bar to maximize
the window.

If anyone knows what the problem is or likely to be, I'll definitely like to
hear from you.