Import spreadsheet

[ryan_kos]

Hi, I am need to import an Excel spreadsheet into my data base. I do this with the Transfer Spreadsheet macro. My problem is that I receive this file monthly, and it must be saved with a different file name. Is there an easy way to ask the user to imput the file name, rather than modifying the macro every time I need to import the spreadsheet? Thanks.

 

[dgoulston]

the answer i think!

i have emailed u a form which does it!

hope its of use..


DAL

 

[luvthisboard!]

Hi any chance u cld share this with the rest of the world ! tks

a

 

[dgoulston]

ok remind me on monday and i will do it because its stored on me work computer

 

[luvthisboard!]

will do thanks !

 

[dgoulston]

ok here is the program, it is realy simplistic.

regards
DAL

 

[luvthisboard!]

Many thanks

.