Entering text in a cell with vba - weird behaviour

davidtrickett · May 24th, 2002, 12:37 PM

This macro enters the address of a folder on a remote server into a cell, thus:

Range("a1").Value = "\servernamegroupnamelocalfolder"

The macro then goes on to open a file in that location.

Works fine, of course, except that one user reports that it doesn't work - investigation reveals that instead of entering "\servername..." it is entering "'servername..." - i.e. replacing the first backslash with a single quote mark.

I have been unable to duplicate this, and as the user is several hundred miles away it is not practicable for me to look at his system to find out what is going on.

Does any one have any idea why Excel is taking it into its head to do this? I can think of a few workrounds, but I would rather identify & cure the problem itself.

Thanks

davidtrickett · May 24th, 2002, 12:40 PM

More weird behaviour on this board - it has entered extra backslashes!

To clarify where 4 backslashes are shown there should be 2, where 2 there should be 1.

davidtrickett · May 24th, 2002, 12:44 PM

Now the extra backslashes have gorn!
Ho hum.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 12:37 PM	#1
davidtrickett New Member Join Date: Apr 2002 Posts: 33	This macro enters the address of a folder on a remote server into a cell, thus: Range("a1").Value = "\servernamegroupnamelocalfolder" The macro then goes on to open a file in that location. Works fine, of course, except that one user reports that it doesn't work - investigation reveals that instead of entering "\servername..." it is entering "'servername..." - i.e. replacing the first backslash with a single quote mark. I have been unable to duplicate this, and as the user is several hundred miles away it is not practicable for me to look at his system to find out what is going on. Does any one have any idea why Excel is taking it into its head to do this? I can think of a few workrounds, but I would rather identify & cure the problem itself. Thanks

May 24th, 2002, 12:40 PM	#2
davidtrickett New Member Join Date: Apr 2002 Posts: 33	More weird behaviour on this board - it has entered extra backslashes! To clarify where 4 backslashes are shown there should be 2, where 2 there should be 1.

May 24th, 2002, 12:44 PM	#3
davidtrickett New Member Join Date: Apr 2002 Posts: 33	Now the extra backslashes have gorn! Ho hum.