Invalid Qualifier - Using string.Replace() function

Question

I have been hitting Google for a while, this one is getting plain frustrating now as I can't seem to fix it. I keep getting Invalid Qualifier when trying to use the String.Replace() function.

I am trying to create a file name for storing a PDF document but there are a few exceptions where the Ref# in the table have /'s in them. My code is as follows

Dim tempRef As String
...    
tempRef = recordSet("Ref#")
MyFileName = MyPath & tempRef.Replace("/", "") & ".pdf"

Unsure why but I keep getting the "invalid qualifier" error for executing this function.

Apologies for simplicity of this one...

@Eray thanks mate, that worked. Was using [msdn.microsoft.com/en-us/library/… site) as reference, can't understand why that wouldn't be noted... Cheers mate — rjmd
– rjmd, Commented Nov 5, 2015 at 23:03
You are very welcome, buddy. I will be glad if you select my answer as the correct answer below. — Eray Balkanli
– Eray Balkanli, Commented Nov 5, 2015 at 23:04

Eray Balkanli · Accepted Answer · 2015-11-05 23:03:34Z

2

Please try:

MyFileName = MyPath & Replace(tempRef, "/", "") & ".pdf"

answered Nov 5, 2015 at 23:03

Eray Balkanli

8,05013 gold badges60 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Invalid Qualifier - Using string.Replace() function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related