A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Check File Name With Conditional Statement



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2009, 03:04 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default Check File Name With Conditional Statement

I have a file that certain users will open, rename, and use for testing
purposes. It contains a macro that I only want to run if the file is the
original version. I tried adding an if statment to the macro checking the
filename and only running the macro if the filename is the original. For the
original file the code works fine but if a file with a different name tries
to run the macro Excel shuts down everytime. I tried using the
ActiveWorkbook.Name and ActiveWorkbbok.FullName properties but both return
the same results. Any ideas?

Thanks

Adam Bush
  #2  
Old April 15th, 2009, 03:39 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default Check File Name With Conditional Statement

Never mind I figured it out.

" wrote:

I have a file that certain users will open, rename, and use for testing
purposes. It contains a macro that I only want to run if the file is the
original version. I tried adding an if statment to the macro checking the
filename and only running the macro if the filename is the original. For the
original file the code works fine but if a file with a different name tries
to run the macro Excel shuts down everytime. I tried using the
ActiveWorkbook.Name and ActiveWorkbbok.FullName properties but both return
the same results. Any ideas?

Thanks

Adam Bush

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.