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.


bkesting wrote:
>
> 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.

--

Dave Peterson
(E-Mail Removed)

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


"bkesting" <(E-Mail Removed)> wrote in message
news:044001c37188$f7d18420$(E-Mail Removed)...
> 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.

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


"bkesting" <(E-Mail Removed)> wrote in message
news:04b301c3724c$717c0520$(E-Mail Removed)...
> I think I have solved my problem with the viewing issue.
>
> As far as the second issue. I am using a template now.
> Here is my situation. I have some employees that are
> working at a power plant, and when they generate
> electricity on any given day, they open this blank
> template file and fill in their information and save it
> with a unique name (usually the date). When they generate
> again, they open up the blank template again and so on and
> so forth. There are some totals however that need to be
> carried over from the previous generation day to the
> current one if that is possible. Right now, the workers
> just open the old file, get the info they need and then
> copy down the numbers they need for the new file. Anyway
> to get data from the old file to export to a different
> location where the new file would look as soon as it
> starts for that information?
>
> I hope I am not too confusing.
>