Vbscript Help..

[hyderabad_vasi]

[quote name='IamN0tTrouble' timestamp='1375725405' post='1304068595']
Error iss...

Msexcel object doesn't support range method here
[/quote]

Can you run the code in debug mode and can you paste here the exact line of code where it is erroring..

use pastebin.com to paste the code there and share the link here..

[AndhraAkilesh]

[quote name='Betting Bangarraju' timestamp='1375726177' post='1304068670']



msgbox petti choosava msExcel emi return chesthondo first procedure lo (sub callexceltable)?
Tell me what it returns.

Nuvvu inthaki em cheddam anukuntunnavo sarigga cheppu. anni mukkalu mukkaluga undi nee code. no definite output. clear ga define cheyyi em kaavalo.
[/quote]

Msexcel correct workbook name istundi debug lo chusanu...

Em ledu vayya workbook lo edo oka sheet lo oka range of cells nu table laga define chesi daniko Peru pettinaa

Ipudu aa table range values nu access cheyali without mentioning sheet name

That too aa Msexcel nu vere sub nunchi pass cheyali

[AndhraAkilesh]

[quote name='hyderabad_vasi' timestamp='1375727337' post='1304068768']


Can you run the code in debug mode and can you paste here the exact line of code where it is erroring..

use pastebin.com to paste the code there and share the link here..
[/quote]

Intkikochesanu nenu..

Exact gaa msexcel.range ane line daggara error vastundi.. Object doesn't support ani

[hyderabad_vasi]

[quote name='IamN0tTrouble' timestamp='1375727833' post='1304068815']
Intkikochesanu nenu..

Exact gaa msexcel.range ane line daggara error vastundi.. Object doesn't support ani
[/quote]

If that is the case then there is no range named "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]" in your excel..

You are asking excel to give the column count from the range named "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]"..but there is no such name in the excel..


The best thing is go to the excel on which you are running the code and in the formaula cell paste this "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]" and click enter..it should select the cells named with this range..if it is not there..then you got the problem..

[AndhraAkilesh]

[quote name='hyderabad_vasi' timestamp='1375729028' post='1304068949']


If that is the case then there is no range named "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]" in your excel..

You are asking excel to give the column count from the range named "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]"..but there is no such name in the excel..


The best thing is go to the excel on which you are running the code and in the formaula cell paste this "[color=#282828][font=helvetica, arial, sans-serif]AssetUserCodes[/font][/color]" and click enter..it should select the cells named with this range..if it is not there..then you got the problem..
[/quote]

Assetusercodes vundi table...

First script work avitundi ani cheppina kada..

Msexcel vere unit nunchi pass cheatunte work avadam ledu..

[tiger_sathi]

abbe