| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing a Word doc to Excel
I have a macro that allows a user to pick Word document
file from a list(as a text file), formats the columns and adds a header then saves the file as an Excel document. The file opens in one drive and saves in another. The problem I have is that the file still has the .doc in the filename and saves as a .doc file not Excel (even if Microsoft office Excel Workbook is used as in filesavename = Application.GetSaveAsFilename( _ fileFilter:="microsoft office excel workbook Files (*.xls), *.xls") How do I take out the .doc from the filename? This is done in Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a word document into an excel spreadsheet | Excel Discussion (Misc queries) | |||
| how do i merge numbers from excel to word without them changing | Excel Discussion (Misc queries) | |||
| Excel should have case changing menu items like Word. | Excel Worksheet Functions | |||
| Changing word case in Excel doc | Excel Discussion (Misc queries) | |||
| How to convert word doc to excel w/o changing format to add formu. | Excel Discussion (Misc queries) | |||
Threaded Mode
