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 Rhinorhino 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: *

  • Users: burtech
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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