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

    Unwanted Message box when applying filter

    Hi. I've been working on a database for awhile now and I have a button on a form that is supposed to apply a filter based on criteria from the user. However when I actually go to apply the filter in the code I get an message asking to input the value for the filter even though I stated it in the...
  2. Fr33dan

    CopyFolder error from CD

    I'm trying to write code that will copy all the files and folders from a CD to a folder on my hard drive with the same name as the CD volume label. Then it will alert me to insert the next disk and copy those files. I get an "Invalid procedure call or argument" error on fso.CopyFolder line...
  3. Fr33dan

    VLOOKUP not returning correct results

    I'm creating a spreadsheet that need to take values from Column A lookup the closest value in Column AA and place the corresponding value in column AB into column B. All the data begins on row 15. AA |AB 869.18|-200.43 670.37|-88.8 353.19|-14.7 0 |-5.5 When I put...
  4. Fr33dan

    Printing from Macro Shrinking Chart

    I wrote this macro to print the data of many files. I do this by looping through a list of files and if the file has been tagged I import the data and print. The problem is that when the file prints one of the graphs shrinks a little bit. On one file it's not noticeable but after 30 files it's...
  5. Fr33dan

    Print Dialog Box

    I have a macro that opens and prints out multiple files. I was wonder if it was possible to display a print dialog box without printing anything so I could use the user's choices on the rest of the prints.
  6. Fr33dan

    Losing Query Table

    I have a workbook that was created in Excel 97 and I need when I open it in Excel 2003 I get the error: The workbook was last saved in an earlier version of Excel. The following data may have been lost: Query Table Many people use this file and it needs to be accessible to both versions, does...
  7. Fr33dan

    How to Create Shortcut from macro

    Does anyone know of a method to create shortcuts from a macro? I've searched google to no avail.
  8. Fr33dan

    AutoOpen not running

    I have an AutoOpen macro in the Normal.dot file and the macro does not run when I open a file. The AutoExec In the same module runs. This is the code for the macro as it is now: Sub AutoOpen() MsgBox "The AutoOpen Ran this time" End Sub I'm running Office 97 on a Windows 2000 computer and...

Part and Inventory Search

Back
Top