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

    User input variables not passing values to new procedure in Excel VBA

    That's great - I had indeed declared it somewhere else!!! Thank you very much to all of you for your help with this!!
  2. Mattyb33

    User input variables not passing values to new procedure in Excel VBA

    Thanks for your help guys!! One final question I have - I have declared a date:- Public daterep As Date The value held in this variable is an input box which the user inputs (e.g. 05/01/2011). When I hover over this variable in my first procedure when stepping through it then it displays the...
  3. Mattyb33

    User input variables not passing values to new procedure in Excel VBA

    Sorry - I should have realised that, my mistake!!!! I've corrected that. I enter a value for this variable when prompted. The macro then runs to the next procedure, and when I try to use the value I entered in this variable the code says it's empty. Have you got any idea why it would empty the...
  4. Mattyb33

    User input variables not passing values to new procedure in Excel VBA

    I have set up several variables where the user inputs the value via input boxes. The problem I have arises when the macro runs onto the next procedure. For example, one of the variables I have is:- Dim message6, title6, default6, day message6 = "Please enter the day you are reporting on in...
  5. Mattyb33

    SQL in Crystal Reports 2008

    I am looking to learn how to write SQL in Crystal Reports 2008 to help develop my skills and also help my reports run quicker. Would anyone please be able to point me in the direction of any user guides I would be able to make use of and/or download to help? Any help would be greatly appreciated.
  6. Mattyb33

    For each loop in VBA for Excel

    I am having a problem with a For Each loop in Excel VBA. I have a workbook with 4 sheets in it. I want to run a particular piece of code for each sheet in the workbook. I currently have the following code:- Dim current as worksheet For Each current in Worksheets MY CODE HERE Next When I...
  7. Mattyb33

    Export Crystal report to Excel using VBA

    Ok I think I'll have to export them from Crystal manually into a format Excel can understand as you say. Thanks for your help!!!
  8. Mattyb33

    Export Crystal report to Excel using VBA

    Apolgies for not being clearer. The output of the reports are emailed to me in Crystal format.
  9. Mattyb33

    Export Crystal report to Excel using VBA

    Yes sorry, I mean importing to Excel from the Crystal reports. I have 6 Crystal reports set up, most of them in a cross tab format. They're emailed to my inbox (Microsoft Outlook) every week in Crystal format. So I was wondering if it was possible in VBA for Excel to either import them from...
  10. Mattyb33

    Export Crystal report to Excel using VBA

    I have 6 Crystal reports which I want to export to Excel. I know how to do this, but my question is can I do it using VBA for Excel?? Any help would be greatly appreciated!! Thanks, Matt

Part and Inventory Search

Back
Top