LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default GetOpenFilename code execution interrupted

This code has been running for three years. All of a sudden I get "Code
execution has been interrupted" in the next line after
Application.GetOpenFilename. No matter what the user chooses (a file or
cancel). Is there a way to stop that without disabling the cancel
selection?
Thanks

John




ChDir "C:\Documents and Settings\Administrator\Desktop\Billing\State"
StateBilledFile = Application.GetOpenFilename("Excel Files,_
*.xls),Title:=,Open a Nancy + date.xls file")

' Test if Cancel button was clicked.
Select Case StateBilledFile
Case Is < False
Workbooks.Open (StateBilledFile)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Execution Has Been Interrupted Carroll[_3_] Excel Programming 3 December 5th 07 02:05 PM
Code execution has been interrupted Stuart C Excel Programming 3 March 23rd 06 09:02 AM
Code execution has been interrupted Craig Excel Programming 1 January 25th 06 07:19 AM
Code Execution has been Interrupted JPutman Excel Programming 4 August 24th 04 02:17 PM


All times are GMT +1. The time now is 04:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"