Solved

File Open Office.FileDialog not working

Posted on 2009-05-18
3
1,328 Views
Last Modified: 2012-05-07
The attached code was working fine until I added in some new references
They are attached
I thought I needed Office 11 Refs but as I'm using Office 2007 which is 12 I wonder what ref / change I need to make

I know I can rewrite using the more cumbersome methods but this code was very nice

Thanks in advance

Paul
Private Sub Command18_Click()
   Dim fDialog As Office.FileDialog
   
   Dim varFile As Variant
 
   ' Clear listbox contents.
   Me.TXTFileName = ""
 
   ' Set up the File Dialog.
   Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
 
   With fDialog
 
      ' Allow user to make multiple selections in dialog box
      .AllowMultiSelect = False
            
      ' Set the title of the dialog box.
      .Title = "Please select the file you wish to import"
 
      ' Clear out the current filters, and add our own.
      .Filters.Clear
      .Filters.Add "Excel Files", "*.XLS"
      .Filters.Add "All Files", "*.*"
 
      ' Show the dialog box. If the .Show method returns True, the
      ' user picked at least one file. If the .Show method returns
      ' False, the user clicked Cancel.
      If .Show = True Then
 
         'Loop through each file selected and add it to our list box.
         For Each varFile In .SelectedItems
            Me.TXTFileName = varFile
         Next
      Else
         MsgBox "You clicked Cancel in the file dialog box."
      End If
   End With
End Sub

Open in new window

refs.jpg
0
Comment
Question by:Wizard_IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 250 total points
ID: 24411401
So what is the exact problem when u say it doesnt work?
that code looks fine to me

add

option explicit

on the top of your code module

then do a Debug/Compile to check of anything is wrong with that code in your environment
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
ID: 24411449
I believe this has changed in Office2007.
I think you now do :
Application.FileDialog   (literally 'Application', not the name of the application)
rather than
Office.FileDialog

I don't think you need the Office12 reference (unless you need it for other things)
0
 

Accepted Solution

by:
Wizard_IT earned 0 total points
ID: 24411529
Guys
Sorry - The application wouldn't Compile

It was conincidental that I had added additional references in

used the /decompile on the command line and the application then works

0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question