Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help on Excel controls
Hi, how or where can I go to get help on the use of the
various controls that I have access to in the "More Controls" option of my VB toolbox? In particular, I want to employ a dialog box allowing the user to choose a file to process. It's been awhile since I've done this outside of Excel in "regular" VB and I don't remember the code to make the dialog box appear and reference a default location, etc, etc. Thanks much, Reney Langlois |
#2
|
|||
|
|||
Hi Reney
Be very careful with "more controls", they must be installed and licensed to run in design time on each computer using your file. For this use a built-in control-less method: Sub test() Dim F As Variant F = Application.GetOpenFilename If F = False Then Exit Sub 'Cancelled MsgBox CStr(F) End Sub See Help on GetOpenFilename for variables (like filtering certain filetypes only) HTH. Best wishes Harald "Reney Langlois" skrev i melding ... Hi, how or where can I go to get help on the use of the various controls that I have access to in the "More Controls" option of my VB toolbox? In particular, I want to employ a dialog box allowing the user to choose a file to process. It's been awhile since I've done this outside of Excel in "regular" VB and I don't remember the code to make the dialog box appear and reference a default location, etc, etc. Thanks much, Reney Langlois |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
html to excel | Excel Discussion (Misc queries) | |||
Problem Opening An Excel file. - by yk | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) |