Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code, I wrote.
I am not very confortable with VBA, so I have a problem. When it arrives at the last line it gives an error. Run-time error, 91 : €œvariable not set€. I cant understand why. Dim UlinDez, UlinMovOr, UlinCarOr, UlinMovFn, UlinCarFn As String Dim wbDez As Workbook Dim wbMov As Workbook Dim WbCar As Workbook Dim FicDez, FicMov, FicCar As String Dim Emp, Mes As String FicDez = Application.GetOpenFilename FicMov = Application.GetOpenFilename FicCar = Application.GetOpenFilename Mes = Application.InputBox("Indicar o mês") Workbooks.OpenText Filename:=FicDez _ , Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, Semicolon:=True, FieldInfo:=Array(Array(1, 1), _ Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), _ Array(9, 1), Array(10, 1)), TrailingMinusNumbers:=True wbDez = ActiveWorkbook.Name |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Getting inconsistent Error 91-Object variable or With block variable not set | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |