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

    Moving worksheets to a network Drive.

    Hi guys, I'm trying to move a worksheet to a network drive but I keep getting the subscript is out of range error. This is what I have so far: Sheets("Sheet1").Select Windows("My Version.xls").Activate Sheets("Sheet1").Select Application.WindowState = xlMinimized...
  2. cjpicc11

    Saving sheets without the Macro.

    Hey guys, I'm running a macro for work where sql statements are ran and it than applies this data to a worksheet, it then saves the file on a Network drive. How would I be able to just save that information on to the file without the Macro. I dont want anyone to see the macro. Any help would...
  3. cjpicc11

    Inserting Text (Sorry for the Newb Question)

    Hey guys, Just was wondering how I can insert text into a Cell. I'm trying to insert text into a cell with a date. Something like this "Text" & Date - 7. Just dont know what the keyword is for inserting the text or how I can start up the code. Any help I would appreciate it. Thank You, Chris
  4. cjpicc11

    Incorporating Variables into an SQL Statement

    Hey guys I'm automating a report for work, and trying to incorporate a Date Variable into an SQL statement. Below is the Variable I have set up followed by the SQL Query I'm trying to run which errors out. The time is static because I need to run it for that full day, I just need to set the...

Part and Inventory Search

Back
Top