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 biv343 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. aba104

    Problems when Multiuser Save to a Shared Workbook

    Could anybody help me in fixing following problem in saving the shared workbook? I have around 10 users sending data from their own worksheets to a shared workbook every day. When some users try to save the shared workbook, they encounter question like "The file exists already, do you want...
  2. aba104

    How to send data from an opened workbook to another opened workbook?

    VBAjedi, Thank you so much for your help. With your help I finally solved my problem. Thanks and have a good week! JY
  3. aba104

    How to send data from an opened workbook to another opened workbook?

    Hi, VBAjedi Sorry for not providing detail. The emptywork I meant is one I set up with VBA. The purpose of this book is to collect data from other 6 workbooks. My source data is in exactly the same place in each of the six books. I want to open this new workbook everyday, then open other 6...
  4. aba104

    How to send data from an opened workbook to another opened workbook?

    Hi, everyone, I need to open an empty workbook, and receive data from other six opened workbooks. Could anyone tell me how to achieve this? Thanks a lot. I need this urgently. JY
  5. aba104

    Table of Contents for aHuge Word Document

    Frederico, Sorry. I took your name as Frank. I appologize for that. JY
  6. aba104

    Table of Contents for aHuge Word Document

    Thank you, Frank. I know that Word has index/table of contents. I am just having hard time in formatting the headings. I need to format the headings before I use index/table of contents, do I? Thank you again. JY
  7. aba104

    Table of Contents for aHuge Word Document

    Could anyone tell me how to make table of contents for a huge word document using some techniques? This really gives me a lot of hard time because I made it manually, and every time when we make change to the document, I have to shift all the page numbers. Thanks. JY
  8. aba104

    Using Date format As Folder Name

    Thank you, Miggy. I will have the files deleted after it accumulates 1 month. JY
  9. aba104

    Using Date format As Folder Name

    Thank you all.. I took Miggy's method, changed directory to "..", it was simple and worked perfectly. Again, thank you all very much! JY
  10. aba104

    Using Date format As Folder Name

    Miggy, Thank you for your help. Here is my code: mycount = Sheets("Head Sheet").Range("O51").Value a = Format(Now, "mmddyy") Set fs = CreateObject("Scripting.FileSystemObject") If...
  11. aba104

    Using Date format As Folder Name

    Hi, I am trying to save a group of files created on the same day in the same folder. Since these files are produced daily, I am trying to group these filesunder in the same folder using date as folder name . The folder was created by using Dir(Path,vbDirectory) function. But what strange...

Part and Inventory Search

Back
Top