2 Excel questions

  • Thread starter Thread starter bkesting
  • Start date Start date
B

bkesting

Hello,

I have two questions regarding Excel. First, how can I
setup Excel (or Office in this matter) so that when I have
a file open and choose to open another file, it opens the
second file in a new window instead of wiping the first
file off the screen and reaplacing it with the second.

Secondly, I have an Excel file that calcuates some running
totals on a daily log sheet. Each day is a new log sheet
that requires some numbers from the previous day. Is
there a way to export data from an excel sheet into some
sort of location that when a new sheet is started, the
current information can be imported from that location?

I hope that all makes sense to you guys.

Thanks for your time.
 
#1. If you're using xl2k or higher, you can use:
Tools|Options|View and check Windows in taskbar

But if your worksheet is full screen in excel, you'll still have to click on the
old icon on the toolbar. If it's less than full screen, you might be able to
click on a visible portion of that old window.

But you can also use ctrl-Tab and ctrl-shift-Tab (or even ctrl-F6 and
ctrl-Shift-F6) to cycle through excel windows.


#2. Not sure if I understand, but maybe you could just copy the existing range
to a nice out of the way spot (a different worksheet???), do your stuff and copy
it back.
 
A1 - I think what you're asking is that new files be opened minimized
(though I can only think of very isolated scenarios when one might want
that). The only way I can think of to do that is with the Application
WorkbookOpen event but that's a bit of sledgehammer to crack a nut. Also,
providing you've got tools, options, view, 'windows in task bar' set, you
can just click on your original file on the task bar to reactivate it.

A2 - You need a worksheet template. Without knowing exactly what you want
to do, I cannot offer anything more.

HTH

Marc
 
Too busy to write code for you right now but I suggest using the
Workbook_Open event in your template to do the following:
- Search the directory (assuming all files are saved in the same directory)
for the last modified workbook (you'll need to enable 'Scripting Runtime' in
Tools, References so that you can create a FileSystem object to do this)
- Open it
- Read the data you want
- Insert data into new workbook
- Close the old workbook

Let me know how you get on. If you need help with the code I'll see if I
can find time at the weekend.

Good Luck.

Marc
 
Back
Top