\r\n\r\n
Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Word, PowerPoint, Outlook, and Other Office Products > Opening Excel document in Word without the popup screen


\r\n \r\n
 
 
Thread Tools Display Modes

\r\n\r\n\r\n
Hi there,
\r\n
\r\nFirst post here so I just want to say "hi !" to everyone..
\r\n
\r\nOk, here\'s my question now : I want to know how to open a XLS file IN Word(i don\'t want to start Excel from Word...) WITHOUT having that **** popup screen (if the image doesn\'t show, see attchment plz..).
\r\n
\r\nBecause my macro needs to take all the XLS files in one folder and save them in RTF and it\'s really annoying having to click on "OK" for every files..
\r\n
\r\nAlso a quick second question : How can I choose a folder so the macro will search in every subfolders of that folder ?
\r\n
\r\nThank you very much !
\r\n
\r\n:\\Curious George>
\r\n \r\n\r\n
\r\n \r\n \r\n
\r\n\r\n \r\n\r\n \r\n\r\n \r\n
\r\n Attached Images\r\n \r\n \r\n \r\n \r\n\r\n
File Type: jpgexcelpopup.jpg (27.1 KB, 20 views)
\r\n
\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n
\r\n \r\n \r\n \r\n \r\n Reply With Quote\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n \r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n\r\n\r\n\r\n'; pd[72117] = '\r\n\r\n \r\n\r\n
\r\n
\r\n
\r\n\r\n
\r\n \r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n \r\n
\r\n
\r\n  \r\n #2  \r\n \r\n \r\n \r\n \r\n \r\n
\r\n\r\n
\r\n \r\n Old\r\n \r\n 01-10-2002, 10:54 AM\r\n \r\n \r\n \r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
KesleyK\'s Avatar\r\n\r\n
\r\n \r\n KesleyK\r\n KesleyK is offline\r\n\r\n\r\n
Prev Previous Post   Next Post Next
  #1  
Old 01-07-2002, 11:24 AM
Curious George
Guest
 
Posts: n/a
Post Opening Excel document in Word without the popup screen


Hi there,

First post here so I just want to say "hi !" to everyone..

Ok, here's my question now : I want to know how to open a XLS file IN Word(i don't want to start Excel from Word...) WITHOUT having that **** popup screen (if the image doesn't show, see attchment plz..).

Because my macro needs to take all the XLS files in one folder and save them in RTF and it's really annoying having to click on "OK" for every files..

Also a quick second question : How can I choose a folder so the macro will search in every subfolders of that folder ?

Thank you very much !

:\Curious George>
Attached Images
File Type: jpg excelpopup.jpg (27.1 KB, 20 views)
Reply With Quote
 


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->