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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TampaRocks

    Loop with an array?

    Thanks, it does run a bit quicker.
  2. TampaRocks

    Loop with an array?

    Combo, that eliminates the need for the "Sleep"?
  3. TampaRocks

    Loop with an array?

    Thanks for the help. Here's the final product... For i = 1 to 42 If Not SkipSheet(i) Then Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Open "C:\Temp\0508_0" & Right("0" & i, 2) & ".xlsm" WScript.Sleep 3000 objExcel.DisplayAlerts = False...
  4. TampaRocks

    Loop with an array?

    Thanks again guitarzan. It's possible that the rest of the code doesn't work right which is causing the problem, since yes, those filenames are correct. I'll give you CASE scenario a try and see what happens. Combo, I have a macro inside the xlsm file that when Excel opens (and other stuff...
  5. TampaRocks

    Loop with an array?

    Thanks for the reply guitarzan. I added that in there, but nothing happened.
  6. TampaRocks

    Loop with an array?

    Don't know if that's the right way to put it, but hopefully I can describe it better. I have a directory with 42 spreadsheets in it. I have a script that will open a spreadsheet (in xlsm format), save it out as an xlsx file, then save/close. Here's what I have... For i = 6 to 9 Set objExcel...

Part and Inventory Search

Back
Top