Solved

File Open Office.FileDialog not working

Posted on 2009-05-18
3
1,318 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

837 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