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. stever1725

    how to add a recorded excel macro with existing code

    lameid, got it. thanks for the Great Advice!!
  2. stever1725

    how to add a recorded excel macro with existing code

    lameid.. so do i fix the verbage of the recorded macro and then paste the code after ***Set objWorkbook = objExcel.workbooks.Open("\\Steve\pfs it\CCP\PRONERVE.xls")*** if so do paste in the **Sub MacroCGH()** part as well?
  3. stever1725

    how to add a recorded excel macro with existing code

    To anyone who can assist me.. i have this code that opens an existing .xls file and renames it and saves with a password. I recorded an excel macro to format the file and would like to add this right before it saves with a password. thanks steve --opens and saves w / pwd Public Function...
  4. stever1725

    how to move multiple files with same extension

    PHV, thanks for the pointer... i got it hammered out... i even got it to where it adds the date to each file. much thanks.
  5. stever1725

    how to move multiple files with same extension

    I have written some code that imports all .xls files from C:\Import .... into access... creates a report that gets sent to management. Can anybody help me to now move these files from C:\Import... to C:\Import\Processed ?? i have tried quite a few different codes but cannot get them to move...
  6. stever1725

    emailing with an attachment

    Thanks Irish and PHV... i changed the .Attach to .AddAtt and the email with attachment went out. The thread705 helps as well. Thanks again... i will keep tryn to do my part and help out others as well. peace
  7. stever1725

    emailing with an attachment

    Anyone who could help.. i have researched but cannot seem to get this resolved. i am getting **Run-Time error '450' Wrong number of arguments or invalid property assignment** on debug the .Attachment line is highlighted. Can somenone give me some insight to this? if i take out this line i do...
  8. stever1725

    find and replace the first space in a field with a comma

    Randy- if i wanted to use this function in a macro-RunCode.. would i would have to call the table first and then the function ??
  9. stever1725

    find and replace the first space in a field with a comma

    Greg, i had one too many spaces for the "find".. it works, thanks. Randy, thanks also.
  10. stever1725

    find and replace the first space in a field with a comma

    i pasted this: replace([GTR NAME]," ","," , 1, 1) into the update to... but no commas have been added in the field.... what am i doing wrong?
  11. stever1725

    find and replace the first space in a field with a comma

    help please.. how can i find and replace the first space in a field with a comma. i have an update query with : replace([GTR NAME]," ",",") in the update to field... this field has more than 1 space, i just want to replace the first one.
  12. stever1725

    how to password protect a report that is sent as .rtf thru a macro

    how to password protect a report that is sent as .rtf thru a macro. any suggestions

Part and Inventory Search

Back
Top