×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VBA Broken under Windows 10?

VBA Broken under Windows 10?

VBA Broken under Windows 10?

(OP)
Just starting to get my feet wet with Windows 10. One VBA routing I have been using since XP includes the line:

CODE

PathFile = Application.GetOpenFilename("AcSELerator Export Files (*.txt), *.txt") 
That has always produced a file open dialog box and returned a string with the path and file name of the selected file. Trying this evening for the first time under windows 10 (64 bit, everything previously has been 32 bit, if that matters), and execution halts after I select a file name in the dialog box.

Anybody have any ideas why code that never caused problems under XP and 7 now fails, without warning or error, under 10?

RE: VBA Broken under Windows 10?

What program are you trying to run this line of code in?

-handleman, CSWP (The new, easy test)

RE: VBA Broken under Windows 10?

I'ma guess Excel. I'm running 64 bit Excel 2016 on Win10 pro 64 bit. That line of code works just fine for me, returns the selected file path.

-handleman, CSWP (The new, easy test)

RE: VBA Broken under Windows 10?

(OP)
Excel 2010. I have similar code in a different VBA program that works just fine on the same machine. Puzzling.

RE: VBA Broken under Windows 10?

(OP)
Never mind; bad debugging. The routine was correctly getting the pathfile name and then not finding a route through a select case structure. Oops. blush

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

White Paper - The Evolving Landscape of Commercial Battery-Powered Trucks
What’s driving the evolving landscape of truck electrification? What are the barriers, motivators and strategies for accelerating the electric transition? What insights and resources are available for today’s design engineers working to achieve industry disruption and evolution? For answers to these and other pertinent questions, read this white paper. Download Now
eBook - Rethink Your PLM
A lot has changed since the 90s. You don't surf the Web using dial-up anymore, so why are you still using a legacy PLM solution that's blocking your ability to innovate? To develop and launch products today, you need a flexible, cloud-based PLM, not a solution that's stuck in the past. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close