[mso] Re: Excel Question
- From: Arul <a_arul15@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 1 May 2003 21:31:33 -0700 (PDT)
Yes, you can read a file from Excel macro. But you
can't copy and paste it. If you want to make a
particular selection you need to bookmark the file for
the begining and end of the selection. It basically
depends upon your macro program and ofcourse you may
define your own bookmarks.
For this you cannot record a macro. You have to write
a code for reading the file. Refer 'Input' Statement
documentation for read and write a file from Excel
visual basic editor. Start reading line by line
between your selection and write the value to the
excel cell. This is ofcourse you can use it for
relative cells or it can be selected.
Arul
--- "Colli, Anthony G" <Anthony.Colli@xxxxxxx> wrote:
> AJ-
>
> Yes and No, you can use an Excel Macro to import a
> text file, but you can't make it search a text file
> and import from a certain row. Basically it's all or
> nothing. I have been following this thread loosely
> and admittedly I don't remember the original
> question, but I did write a Macro that will import a
> text file of two tab spaced columns, then writes
> those two columns to rows in a workbook.
>
> If you want I'll send you the Macro code and the
> text file I used.
>
> -Anthony
>
>
> -----Original Message-----
> From: AJ Dalton [ mailto:a_j_dalton@xxxxxxxxxxx]
> Sent: Wednesday, April 30, 2003 12:32 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel Question
>
>
>
> RE: "Instead of writing macro for Copy and Paste,
> better you may write a
> macro to read the file and fill the contents in
> excel with your desired
> format..."
>
>
> Can a Macro open a (Notepad) file and select and
> copy/paste info into a
> Spreadsheet? I only thought that it did things
> withing Excel.
>
>
>
>
>
>
*************************************************************
> You are receiving this mail because you subscribed
> to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to
> mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx with the word
> "unsubscribe" (without the quotes) in the subject
> line.
>
> Or, visit the group's homepage and use the dropdown
> menu. This will also allow you to change your email
> settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing
> files with the group, send a request to
> mso-moderators@xxxxxxxxxxxxx and you will be sent an
> invitation with instructions. Once you are a member
> of the files group, you can go here to
> upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
*************************************************************
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
