Using the String$ function

[Stretchwickster]

I'm using the following portion of code which works fine on my Win2k Excel2k machine. However, when I take it to another Win2k Excel2k machine I get an "Can't find project or library" error message and it highlights the String$ function line:

  Dim MyPath As String

  MyPath = String$(255, vbNullChar)

Does anyone have any ideas on what is going wrong and how to solve it?

I assume it has something to do with a missing reference perhaps?

Your help would be much appreciated!


Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)

 

[Bowers74]

Hi Clive,

This used to happen to me a lot. The first thing you need to do is go to Tools->References... to see if there are any references missing. If there are, then uncheck them.

If the reference is important to any of the macros in your application, then you need to find the right one that will work on all PC's.

My problem was that I was creating apps in Excel 2000 and delivering them to some of my users who were still using Office '97. This will always cause an error. But, since you are using Excel 2000 on boths PC's, I doubt that this is the same problem. You should still check to see if there are any "MISSING:" references.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!