#1
|
|||
|
|||
Why did this Open File command work?!
I have recently developed a module for a client which begins by opening a file containing lookup data in order to cycle through staff members stored in a list. I tested it thoroughly before sending it out, obviously, and we are both using Office 2010. When my client ran the code, however, he got an error message saying that this file "... could not be found. Check the spelling of the file name, and verify that the location is correct.
"My code contained this line: Code:
Workbooks.Open (strPath & "\XYZ Lookups") My question, though, is WHY DID IT EVER WORK ON MY MACHINE?!!! |
#2
|
||||
|
||||
First guess (and it's only a guess): Perhaps you and your client have different default settings for the type of document to be opened? For example, maybe his was looking for <filename>.xls and yours for <filename>.xlsx?
|
#3
|
|||
|
|||
Thanks for the suggestion - sounds plausible. Maybe my machine is looking for .xlsx and his for the old .xls!
|
Tags |
error message, extension, filename |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel cannot open the file .xlsx because the file format or file extension is not val | teddysika | Excel | 1 | 11-22-2012 06:06 AM |
Command Button will not work when document is protected | brockjensen | Word | 1 | 11-02-2012 06:59 PM |
Command Button doesnt work on network | rmw85 | Word VBA | 1 | 04-25-2012 01:02 PM |
Open an attached email and sent does not work | M_O_C | Outlook | 0 | 07-27-2011 09:36 AM |
Text created in Work 2010- will not open in Word 2007 | Ole Sarge | Word | 1 | 05-27-2011 03:06 PM |