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!

*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.

Jobs

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!


Resources


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