Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
trouble with looping construct
I am trying to get some inserts going based on a number of formfield paramaeters that look like this. UsrId = 2 Date = 10/19/2001 Time = 8 Shift = 1 WeekNum = QcNum = 35, 36, 37 SampleFreq = 4, 2, 2 NumMeas = 5, 2, 3 TestGroup = 1, 1, 1 MachineID = 8, 8, 8 Measurement1 = 1, 1, 1, 1, 1, 1, 1...- seddies
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
adding to session array
Hi, I am inserting into a database by looping over some excel spreadsheets and then inserting the results into a 2d array using getrows, everyhthing is good to here, I store this in a session variable which I then insert into the database. problem is in my loop the session variable only gets...- seddies
- Thread
- Replies: 0
- Forum: Microsoft: ASP (Active Server Pages)
-
grab excel worksheet names
fengshui, jackpot !! Had to change the code a little for asp but all seems good. Thanks so much for your tip. here for anyone else who is interested is the code snip Set objXL = CreateObject("EXCEL.application") ' objXL.Visible = True Set objWkBook = objXL.WorkBooks.Open... -
grab excel worksheet names
Hi Fengshui1998, thanks for the reply, is that some VB code? I have never come across the WScript.CreateObject. The code threw an error on the workbooks.open "form1.xls" (my xl filename) Expected end of statement shoud the whole path be in there? Set objXL =... -
grab excel worksheet names
Hi, I'm seeking some vbscript code in order to grab all the worksheet names from an excel file, anyone got any suggestions, pointers. I am able to query the actual worksheets when hard coded but how do you select the worksheets. hmmmmm........ thanks
