Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Newcastle UK
    Posts
    10

    Question Unanswered: [Solved] In need of some guidance and help :o)

    I'm looking to do something excel based for work as access isn't option (not available to low end users).

    I've got a spreadsheet formatted with several nice pages etc etc ... but what i want to do i because the file will be used by 70 or so users output to a csv file as i think it'll make export/import quicker ... is this the best option?

    -----------------------------------------------------------------------------------

    If so, i need to output to a shared drive where i would prefer the user has no input or 'need to know' where its been dumped i.e.:

    file1 filename = T:\Global Share Dir\Tracker\<date>\<application.username>-file1.csv

    Is it poss where the <date> dir doesnt exist to have the first exporter to create it?

    -----------------------------------------------------------------------------------

    I'll have loads more questions probs after these are answered so thanks in advance for any help...

    D
    Last edited by redma_d; 02-02-04 at 11:16.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Perhaps it would depend on who is importing/exporting, and I assume they all have Excel. I distribute files to about 80-100 people and use only Excel files. I have found the consistency is better than csv for importing/exporting (i.e. number formats as numbers not text, etc.). Personal opinion, not hard evidence, although the csv files will lose much of any formatting, and csv files can contain only one worksheet.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Location
    Newcastle UK
    Posts
    10

    Arrow

    I know what ya saying ...

    Current method is a non-standardised excel file which users print off and then someone manually collates em ... which i thought was ludacrous (i've only been in the job for a month or so) ... not only that but other paper forms being used

    What i was aiming for was a standardised file nothing huge, say about half a meg, but stored on the users home directory which when used outputs 4/5 csv's. The on a daily basis the collation spreadsheet imports all data by teams. So instead of 80 users x 500Kb xls, per day, i was thinking 80 x 2Kb csvs ...

    Main probs is i've never used vba to use csv's before so was researching but keep managing to screw up lol . Most of the data is standard numerical but there are some currency and text formatted numbers (8 digit order no.s some with multiple leading zeros) ....

    Can ya gimme any pointers or know any good sites i can peruse to borrow ideas ?

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    I have found excellent advice and help at this site:

    http://www.ozgrid.com/forum/
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Jan 2004
    Location
    Newcastle UK
    Posts
    10

    Talking

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •