Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using VBA to locate a directory

Status
Not open for further replies.
GeorgeDurkee

GeorgeDurkee

Programmer
Feb 22, 2000
47
US
I need to be LINK to a given worksheet in a given workbook of an Excel spreadsheet. >:):O>

I can do this in VBA if I know the name of the worksheet and the name of the spreadsheet and the directory it is contained in. However, I don't know any of these things or it may change every time I want to use the data. X-)

How can I use a directory tree structure to find the .XLS file, open it, list all of the worksheets in the workbook, have the user select the one they want, then attach to the selected worksheet? :-0

VB has some ActiveX controls that allow this very easiy. I can't seem to find a corresponding control for Access 97 or VBA. *<|:)

Thanks

George
 
Sort by date Sort by votes
The activeX controls you use in VB are not &quot;VB Controls&quot;, activeX controls can be used by any activex container enviornment. Excel is an activeX container, as are VB, Internet Explorer etc.. The point is you can use those same controls in excel. Make sure the 'Control Toolbox' toolbar is visible and click on the button that has a hammer and wrench (in the shape of an X) this will give you a list of the activex controls that are registered. Pick the control you want from the list and draw it on the worksheet. All the controls listed in VB should be listed here. If not theres an option at the bottom of the list to 'Register Custom Control' You can use this to add .dll's or .ocx's to the list. Just remember, like visual basic programs a workbook that uses activex controls needs to have the .ocx file registered on any system you want to use the workbook on. Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
704
combo
combo
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
648
Andrzejek
Andrzejek
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
418
aldi07
aldi07
xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
517
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top