Need help getting data from an excel file
Don't expect to find clean lines in newsgroup posts. You need the filename all on one line.
Yes, my typo on the second line.
--
Sue Mosher, Outlook MVP
Outlook and Exchange Solutions
at http://www.slipstick.com
Quote:
> Sue
> I tried to copy and paste your line below into Outlook macro editor and it
> turns the first line red indicating a syntax error. I can't see anything
> that is wrong with it - can you? Also, I didn't see an = mark on the 2nd
> line - Is one needed?
> thanks
> George
> You need to return an object you can work with:
> Set objWB = Application.Excel.Workbooks.Open "f:\mailing
> list\lists\testlist.XLS"
> mail_name objWB.Worksheets(1).Range("C1")
> --
> Sue Mosher, Outlook MVP
> Outlook and Exchange Solutions
> at http://www.slipstick.com
> > Actually this is the command I want to work from within an Outlook module
> > Application.Excel.Workbooks.Open "f:\mailing list\lists\testlist.XLS"
> > mail_name = Range("C1")
> > Obviously, I wouldn't be posting this message if it worked like this. So,
> > knowing that this is what I want, can anyone help me get it to work?
> > Thanks
> > George Mizzell
