Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF

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