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 derfloh 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. jbrown2339

    macros not staying with spreadsheet

    Thanks so much, I've been cracking my head trying to figure out why the buttons were doing that, and now it totally makes sense! It was the toolbar and not the buttons. Thanks so much for your help!! I was totally thinking in the wrong direction.
  2. jbrown2339

    macros not staying with spreadsheet

    Oh, didn't think about that. I did the Tools->Customize->Toolbars->Attach command. Is there another step I should take? Thanks, I never even thought of that...
  3. jbrown2339

    macros not staying with spreadsheet

    Those are just examples. Let me explain again. Sorry if I've been confusing. I am recording a simple macro on an excel file with about 50 sheets. So I have created a navigation toolbar, with two buttons on it (which I attach to a macro), to take the user to the main 'sheets' in this report...
  4. jbrown2339

    macros not staying with spreadsheet

    Sorry if this is confusing. Maybe this will help: File A : Resides on a public server. If I record macros to a button on this file, and then email the file to a coworker, they can run the buttons. If I email the file to a person without access to this drive, once they hit a button either...
  5. jbrown2339

    macros not staying with spreadsheet

    When I record them, I instruct Excel to record them in "This Workbook". So my intention is to have them saved in 'Trend Report - Template.xls'. I am doing a SaveAs to create the "Dallas Trend Report.xls", and then I either email or place the new files out onto a server (some of my users have...
  6. jbrown2339

    macros not staying with spreadsheet

    I've got a series of reports in Excel, that I feed a bunch of data into, and give to the end users. Basically, I have a file called "Trend Report - Template.xls", and as I feed data into it from each of our markets, I save under different names, i.e. Dallas Trend Report.xls, Houston Trend...
  7. jbrown2339

    Exporting Data to Excel - Keep existing calculations intact

    I tend to always find the most complicated ways of doing things, when there is a much simpler approach. :) Thanks!
  8. jbrown2339

    Exporting Data to Excel - Keep existing calculations intact

    I've got an Access database, that processes a large dataset, and from there I've been copying the resulting summaries into an Excel spreadsheet, which then creates some reports. The data is broken out, so I am populating around 10 individual sheets in Excel. Each sheet however has a few columns...
  9. jbrown2339

    Combo Box Not Displaying All Possible records

    Also, this is from Access '97, not 2000.
  10. jbrown2339

    Combo Box Not Displaying All Possible records

    I'm trying to build a series of forms to walk an individual with little computer skills through some tables to look up some information. The table I am building these forms on has around 181,000 records in it, each of which identifies a unique customer. I created two forms for him to look at...

Part and Inventory Search

Back
Top