Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Slow file copy working from home compared to at the office

    I often work with very large (>100Meg) files. If I am connected to the LAN at work, and try to copy a file from one LAN location to another, it goes relatively quickly. However, If I am working...
  2. Replies
    5
    Views
    1,934

    Thanks, guess I'll just do a backup and try it.

    Thanks, guess I'll just do a backup and try it.
  3. Replies
    5
    Views
    1,934

    Hi everyone There must be a thread about this,...

    Hi everyone

    There must be a thread about this, but I don't seem to be putting in the right search parameters.

    I want to upgrade my Office 2003 to Office Home & Student 2007, but I want to keep...
  4. Replies
    2
    Views
    833

    Thanks Hans. That worked great.

    Thanks Hans. That worked great.
  5. Replies
    2
    Views
    833

    I very frequently open a csv file, manipulate it...

    I very frequently open a csv file, manipulate it a bit, and the save it under the same name, in a different directory, as an xls file. I want to have a macro that automatically does the saveas bit....
  6. Replies
    4
    Views
    3,787

    Pity, but your suggestion did give me a thought...

    Pity, but your suggestion did give me a thought about a possible work-around. In order to change the sheetname on one of the raw data sheets I would have to activate that sheet first. That means...
  7. Replies
    4
    Views
    3,787

    Thanks Hans. I'll try that. Just at a quick...

    Thanks Hans. I'll try that. Just at a quick glance though, it seems to alter the list when sheets are added or removed. Is there any event that would be triggered when a sheet is renamed?
  8. Replies
    4
    Views
    3,787

    I have a spreadsheet with many worksheets of...

    I have a spreadsheet with many worksheets of "raw" data. The first sheet extracts the data from (one of) the raw data sheets, in a different format. In A1 I type in the name of the raw data sheet...
  9. Re: Export from Quickbooks Pro 2006 into Excel 2003 (Excel 2003)

    An easier solution if you only want the raw data, is to use the Quickbooks Print/to file/csv file capability. Opening the csv file in Excel will then give you the data without the formatting.
  10. Replies
    2
    Views
    271

    Re: Save csv file as xls automatically (2003)

    Thanks. I'll try that.
  11. Replies
    2
    Views
    271

    Save csv file as xls automatically (2003)

    Hi
    I often read in a csv file, create a pivot table from the results, and then want to save the file as a .xls file. Unfortunately, the save button tries to re-save the file as a csv file, and I...
  12. Replies
    4
    Views
    658

    Re: auto reply to an excel message (2003)

    Thanks Hans.
  13. Replies
    4
    Views
    658

    Re: auto reply to an excel message (2003)

    Thanks Hans

    That will presumably "accept" the default reply on the message box. What if I wanted to do the "no" instead?
  14. Replies
    4
    Views
    658

    auto reply to an excel message (2003)

    Edited by HansV to replace Word document with the screenshot it contained - saves the reader a few clicks.

    I have a macro which opens a number of csv files and then copies them as sheets in a...
  15. Replies
    2
    Views
    274

    Re: error trapping dialogue boxes (2003)

    Thank you very much. Worked great.
  16. Replies
    2
    Views
    274

    error trapping dialogue boxes (2003)

    I have a macro which uses the getopenfilename dialogue. I want to be able to trap what happens if the user presses the cancel button.

    myfile = Application.GetOpenFilename("Comma...
  17. Replies
    10
    Views
    604

    Re: Display control (2007)

    Office 3007 - must be a really early beta release <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
  18. Replies
    5
    Views
    401

    Re: Norton internet secuirity 2006

    Not a very good combination if you're left-handed like me - trying to use press control, shift & escape all on the LHS of the keyboard is enough to dislocate something <img src=/S/ouch.gif border=0...
  19. Replies
    5
    Views
    484

    Re: Flaw in slew of Symantec products

    RAR files tend to be multimedia files downloaded from newsgroups, mostly probably inappropriate content. So if you are downloading RAR files you're probably bordering on unsafe browsing practises...
  20. Replies
    10
    Views
    439

    Re: IF STATEMENT (Excel 2000)

    Sounds like Alan is trying to get rid of some old coins <img src=/S/doze.gif border=0 alt=doze width=15 height=15> But what's the relevance of the 'roo??
  21. Replies
    11
    Views
    454

    Re: Selecting column (Excel XP (2002))

    Hi Hans
    I tried it on a very simple sheet. A1:A3 holds 1,2,3; B1=a1+1; double-clicking fill handle doesn't work.

    It works fine on most (all?) our other PCs, so it seems that there must be a...
  22. Replies
    11
    Views
    454

    Re: Selecting column (Excel XP (2002))

    Hi Steve
    Interesting coincidence. One of my users just came to me and asked why she could not do this. Double-clicking on her fill handle doesn't do anything. Any ideas?
    Thanks for your help.
  23. Replies
    6
    Views
    325

    Re: Pivot table problem (2000)

    Looks like they are trying to get a low estimate on projected enrollees. If that is so, then their version of the formula is correct. The "already enrolled" numbers are fixed, and they are...
  24. Replies
    9
    Views
    645

    Re: Reading A CSV File (XP:SP3)

    Could also be a problem with the system that the csv file is created on. PC/UNIX/MAC all use different end-of-record markers (e.g. PC uses CRLF) and I've run into problems trying to open a file...
  25. Re: Formula copy to another cell keeping same referenc (2000)

    Some time ago I saw a reference to ASAP utilities here in the lounge. Among lots of other nice goodies, they do have an option to copy formulas without changing their references.
Results 1 to 25 of 54
Page 1 of 3 1 2 3