Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set workbook name not working
Hi
I am trying to set the workbookname in a sub procedure but it is not working. Her are the part from my code that is not working: Private Sub Start_Click() Dim MalWb as workbook Dim MalTxt as String Set MalWb = Workbooks(ActiveWorkbook.Name) MalTxt = ActiveWorkbook.Name ' Here I have som code to put data into MalWb Call ReskontroArk("Kunder", MalTxt) End Sub Private Sub ReskontroArk(ReskontroType, MalTxt As Variant) Dim MalWb As Workbook Set MalWb = Workbooks(MalTxt) ' run time error 1004. Canot find file End Sub Can someone see what I have done wrong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with worksheets in the same workbook | Excel Worksheet Functions | |||
Pasting from another workbook was working and now is not | Excel Discussion (Misc queries) | |||
workbook linking cells not working within a workbook | Excel Discussion (Misc queries) | |||
Working with Workbook array | Excel Programming | |||
Working within a workbook without activating it? | Excel Programming |