 |  |  |  |  |  |  |  |
Excel 2003 VB code needs to run in Excel 2000
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Hi
This VB code below runs fine in Excel 2003 under an object in a form and the file browser window opens nicely, allowing the navigation to and selection of a file. However, I need to have the same functionality running in an Excel 2000 environment. The problem is that this version of Excel does not recognize the 'msoFileDialogOpen' argument.
The user cannot at this stage move to 2003.
Please let me have some ide how to achieve the same look and function in the Excel 2000 environment. Your help is really appreciated. AndrewE
'------------------------------------------------------
' Open the file dialog to select a file
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
FirstFileName = .SelectedItems(1)
Workbooks.Open (.SelectedItems(1))
End With
This VB code below runs fine in Excel 2003 under an object in a form and the file browser window opens nicely, allowing the navigation to and selection of a file. However, I need to have the same functionality running in an Excel 2000 environment. The problem is that this version of Excel does not recognize the 'msoFileDialogOpen' argument.
The user cannot at this stage move to 2003.
Please let me have some ide how to achieve the same look and function in the Excel 2000 environment. Your help is really appreciated. AndrewE
'------------------------------------------------------
' Open the file dialog to select a file
With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
FirstFileName = .SelectedItems(1)
Workbooks.Open (.SelectedItems(1))
End With
|
Similar Threads
- Hate to ask but am wits end--HJT Log included (Viruses, Spyware and other Nasties)
- I seem to have a bunch of infections...arghhh (Viruses, Spyware and other Nasties)
- Excel Add-In RegisterXLL (Python)
- Cant stop pop ups, computer lagging (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: BOOKS
- Next Thread: conversion of exe
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
