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!

  • Congratulations strongm 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. Marita

    Changing folder reference in VBA for Excel

    Thanks to both of you, that is very helpful. Stars to you!
  2. Marita

    Changing folder reference in VBA for Excel

    Thank you very much for your reply, Jedi! I tried not including the path in the code, and it seemed to work today on the LAN (I think, I only tried it with one module), but did not work on my laptop at home tonight. If the input box is the answer, any help on how I can do that? Marita
  3. Marita

    Changing folder reference with VBA via user input

    I have a macro that updates numerous files. The file paths are recorded in the code. However, the folder name changes monthly(Oct, Nov, etc). How can I best write a macro that will edit/replace the folder name? Any help will be appreciated. Marita
  4. Marita

    Changing folder reference in VBA for Excel

    I have a macro that updates numerous files. The file paths are recorded in the code. However, the folder name changes monthly(Oct, Nov, etc). How can I best write a macro that will edit/replace the folder name? Any help will be appreciated. Marita
  5. Marita

    Ready and Calculate in the status bar at the same time

    I have some files that are around 8.5 meg, but when I change 6 of 12 months from range valued to calculation mode (dsums), I get the ready and calculate at the same time status. What causes this, and how can I fix it? Thanks for any help. .
  6. Marita

    copying relative references from filtered list

    I have a download file that changes monthly, ie the rows are with the related data will not be the same. I filter it by business group and P&L type and paste value it into various spreadsheets. I would like to automate this process. However, even using relative reference recording, the macro...
  7. Marita

    upgrade of microsoft ole provider

    how to upgrade to higher version from microsoft ole provider 4.0

Part and Inventory Search

Back
Top