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 TouchToneTommy 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: RooSXL
  • Content: Threads
  • Order by date
  1. RooSXL

    Run Macro for Multiples Open Files

    I need to perform certain formatting to a series of open files. I came up with a small macro, that as I go along will expand into further formatting. My two biggest questions are: 1.- I am needing to specify in the macro manually before running it to variables to be changed in the worksheet...
  2. RooSXL

    Definining Strings in one macro to be used with other macros called

    I have two macros. In the first certains cells in the worksheet contain the files that I need to open and copy information from them once I have inserted in a specific cell the location I need the information from. This needs to be repeated for each sheet in my workbook. I need to be able to...
  3. RooSXL

    Do until macro is not recognizing date data

    I am trying to build a application in Excel to place an active reading into the months in order to later on only pick values that have an active forms. For some reason is not stoping at the cell carrying the date selected in the cell. The values in the cell is selected from a dropbox (data...
  4. RooSXL

    With Object is giving me an error

    I have been trying to find out what error is in this code, but no luck whatsoever. I keep getting RUN_TIME Error '1004' Select Method of Range Class Failed Set book = Workbooks.Open("C\FileName.xls With book.Sheets(2).Range("F1") .AutoFilter .AutoFilter Field:=7...
  5. RooSXL

    How do you use AutoFill for different ranges?

    The macro below creates the formulas in the rows available and then fills the cell below with the same formulas to the exact range of cells specified when recording. However I have other applications or worksheets where the number of rows could be variables. How do I make run on variable...
  6. RooSXL

    Create MessageBox to promt me to select data in DropBox

    I am trying to create an excel report that will be gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...
  7. RooSXL

    Create MessageBox to promt me to select data in DropBox

    I am trying to create an excel report that will be gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...
  8. RooSXL

    Create MessageBox to promt me to select data in DropBox

    I am trying to create an excel report that will gathering information from different files and it will mainly be driven by macros trigerring macros. However there a couple of cells that require some information in order for the macros to pick the right files. How create a macro that will...

Part and Inventory Search

Back
Top