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 gkittelson 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. burtech

    Prevent workbook namechange on saveas

    Whenever a worksheet is saved to CSV format, it renames the workbook to the name of the worksheet + .csv. Is there any to prevent this? Steve
  2. burtech

    Pasting from protected worksheet

    Sorry, but I don't think I understand. For i = 1 To 7 Windows(AFilePrefix & "Performance.xls").Activate 'selected protected workbook Sheets(dyArray(i)).Select 'selected worksheet to copy from Range("A1:AE124").Select Application.CutCopyMode = False Selection.Copy...
  3. burtech

    Pasting from protected worksheet

    Hi. I've got a problem with a sub which copies from a protected worksheet in one workbook, into another worksheet in a different workbook. I open the protected workbook with: Workbooks.Open "filename.xls", ReadOnly I then call an 'Import' sub which strips out several worksheets individually...
  4. burtech

    Passing multiple parameters

    Magic! Cheers Tony! Steve
  5. burtech

    Passing multiple parameters

    Hi. I'm having trouble with passing parameters into a sub. I have a sub called 'Import'. I want to pass in two parameters: a filename prefix stored in a cell on the active worksheet, and a loop value so I can put an 'Imported' flag next to the cell where I picked up the prefix. Here is my button...
  6. burtech

    Retain view on one worksheet

    Worked a treat! Many thanks, Steve
  7. burtech

    Retain view on one worksheet

    Hi. I've had a good look in the forums for a similar thread, but I couldn't find one so I'm sorry if I'm repeating this. I'm producing a export spreadsheet that loads in other spreadsheet files and performs simple copy/paste routines from those into the export spreadsheet before performing a...
  8. burtech

    Report output to a frame

    Sorry, forgot to mention that this is running on CE 9. Steve
  9. burtech

    Report output to a frame

    Hi. I'm looking for a way to present a report in a frame without the grey bar or zoom/page/print/export/search buttons and scrollbars that the activex view has. Is this possible? Steve

Part and Inventory Search

Back
Top