| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a file with variables
well, i was close!
:) susan John Bundy (remove) wrote: You need to take quotes out of this FName = "MyPath&MyFile" like FName = MyPath & MyFile -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "timmulla" wrote: Can anyone help me with the following code. I'm having trouble setting the FName variable using two other variables (MyPath and MyFile. MyPath variable "C:\Documents and Settings\tmullady\Desktop\" MyFile Variable contents in cell B3 in my spreadsheet The end result should be the FName variable should create the proper file path. Public Sub Testing() Dim MyFile As String MyFile = Cells(3, 2).Text Dim MyPath As String MyPath = "C:\Documents and Settings\tmullady\Desktop\" Dim FName As String Dim FNum As Integer Dim Rng As Range FName = "MyPath&MyFile" FNum = FreeFile Open FName For Output Access Write As #FNum Print #FNum, Range("B3").Text For Each Rng In Range("B5:B10") Print #FNum, Rng.Text Next Rng Close #FNum End Sub Any help would be appreciated -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting a file with variables | Excel Programming | |||
| Need help with setting variables | Excel Programming | |||
| Setting several variables at the same time | Excel Programming | |||
| Setting Public Variables Error | Excel Programming | |||
| Setting variables to Nothing | Excel Programming | |||
Threaded Mode
