Solved

Code to get folder name crashes 64-bit Excel 2013 in Windows 8.1

Posted on 2014-11-28
3
349 Views
Last Modified: 2014-11-28
The basic code in the attached file has worked perfectly for years to return a selected folder name. However, it crashes the 64-bit version of Excel 2013 in Windows 8.1.  Any ideas on how to resolve?
GetFolder-test.xls
0
Comment
Question by:bishop3000
[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
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
Nick67 earned 500 total points
ID: 40471096
I'll go sideways.
That sure is a passel of API code to do stuff you don't need API for.
Have a look at the button and code in the returned sample
Why use API when you've got VBA objects to do the job?
GetFolder-test.xls
0
 

Author Closing Comment

by:bishop3000
ID: 40471101
Works great, thank you!
0
 
LVL 26

Expert Comment

by:Nick67
ID: 40471104
The file dialog has a .InitialFileName property
You can aim the dialog to open in a specific spot if so desired.
It will open to 'My Documents' if no default is specified.

Nick67
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
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…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

726 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