| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Workbook with Variable
I have been trying to figure out how to save or open a workbook using a
variable. I keep getting the error "Type-declaration character doesn't match declared data type". Here is an example of what i am trying to do: Dim y as string y = Range("A1") ChDir "G:the current directory\" & z& Workbooks.OpenText Filename:= _ "G:the current directory\" & z & "\" & y& |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving as variable file name | Excel Discussion (Misc queries) | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
| Saving Range Locatoin into a Variable | Excel Programming | |||
| Saving Range Locatoin into a Variable | Excel Programming | |||
| Saving Registry variable to ini file | Excel Programming | |||
Threaded Mode
