Steve,
Thanks again for the reply. I was afraid to bother you too much.
I actually did try that:
Sub SaveScenAs
thisfile = ""
MIDrive = "C:\RedistDB\MB Tools\tabcall"
Commit Table log as
file_name = FileSaveAsDlg(MIDrive,thisfile,"tab","Save
As New")
note file_name
End Sub
That is when I get the error message "Expression does not evaluate to a
character string."
Any ideas?
Thanks
-----Original Message-----
From: Nabors, Steve [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 10:11 AM
To: Alan Gunn
Cc: [email protected]
Subject: RE: MI-L return value
Assuming you are picking the file in the dialog and clicking OK:
Put a
note file_name
in your code after the FileSaveasDGL command to see what it has stored.
You should see a popup with the file you chose in the dialog.
-----Original Message-----
From: Alan Gunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 9:52 AM
To: [email protected]
Subject: MI-L return value
Hello all,
When I run FileSaveasDlg the manual says that it returns a string value,
but
I can't seem to pull it. That line of code is
file_name = FileSaveAsDlg(MIDrive,thisfile,"mdb","Save As New")
With file_name declared as a string. When I do this, it says that the
function does not return a string value. Any helpful hints would be most
appreciated.
Thanks,
Alan
______________________________________________________________________
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.
______________________________________________________________________
This e-mail has been scanned by MCI/MessageLabs Managed Email Service.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16534
