Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File name trauma.
Thanks in advance for any help.
I'm creating a macro that captures a cell value and assigns it as a File name. That is no problem. What I'm having difficultly with is that I need to create a loop, which takes the file name, and amends it by adding a "+" to the end of it, each time through the loop. So the first time would be "filename+" the second "filename++". Hope that makes sense. Here's what I've been playing with so far Sub test() Dim CountZones As Integer Dim i As Long Dim z As Long Dim Fname As String Dim Rng As Range Dim Sym As String Sheet4.Activate Range("b1:z1").Select CountZones = Application.CountA(Selection) Selection.Resize(1, CountZones - 1).Select Fname = Range("a1").Value For Each Rng In Selection ' Counts times through the loop i = i + 1 Sym = "+" ' probably redunant but was going to increase the number of "Sym" counts with this. z = z + 1 Fname = Fname & Sym Next end sub I'm probably missing something simple and having a brain f@rt ;)) Thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |