LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,646
Default how do I open other workbooks in excel using wildcards

Have a look at GetOpenFilename in VBA Help!
Regards,
Stefi

Kiwijohn007 ezt *rta:

I am trying to open other workbooks that have a date and time stamp applied
to the file name but they also contain a common word as well. In this
instance Queue. What I would like to know is can some code be writen in excel
vba that ignores the first part of the file name and focus's on the Queue
word and opens the file?

 
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 to close all open workbooks in Excel 2007 Alojz Setting up and Configuration of Excel 0 September 17th 09 11:04 PM
Open many workbooks in Excel & print one page Darla Excel Discussion (Misc queries) 5 May 23rd 06 07:14 PM
When I open Excel, workbooks open automatically. How can I stop t Rhealbird Excel Discussion (Misc queries) 2 February 23rd 06 10:08 AM
Keeping 2 Excel workbooks open at the same time Royal Excel Discussion (Misc queries) 2 April 18th 05 10:10 PM
Excel does not display workbooks open PeiMei Setting up and Configuration of Excel 0 December 9th 04 04:13 PM


All times are GMT +1. The time now is 11:22 PM.

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

About Us

"It's about Microsoft Excel"