LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default selecting workbook/worksheet from browse button

HI..

1.Is it possible to select a workbook by a browse button which we normally
see on windows ...and trap its name in a variable for processing?

2. is it possible to select a worksheet.... using a browse button and then
trap its name ?

the basic idea is to minimize hard coding of the workbook/worksheets path
....and also sometimes it happens that the path changes...then the user will
have to edit the code.

thanks a lot
Monika


 
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
Pls add browse button for Hyperlink function Katharine Hu Excel Worksheet Functions 0 July 17th 06 07:13 AM
Browse button on form for folder path Greshter Excel Discussion (Misc queries) 2 January 12th 06 10:20 PM
macro to browse for workbook, pick up data and looping uriel78 Excel Worksheet Functions 1 March 10th 05 12:37 PM
Browse Button for File Save Todd Huttenstine[_2_] Excel Programming 4 December 22nd 03 03:28 AM
Adding browse button to userform Brad[_11_] Excel Programming 1 December 1st 03 04:04 PM


All times are GMT +1. The time now is 09:34 AM.

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"