Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    1,498

    VBA issues for users in Citrix

    Good Morning Excel Geniuses....

    I have some VBA files that work perfectly fine for users runing the files on their laptops, but have strange issues for people using Citrix.

    One of these is...
  2. Replies
    8
    Views
    357

    Re: Inserting and Deleting Rows

    If you don't have sub-total lines in the middle of your data, you can always just sort the data and the blank rows will go to the bottom
  3. Replies
    0
    Views
    245

    Sorting in Excel 2007 - Stange Things

    Hi All -

    I've just been upgraded againstmy will to Excel 2007 and I've noticed some... interesting... things happening when I sort data most notably:

    If I have formulae where the reference to...
  4. Replies
    4
    Views
    312

    Re: Array Formula not working

    Thanks guys!

    Sometimes it's useful to have an extra brain or two.

    I did, in fact, have a #N/A in my array. I thought I had checked for them before, so I discounted that as a reason - but...
  5. Replies
    4
    Views
    312

    Array Formula not working

    Hello...

    I'm trying to do a 'MAX IF' array... and I THINK I have the formula right, but it's returning a #N/A

    This is my forumla - and I am remembering to CSE to exit it, etc.
    ...
  6. Replies
    1
    Views
    350

    Change VBA using VBA??

    I have a group of users who all have a set of files on their computers... but we've found a bug in one of the macros.

    I'm sending them an 'update' file that will update a bunch of other things in...
  7. Replies
    2
    Views
    265

    Re: Conditional formatting

    I often find that when this happens, if I instead set the conditional fomatting on one cell first, then paste the format over the other cells, it 'takes' ...

    So, if you set the formatting on A1 to...
  8. Replies
    2
    Views
    1,863

    Excel is defaulting to paste values

    Hi All -

    Excel decided yesterday that when I click 'paste' it would paste values - always- unless I paste special formulas or all.

    I was hoping this was an "Excel is tired" issue - so I shut...
  9. Replies
    5
    Views
    2,779

    Re: Call a .bat file from VBA

    It was in the FTP syntax after all....

    I needed an extra line to tell it in which directory to put the 'got' file.

    Print #lInt_FreeFile01, "lcd C:\OOD"


    Phew! Now to see if I can make it...
  10. Replies
    5
    Views
    2,779

    Re: Call a .bat file from VBA

    OOH!

    I found where it's putting my file!

    I think I need to do a chdir in the VBA as well, because it's getting my file, but putting it in some random folder - must be the last place I told...
  11. Replies
    5
    Views
    2,779

    Re: Call a .bat file from VBA

    If I click on the .bat file and run it manually, it works. So - I don't think there's anything wrong in the FTP syntax, but that the issue is in the way I'm calling the .bat file? Or maybe it IS...
  12. Replies
    2
    Views
    403

    Re: Excel: Change Event based on Defined Name

    Hi gapa -

    You need to use 'not intersect' if you have a range (even if the range is only 1 cell, once it has a name it's a range)...

    Try:

    Private Sub Worksheet_Change(ByVal Target As Range)...
  13. Replies
    5
    Views
    2,779

    Call a .bat file from VBA

    Hi All -

    I've been playing with using VBA to create a .bat file which is then called to get a file off an FTP.

    Right now - the VBA creates a .txt file and a .bat file. If I run the .bat file...
  14. Replies
    3
    Views
    293

    Re: Conditional lookups based on other cells

    If you just want a list that shows the people who had preventable errors, and how many. I would use a pivot table.

    If you want a list of all people, and those with 0 errors to show 0, you could...
  15. Replies
    0
    Views
    364

    Excel "break up" on calculation

    I'm experiencing a bizarre thing when Excel calculates large spreadsheets (Excel 2003. Windows XP.).... when it calculates, it LOOKS like it's actually cycling through each of the pages as it...
  16. Replies
    2
    Views
    1,808

    VBA - uploading to FTP

    So... I think I'm half decent with VBA, but I'm a novice at using Shell, creating .bat files, etc.

    I'm using the code below to try and upload a file to an FTP... but it's getting stuck in the 'do...
  17. Re: Randomly saving a copy of a file in 'my documents'

    It just says...

    wbData.save
    wbData.close

    I originally assumed that she was moving them or touching things she should be, but I watched it happen... I deleted the files from the My Documents...
  18. Randomly saving a copy of a file in 'my documents'

    Hi All -

    I have a strange question here... not actually sure if the cause of the problem is Excel or Windows - but I figure if I ask the Excel gurus and you don't know then it might be a Windows...
  19. Replies
    5
    Views
    6,086

    Re: VBA - Using a variable to open a form

    Ha!!

    That's what I was after... works a charm - thanks much!
  20. Replies
    5
    Views
    6,086

    Re: VBA - Using a variable to open a form

    This is what I have at the moment...

    ________________________________________
    Private Sub btnNext_Click()

    Dim nextform As Object

    mylookup = Me.lblBatchOutcome.Caption
    formname =...
  21. Replies
    5
    Views
    6,086

    VBA - Using a variable to open a form

    Hi All -

    I am building a system that essentially walks the user through a series of flow chart questions.

    eg: Was the batch number found?

    If NO then
    If YES then

    Depending on the...
  22. Replies
    2
    Views
    10,061

    Re: VBA: list all available drives

    Thanks Tom!

    I'll have a play with it this afternoon...
  23. Replies
    2
    Views
    10,061

    VBA: list all available drives

    Hi All -

    I'm running a program that requires the use a a file called "ap.csv" This file will exist inside a folder called "ap"

    This folder will exist in the root directory of ONE of the...
  24. Replies
    2
    Views
    294

    Re: FIND - list of strings to check a cell for

    This is what I came up with... seems to work. 'checkme' is a number - it essentially counts the number of search strings that appear in the description... don't know if there is a fancier/better...
  25. Re: Does anyone know of a shorter, faster way to do this...

    Can you use filters instead?

    Turn on the 'auto filter' and use the dates entered by your user to filter the data & the copy the visible cells and paste into your other sheet...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4