prompting for filenames

[dave glynn]

Is it possible to have a macro prompt fro a filename. for example if data has
been copied from "oldfile" is it possible to have the macro ask which file it
now has to be copied to?

Many thanks

Dave

[Dave Peterson]

You could use something like:

Option Explicit
Sub testme()

Dim myFilename As Variant
myFilename = Application.GetSaveAsFilename

If myFilename = False Then
'user cancelled
Else
MsgBox "user selected: " & myFilename
'but you have to do the work--save or whatever
End If
End Sub

dave glynn wrote:
>
> Is it possible to have a macro prompt fro a filename. for example if data has
> been copied from "oldfile" is it possible to have the macro ask which file it
> now has to be copied to?
>
> Many thanks
>
> Dave

--

Dave Peterson

[dave glynn]

Thanks yet again!!

Kind regards

Dave

"Dave Peterson" wrote:

> You could use something like:
>
> Option Explicit
> Sub testme()
>
> Dim myFilename As Variant
> myFilename = Application.GetSaveAsFilename
>
> If myFilename = False Then
> 'user cancelled
> Else
> MsgBox "user selected: " & myFilename
> 'but you have to do the work--save or whatever
> End If
> End Sub
>
> dave glynn wrote:
> >
> > Is it possible to have a macro prompt fro a filename. for example if data has
> > been copied from "oldfile" is it possible to have the macro ask which file it
> > now has to be copied to?
> >
> > Many thanks
> >
> > Dave
>
> --
>
> Dave Peterson
>

[dave glynn]

I have a number of worksheets that are identical except that the workbook
name changes with each company.

Can I use the "real" name (i.e: sheet1) rather than the Excel (abcinc) name
when getting data for a group report. This would save an imense amount of
time as therer are 640 different sheets.

Thanks


Dave Glynn

[Anne Troy]

What kind of report, Dave? Can you explain?
Maybe this will help?
http://www.officearticles.com/excel/...worksheets.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"dave glynn" <daveglynn@discussions.microsoft.com> wrote in message
news:90818B69-F890-436D-B90F-9A2E37E07625@microsoft.com...
>I have a number of worksheets that are identical except that the workbook
> name changes with each company.
>
> Can I use the "real" name (i.e: sheet1) rather than the Excel (abcinc)
> name
> when getting data for a group report. This would save an imense amount of
> time as therer are 640 different sheets.
>
> Thanks
>
>
> Dave Glynn
>
>

[David McRitchie]

I'm not sure of what you want, but you can probably find something on
my page on sheets, along with coding.

here are actually three ways of addressing the sheet.
sheet1
'sheet1'
sheet(1)

For more information on addressing sheets see
http://www.mvps.org/dmcritchie/excel/sheets.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dave glynn" <daveglynn@discussions.microsoft.com> wrote in message news:90818B69-F890-436D-B90F-9A2E37E07625@microsoft.com...
> I have a number of worksheets that are identical except that the workbook
> name changes with each company.
>
> Can I use the "real" name (i.e: sheet1) rather than the Excel (abcinc) name
> when getting data for a group report. This would save an imense amount of
> time as therer are 640 different sheets.
>
> Thanks
>
>
> Dave Glynn
>
>

[dave glynn]

it seems that i can no longer post new questions as the message box doesn't
appear when i click on "new" so i have to go to an old question to post a new
onw . any thoughts.

thanks again


dave

[Jim Cone]

dave,

Give Outlook Express a try, here's how...
http://www.tushar-mehta.com/misc_tut.../3_set_up.html

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"dave glynn" <daveglynn@discussions.microsoft.com>
wrote in message...
it seems that i can no longer post new questions as the message box doesn't
appear when i click on "new" so i have to go to an old question to post a new
onw . any thoughts.
thanks again
dave