|
|
I've been given a project to run/update a spreadsheet using VBA/Excel. When I try to run the macros I keep getting the following erro:
Run-time error '91':
Object variable or With Bock cariable not set
I have no idea what to do and I have not used VBA!
Here is where the trouble starts**:
Ensure all Active projects are in the "All" Sheet
With g_wksIOProjects
**For lngRow = 2 To .UsedRange.Rows.Count
If .Cells(lngRow, 28).Value = "COMMITTED" And _
.Cells(lngRow, 5).Value <> "Execution (PEM) - On hold" Then
If InSheet(g_wksALL, 2, .Cells(lngRow, 1).Value) = False Then
Call WriteMessage("Committed project missing from 'All', " & _
.Cells(lngRow, 1).Value & ": " & .Cells(lngRow, 3).Value, Mess.Critical)
End If
End If
If .Cells(lngRow, 28).Value <> "COMMITTED" And _
.Cells(lngRow, 28).Value <> "CANCELLED" And _
.Cells(lngRow, 28).Value <> "CLOSE" And _
.Cells(lngRow, 28).Value <> "NOT SUBMITTED" And _
.Cells(lngRow, 14).Value > 50 Then
If InSheet(g_wksALL, 2, .Cells(lngRow, 1).Value) = False Then
Call WriteMessage("Project with significant recorded effort missing from 'All', " & _
.Cells(lngRow, 1).Value & ": " & .Cells(lngRow, 3).Value & _
", Hours = " & .Cells(lngRow, 14).Value, Mess.Critical)
End If
End If
Next lngRow
End With
|
|
|
|
|
Sounds like .UsedRange.Rows.Count is not set when you run your code.
Do you need to select your range first?
|
|
|
|
|
What is the Worksheet name you are referencing?
With ActiveSheet
For lngRow = 2 To .UsedRange.Rows.Count
....
Next
End With
Try this with the workseet active.
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
Is there a big difference between vb6 and vb.net as far as coding and design?
|
|
|
|
|
You simply can not compare them...
The only resemblance is the sintaxe every thing else is completly diferent
Sérgio Lima
Many people would sooner die than think; In fact, they do so.
- Bertrand Russell
|
|
|
|
|
|
There are differences between VB6 and VB.NET. VB6 has been dead, and unsupported by Microsoft since about March 2005. VB.NET is more closer to be really object oriented than VB6.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
VB6 is a muddled mess of a language which is saddled with oodles of quirks which were designed to make it somewhat compatible with QuickBasic and QBASIC, which were in turn designed to be compatible with the original IBM PC Cassette BASIC. Although it "looks" object-oriented, it lacks features like inheritance which are necessary to make real object-oriented programming possible. Further, as a result of its Cassette BASIC roots, many object methods have strange and bizarre variations in syntax which cannot be mimicked with user-defined functions. For example, to draw a box on the printer,
Printer.Line(10,10)-(20,20),0,BF
The use of two coordinate pairs, separated by a dash, and the use of the literal characters "BF" (block fill) without any string delimiter, are both perfectly fine syntax in an interpreted language (like Cassette Basic). They're not really any harder to parse than would be "LINE 10,10,20,20,0,2" (the "3" being "BF") and they're easier to read, but syntax line that makes it impossible to create a function that behaves like the "Line" function.
|
|
|
|
|
|
The only similarities are that they both have "Visual Basic" in the title and the message box function is MsgBox() in both.
|
|
|
|
|
The JZ wrote: and the message box function is MsgBox() in both
Actually, the message box method in .NET is MessageBox.Show. The MsgBox method in VB.NET is just a wrapper for the MessageBox.Show method.
Also, it's far from the only VB 6 leftover. VB.NET has a lot of wrappers with the same name as the VB 6 functions, that call the corresponding .NET method.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Like Charlie Brown, all I can say is "Good Grief!"
|
|
|
|
|
I think he gets the point!
|
|
|
|
|
hi jds1207
When i heard there was vb.net, i was in vb6, and i thought, no am happy here at vb6, and i was so Stuborn and never wanted to Listen when they told me about vb.net, One day i had a problem in my code and i post a thread in a forum and i wrote something like " i have problem inserting records in vb", well the person who answered me, thought i was using vb.net and he posted an example code of vb.net, am telling you it was Completely different and made sense than my vb6 code. Initialy i thought i was going to learn there and there and grasp the language, but i was lying to myself, i had to start learning the Language from Scratch , and till today i dont see vb6 come Closer to vb.net. The Syntex might look alike but they are Completely Different.
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Nevertheless, the transition from VB6 to VB.NET is easier than from being a non-programmer to VB6.
|
|
|
|
|
you are Very Correct
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
To start off their is no comparison
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
In my DataGridView I have a column displaying date and two columns displaying time (begin/end).
For the date column I set CellStyle format=d, so users can only enter proper dates and it works fine, but I don't seem to get it working for the time-columns. Time should be formatted HH:mm, but when setting format=t users still are able to enter into the time-columns whatever they want.
Solution anybody?
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
how about format = HH:mm:ss
don't know for shure but I seem to remeber having a simular problem and that fixed it (I think)
|
|
|
|
|
I tried "HH:mm" before, but no success.
-edit-
Thanks, found the error. The column in my datatable, which was bound to datagridview, had the datatype string instead of datetime.
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
modified on Thursday, July 3, 2008 6:10 AM
|
|
|
|
|
Hi
I added a control named Shockwave flash object from com object to my toolbox but when i drag it to my form it gives error that:
Failed to import ActiveX control, Please ensure that it is properly registred.
Can any one give me the right way to do it
Thanks
Unless u don't give ur hundred percent whatever u r doning till there is no result of ur work...
|
|
|
|
|
Find another activeX control that is better than what you are currently using. Their may be a compatability issue with using it in Visual Studio. Or if you can use WPF, convert the flash object to XAML.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
Thanks 4 reply
But sorry! i din't get it
Their may be a compatability issue with using it in Visual Studio. Or if you can use WPF, convert the flash object to XAML.
Unless u don't give ur hundred percent whatever u r doning till there is no result of ur work...
|
|
|
|
|
If the designer for visual studio crashes or does not allow the activeX control to be added to a form, then their is a problem. The problem is most likely because of an incompatability between the activeX control and either visual studio or the .NET framework. To fix the problem, ditch the control and find a replacement. You can either find an activeX control that works or you can use the Windows Presentation Foundation (of .NET 3.0). To use WPF you would have to convert the flash file to XAML.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|