Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Within Excel 2000 i used the getsaveasfilename option and
created the filename from Text and Strings. The text contained the word "Homepages" and this does not seem to work in 2002 but did in 2000. Any ideas ? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This worked ok for me in xl2002 and win98:
Option Explicit Sub testme02() Dim myString As String Dim myFileName As Variant myString = "asdf homepages qwer.xls" myFileName = Application.GetSaveAsFilename _ (InitialFileName:="C:\my documents\exce\" & myString) If myFileName = False Then Exit Sub End If ThisWorkbook.SaveAs Filename:=myFileName End Sub You may want to post that snippet of code (not the workbook) that's causing heartburn. Kevin May wrote: Within Excel 2000 i used the getsaveasfilename option and created the filename from Text and Strings. The text contained the word "Homepages" and this does not seem to work in 2002 but did in 2000. Any ideas ? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with getsaveasfilename | Excel Discussion (Misc queries) | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
GetSaveAsFilename not working in Excel 2003 | Excel Discussion (Misc queries) | |||
GetSaveAsFilename method | Excel Programming | |||
File save location with Application.GetSaveAsFilename | Excel Programming |