Open and display directory spreadsheets for user to select and edit
-
Hi Aidan I want to be able to display allspreadsheets in a particular directory for the user so they can open and edit any particular one. I've played around in VB6 using the drive, directory, and subfolder objects in the toolbox, but it all seems a bit long winded - I want it to simply default to the directory path and allow them to select which spreadsheet they want to edit.
-
Answer:
Perhaps I'm missing something here, but it sounds as though you simply need to set the Current Directory and then display the file open dialog box? Sub Get_Data() ChDrive "C:\" ChDir "C:\Testing\" FileToOpen = Application.GetOpenFilename _ (Title:="Please choose a file to import", _ FileFilter:="Excel Files *.xls (*.xls),") If FileToOpen = False Then MsgBox "No file specified.", vbExclamation, "Duh!!!" Exit Sub Else Workbooks.Open Filename:=FileToOpen End If End Sub >>So - my Google search gave the same result as the search at work - so there you have it - my other skill you see is using search engines!!!! would do it for you - amend as necessary!
Miningco.com Visit the source
Related Q & A:
- How can I make Private Messages in Drupal 7 with user user pictures like in Facebook?Best solution by Drupal Answers
- How to check on all the permissions granted to a user and apply the same permissions to another user?Best solution by Stack Overflow
- how to open a modal window on jqgrid edit?Best solution by Stack Overflow
- How do I permanently block a user forever? I mean, find or enter the username, when the user isnt on my list?Best solution by Yahoo! Answers
- How to make the first page of a PDF display by itself and the succeeding pages display two-up?Best solution by Super User
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.