Windows.Activate Filename case sensitivity

  • Thread starter Thread starter E Edgington
  • Start date Start date
E

E Edgington

Can I add code to the following to make the filename not
case sensitive:

Windows("daily activity.xls").Activate

I have users that are naming their file DAILY
ACTIVITY.xls, etc. and the macro is failing because of it.
 
E

Case should not affect that statement. It doesn't on mine (XL2000). What
version are you using? Are you sure the spelling is the same?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem opening a file 4
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Excel Range name case sensitivity in VBA code 2
Oversensitive touchpad on modern laptops 0
How to activate a file when the filename is represented by a string variable 4
Case Sensitive SumProduct 3
Best Tool to Repair Corrupted PDF Files 0
How can macro open daily generated files? 5

Back
Top