Search:

Type: Posts; User: Selfie; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Delete Blank rows in a range of data (VBA, 2003)

    I have a range of data but every other row is blank - is the a quick macro that I can use to delete the blank rows?
  2. Replies
    5
    Views
    1,318

    Re: Auto-numbering sequence (Excel 2003)

    Phenominal. Worked like a charm.

    IT would have taken me a least a day to figure that out with my limited rusty skills! THANK YOU - You have saved me manually having to do this on 3000 plus rows....
  3. Replies
    5
    Views
    1,318

    Re: Auto-numbering sequence (Excel 2003)

    Yes.
  4. Replies
    5
    Views
    1,318

    Auto-numbering sequence (Excel 2003)

    I want to be able to create a macro that will do the following
    From a Column with information as below, and add 001 to the end.

    Amazon
    Amazon
    America
    American
    American
    TheAmer
    Analyser
  5. Saving a Merged Document to Individual Files (2000/2003/XP)

    I need to be able to take a mail merge document and save each letter (section) as a new document in PDF format to a dictory on the users desktop. Each file needs to be saved using the following...
  6. Replies
    2
    Views
    332

    Project Protecion (2000/XP)

    I have locked a project for viewing and have set a password to view the project properties. This is working fine on my machine, I can access the code using the password I have set. I have...
  7. Replies
    3
    Views
    302

    Re: Macro Secruity Message (2000/2003/XP)

    Yes - even when the security is set to low I get this message? It is defintiely machine specific as the workbook works (with macros enabled) fine on another machine
  8. Replies
    3
    Views
    302

    Macro Secruity Message (2000/2003/XP)

    When opening a workbook with macros I am getting a message "The macros in this project are disabled...." - Normally when macro secruity is set to Medium the I get a message to Enable or Disable...
  9. Replies
    2
    Views
    634

    Re: Hide-Unhide Pivot Items (2000/xp)

    Thank you Hans. This does work.
  10. Replies
    2
    Views
    634

    Hide-Unhide Pivot Items (2000/xp)

    I have a pivot table and I want to a user to be able to click on a button to hide certain pivot items from a pivot field and then use another button to reset and display all pivot items from a pivot...
  11. Re: SQL Script (Calling a Stored Procedure) (EXCEL 2000, XP)

    Thank you for this but I am unsure how I can tell if the MSQUERY has completed. Whilst the query is executing cell A1 has some text in it to say Database: Getting Data... and my rngdata variable...
  12. Re: SQL Script (Calling a Stored Procedure) (EXCEL 2000, XP)

    Thanks Andrew. This unfortunately stops the SQL data being returned as well, even if if I put the code below the SQL extract code. This means I am getting the same problem??????
  13. SQL Script (Calling a Stored Procedure) (EXCEL 2000, XP)

    I have a macro using MSQuery calls a stored procedure on a SQL database. I have two modules one that gets the sql data and one which formats this data once it is in Excel. The later uses the...
  14. Replies
    36
    Views
    3,653

    Re: Calendar Control (EXCEL 2000, XP)

    Thanks Hans. Some how I manage to get two of the same post so deleted one imediately but you where obviously quicker than me! <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

    To...
  15. Replies
    36
    Views
    3,653

    Calendar Control (EXCEL 2000, XP)

    I am using a calendar control, supplied by this very helpful Website. However on one specific machine when I use the control I get the following Microsoft Froms error "Could not load object because...
  16. Replies
    0
    Views
    264

    Outlook Forms and Spelling (2000/XP)

    I am currently using an Outlook form to integrate with another application when sending an email. Users have noted that although spelling works in the body of the email - it does not spell check...
  17. Replies
    2
    Views
    392

    Re: Outlook (2000/XP)

    Thank you - this gives me some options
  18. Replies
    3
    Views
    654

    Re: Outlook (2000/XP)

    Thanks. Article is interesting but definitley not all of it makes sense.
  19. Replies
    3
    Views
    654

    Outlook (2000/XP)

    Can someone explain active content and why if an email contains it the preview bar in Outlook cannot display active content in the Preview Pane? I have an Outlook form designed to enable...
  20. Replies
    2
    Views
    392

    Outlook (2000/XP)

    If I have created a customised outlook template in order to set up intergration between Outlook and a CRM application. The integration works however every time I send and email I get the message " A...
  21. Replies
    2
    Views
    398

    Re: Data Extract (VBA) (Excel 2000)

    Thanks Hans

    I was modifying the workbook, replacing data with Dummy Data and the macro works fine so it has to be something with the data, I will gradually add the data back and see which is the...
  22. Replies
    2
    Views
    398

    Data Extract (VBA) (Excel 2000)

    I have a macro that performs a data extract based on set criteria and copies the data to another location. I have the Unique Records Only value set to true however when the macro runs it does not...
  23. Replies
    6
    Views
    1,511

    Re: Editing the Outlook .fav file (Outlook 2000)

    Thanks for this. I actually posted this on behalf of a work colleague and not sure if this will help or not but I will certainly pass on.
  24. Replies
    6
    Views
    1,511

    Editing the Outlook .fav file (Outlook 2000)

    This is a general query to see if it is possible to programmattically edit the .fav file?
  25. Replies
    1
    Views
    317

    System Calendar (Excel 2000)

    I have a 3 date combo boxes on a worksheet for the user to select a day, month and year. The date information here is used to extract some data from an external database. Currently if the user...
Results 1 to 25 of 31
Page 1 of 2 1 2