ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Find File and Open (https://www.excelbanter.com/excel-programming/271322-find-file-open.html)

Pedro[_4_]

Find File and Open
 
Hi
What code shoul I write in order for it to search a pre-
defined filename and open that searched file?

Regards
Pedro

Tom Ogilvy

Find File and Open
 
do you mean search for the file and open it?

Look at the vba help on the filesearch object.

Regards,
Tom Ogilvy


"Pedro" wrote in message
...
Hi
What code shoul I write in order for it to search a pre-
defined filename and open that searched file?

Regards
Pedro




Pedro Marques

Find File and Open
 

Hi Tom
I already saw the filesearch object help but they do not mention how to
open the searched file



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Don Guillett[_4_]

Find File and Open
 
where it says
MsgBox .FoundFiles(i)
modify to suit
FoundFiles(i).open


--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Pedro Marques" wrote in message
...

Hi Tom
I already saw the filesearch object help but they do not mention how to
open the searched file



*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




Pedro[_4_]

Find File and Open
 
Hi Tom
The Help only explains how to search
that I already done. Know how do I open that searched
file?

Thanks
Pedro
-----Original Message-----
do you mean search for the file and open it?

Look at the vba help on the filesearch object.

Regards,
Tom Ogilvy


"Pedro" wrote in message
...
Hi
What code shoul I write in order for it to search a

pre-
defined filename and open that searched file?

Regards
Pedro



.



All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com