View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default visual basic Mid() does not work with swedish version of excel

already suggested and ignored. However, this is a bandaid at best.

--
Regards,
Tom Ogilvy

"Chay" wrote in message
...
Try using

vba.mid(blah, n00b, etc.



"LindhJonas" wrote in message
...
I am using the function Result = Mid(Mystring, Start, lenght) in Visual
Basic.
It is working perfect with an english version of Excel.
The swedish version gives compile error "Cant find the project or
library"
Visual Basic is not avialable in a swedish version .

Is it possible that this function can only be used in english speeking
countries?
Anyone else with this experience or a solution to the problem.

There is no problem if I use Mid as a spread sheet function.
Using Result = Application.WorksheetFunction.Mid(Mystring, Start,
lenght)
in Visual Basic does not help.

Unhappy Swede
Jonas