Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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!
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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!



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find & open an archived file in ms excel? DD Excel Discussion (Misc queries) 0 March 7th 09 07:58 PM
How to find file-path of open workbook? Larryq22 Excel Discussion (Misc queries) 7 January 24th 08 03:38 AM
EXCEL wont open from Explorer, must open EXCEL then find file wludwick Excel Discussion (Misc queries) 4 September 7th 06 08:06 PM
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? nwtrader8 Excel Discussion (Misc queries) 5 June 21st 05 02:16 PM
How to find something in another file, witch is not open HELP ME!! Andrzej New Users to Excel 8 May 29th 05 07:06 AM


All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"