Save as false.xls localized problem

[kensei]

hi dudes :D

hi have a problem with the save as macro :D

i created that sub

i retrieve the value of a cell and with that i create a name to pass to the save-as .

the save as has a check to ask if overwrite or not.

everything works fine but i have to localize the sub also for not-english excel..

Please Login or Register  to view this content.

the problem is that..

Please Login or Register  to view this content.

is not working...

so i tried

Please Login or Register  to view this content.

it works only for english excels


then i tried

Please Login or Register  to view this content.

it works only for italian excels ..

i could make a switch to check every "false" word in every language .. but i'm looking for a smarter idea

is there a way to check the "false" word not localized in some language?


please i need your help ^_^

regards and thanks

Jack

[davegugg]

This is kind of a wild guess, but try:

Define your saveFileName as a variant instead of a string. False is equal to 0, so check if the variant in number format is equal to zero. This worked on my english version when I tested it.

Please Login or Register  to view this content.

[kensei]

That's the smartness i was looking for

works great, thanks a lot

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[kensei]

done! thanks :D