Re: Auto file naming

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


An easy way to learn is to record a macro while doing the save. Then clean up and modify to change the name to your string

mystring=range("a1") & " - " & range("b1")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Jacquesvv" <Jacquesvv@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:50C094DD-01EA-48FD-9CDB-ED0EA07C5DA3@xxxxxxxxxxxxxxxx
Hi There

Is it possible to automatically name a file based on two cell entries when
saving.

E.G

A1 B1
20090623 ZVN462A

I need the filename to be 20090623 - ZVN462A and this must be automatically
done.

Thanx in advance

.

Relevant Pages

  • Re: trim, chr(10)
    ... (leave blank or a space character if you want) ... Add this recorded code to the top of your existing macro that trims the values. ... I'm trying to clean out some extra spaces in my data. ... Dim v As String, val As Double ...
    (microsoft.public.excel.programming)
  • Compile-time text/string manipulation
    ... A "compile-time language" is one that processes ... Compile time languages for assemblers ... This group includes macro ... requires access to various string and text manipulation ...
    (alt.lang.asm)
  • RE: Search email for text string to use in filename - save email t
    ... The code for my macro is below. ... .MatchWholeWord = False ... Dim sNewFileName As String ... > 0 Then Exit Function ...
    (microsoft.public.outlook.program_vba)
  • Re: Iding tabs that contain #REF!s
    ... The code I sent you just a little while ago does not seem to work correctly; try this macro instead... ... Sub Findrefs() ... Dim WS As Worksheet, Res As String, TempArrayAs String ... I just had those sheets hidden, but your suggested fix now looks at only the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Document Property to display more than 1 line
    ... then use the following macro to identify the character ... Dim strNums As String ...
    (microsoft.public.word.newusers)