dim as string, but end as double

Hi,

I need to give some data as string to a Json request

I put variable dim price as string
when i look in the locals window I see
Item 2 : "price" : Variant/String
but
: price : 230.096 : Variant/Double

I tried with format the cell withe the value as text
for some other figures it become string for price it stay double

how to solve this please

Thanks

Hi,

when you need a particular data type just declare the variable accordingly rather than Variant …

Hi Marc,

I am sorry, but I not really understand well
could you tell me how to do ?

If you use the appropriate data type for any variable you can't obviously see 'Variant/Double' but just the data type declared …

you mean if you dim as string, it can not come out as double ?

but it does

Originally Posted by incobart

I need to give some data as string to a Json request

Another way is to directly send the cell Text property rather than one of its value properties …

Marc, with all respect...
but not everyone is as deep in excel as you, I don't understand anything you say

could you please explain how to do in simple language ? thank you so much

Originally Posted by incobart

you mean if you dim as string, it can not come out as double ?

but it does

No as a declared variable other than Variant can't obviously change its data type
so it can't be in the VBE 'Locals' window like you can easily check just declaring a variable as String,
allocating a value to the same variable then taking a glance to 'Locals' window for the same variable …

someone can translate please ?

Depends on how you have declared your variables, if you use

Please Login or Register  to view this content.

then it will be a string, however if you have declared it like

Please Login or Register  to view this content.

then Price is variant & Test is a string

Ow Fluff what a relief finally something understandable
Thanks
I used the first Dim price as string

but in locals I see variant/double and not variant/string. Marc says it can not change but .. it is like that

Can you post your code?

The code is long and complex but i get out the main thing... (not my code)

Please Login or Register  to view this content.

local windows shows
params3
: Item 1 : "instrument_id" : Variant/String
: Item 2 : "price" : Variant/String
: Item 3 : "size" : Variant/String

: strCurP : "IOSTBNC" : Variant/String
: strRate : 230.096 : Variant/Double
: strQty : "17.4" : Variant/String

before strQty was also double but became string when i formatted the cells to text
strRate stay double :-(

As yet explained here in several posts like #11 if you want some useless variables then declare each one as String for example …

With

Please Login or Register  to view this content.

Only JsonResponse & strCurP are strings, the rest are variant. You need to specify the type for each one individually like

Please Login or Register  to view this content.

Marc,
you mean dim strRate as variant ?

and strRate = wsTR.Range("C1").text ?

or Fluff HEEEELP

Fluff13 YOU DID IT !

THAAAAAAAAAAAAAAAAANKSS

can be so simple


Mark #11 you mean apollo 11 ?

LoL, you are singing 'I believe I can fly' !

But just well reading answer you may understand your bad …

You're welcome & thanks for the feedback.