Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download

Links

XODOX
Impressum

#1: Copy data from sheet to sheer in differant workbooks.

Posted on 2008-04-18 18:43:01 by Richard

OS: MS XP; Excel 2003
I need to copy and paste a sheet from one workbook to another. The sheets
already exist and I know how to do this with VBA. The file to be coppiced
from is on a thumb drive in a folder and the file the sheet is being copied
to is on my C: drive.
Questions:
1) Is it possible to copy from the source file without opening it?
2) Several files will be on the thumb drive each starting with a two
(2)-digit number. The rest of the file name will contain dates and other
information that makes them different. Is it possible to somehow use only
the 1st two (2) letters of the file name to open it, as within the folder it
is unique?

Thanks in Advance.

--
Richard

Report this message

#2: Re: Copy data from sheet to sheer in differant workbooks.

Posted on 2008-04-18 20:25:52 by Ronx

You may wish to ask this question in an Excel forum or newsgroup. This
group is for FrontPage.

--
Ron Symonds
MVP (FrontPage)
Reply only to group, emails will be deleted unread.


"Richard" <Richard@discussions.microsoft.com> wrote in message
news:FA65B7F6-610B-4529-8B2E-474D1327BFDD@microsoft.com...
> OS: MS XP; Excel 2003
> I need to copy and paste a sheet from one workbook to another. The
> sheets
> already exist and I know how to do this with VBA. The file to be
> coppiced
> from is on a thumb drive in a folder and the file the sheet is being
> copied
> to is on my C: drive.
> Questions:
> 1) Is it possible to copy from the source file without opening it?
> 2) Several files will be on the thumb drive each starting with a two
> (2)-digit number. The rest of the file name will contain dates and
> other
> information that makes them different. Is it possible to somehow use
> only
> the 1st two (2) letters of the file name to open it, as within the
> folder it
> is unique?
>
> Thanks in Advance.
>
> --
> Richard

Report this message