Search results for query: *

hi guys I am newbie in vbscript I am running a code to check if there are any decimal values in ab dyn RN but I am getting an erro type mismatch for the line p=inst...... Can you guys plesae help me Set objSheet = objExcel.ActiveWorkbook.Worksheets("dyn RN") dim p,q ,r, isFloat3, toTest3...

hi I am a newbie in vbscript i am stuck badly in coding of n if statement please need your help Dim chkFl20 chkFl20 = 0 Dim cnt20 Dim mark20 cnt20 = objWorkbook.Worksheets.Count mark20 = 1 Do While mark20 <= cnt20 If objworkbook.Worksheets(mark20).Name = "GSM Nbr Cell" and...

hi guys this is very simple I am newsie and need you help the following part is not working for me. I dont know I guess the fault is in the if statement below Dim chkFl15 chkFl15 = 0 Dim cnt15 Dim mark15 cnt15 = objWorkbook.Worksheets.Count mark15 = 1 Do While mark15 <= cnt15 If...

I am new bie and I am getting error in ths step just a small thing can you guys please help me out Set objSheet = objExcel.ActiveWorkbook.Worksheets("RBS Site") dim i,k ,j, isFloat, toTest, xlup, nmaxrow xlup=&HFFFFEFBE nmaxrow=objSheet.range("a65536").end(xlup).row -- to go till end of the row...

hi guys I am newbie in vbscript I desperately need your help I have written a small code which checks the columns, decimal numbers, and tabs in an excel sheet also it converts cell values into values (to remove formulas) . also right now I am taking arbitary number of rows and colums (10000 rows...

Hi I am a New bie in Vb script what I am trying to do is that I am checking the tab name if RBS site is not found then it should end otherwise it should continue the code.Please help me <PACKAGE> <JOB ID=Submit_Reminder> <SCRIPT LANGUAGE="VBScript" SRC="c:\test\clearquest.bas"/> <SCRIPT >...

Hi guys, I am a newbie in vbscript. The excel sheet which I am working on should not have decimal numbers so what I want to achieve is that if the script can show the cell numbers where there are decimal numbers and also if possible it can convert it into integers. Prefreably I would be glad...

Hi guys, I am a newbie in vbscript and I need your help I am basically trying to copy all the data from one excel sheet into the same excel sheet (in the same location) but I want to paste it as value (pastespecial- value) as I want to remove all the formulas in the excel sheet and cel value...

hi guys, I need help in Vbscript I am writing a code which will show up errors in excel Set objSheet = objExcel.ActiveWorkbook.Worksheets("RBS Site") ------------------------------------------------------------ if (Sheet4.Name <> "RBS Site" ) then objtxtStream.Writeline "Error in RBS...

Hi I am running a VBA macro and I am getting the error "RUN TIME ERROr 6 OVERFLOW". Attached is the file. Please need help ASAP the subroutine I am running is update sheets(); I have the file let me know how I can send it

Hi I want to copy the data from one tab of the excel into another depending upon some conditions in the code but when I reun the subroutine it doesnt run I guess there is a mistake in the switch syntax Sub Sort_tabs() Dim fap As String, fo As String, one As String, two As String Dim i As...