Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question of Import Export Files
Hiyee all,
Until this stage, I'm still considering a newbie in VBA althoug I can deal with certain userform and some codes. Anyway, I got a question.... a very basic question for export an import files. I'm not that understand and don't know much about th codes that can do so. My problem is, I created 1 user form, get users entries and th entries will then placed into excel spreadsheet respectively. Afte that, I would want to save the spreadsheet to a text file, or wor file. How can I do tat? 1) How the coding is if we export the data in spreadsheet to notepad ? 2) Can we specify a file name for it? 3) After we saved the file to notepad, where the file will gone? I which location? 4) Can we auto specify a file name for the file? For example, m spreadsheet will capture user's computer login(network), and he wil made entries inside. After that, if he run the macro, it will save hi file using his login name. 5) About the code that capture user's login name in networ, I saw thread discuss about this topic yesterday, and I can't find the threa now... Can anyone tell me where is the thread is? Thanks a lot.... Hope it wont take ur time to answer my noo Question... :< Hope to hear from u all soon... -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import/export netCDF files to Excel | Excel Discussion (Misc queries) | |||
Import & Export | Excel Discussion (Misc queries) | |||
Import/Export | Excel Discussion (Misc queries) | |||
Automate Import/Export | Excel Discussion (Misc queries) | |||
Import and Export | Excel Programming |