0
   

Excel vba

 
 
Reply Fri 26 Oct, 2012 12:43 pm
i have some coding in excel vba
But one code works on all other computers except one
Same operating system,same version of excel, same setup in excel options
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 882 • Replies: 3
No top replies

 
jespah
 
  1  
Reply Fri 26 Oct, 2012 12:54 pm
@Jean-Guy,
Without more info it's really impossible to figure out what the issue is. It could be everything from permissions on the computer itself to folder permissions to other software loaded, etc. And that isn't even getting into VBA itself.
Jean-Guy
 
  1  
Reply Fri 26 Oct, 2012 02:27 pm
@jespah,
ok here goes I have this code to open a workbook
newfn = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls*),*.xls*", Title:="Please select a file")
The user when he clicks on a button in his open sheet (Invoice)
When he clicks on it it opens the directory where all the quotations are and he clicks on the one he wants the invoice to be filled automaticly .
this works great so far but this code stops giving error ...OPEN OBJECT WORKBOOK HAS FAILED ERROR 1004
the code line shows Workbooks.Open Filename:=newfn

All permissions are there nothing hidden (files)
And what is really weird this thing works on all other computers except one.
jespah
 
  1  
Reply Fri 26 Oct, 2012 04:22 pm
@Jean-Guy,
How wacky. I'm out of my depth so I really can't help much. But I am thinking it's the computer and not the code.
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Excel vba
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/26/2024 at 12:28:26