Search:
Type: Posts; User: fubao
Search:
Search took 0.03 seconds.
-
OK, How about this. should be work
VBComp = wBK.VBProject.VBComponents(Excl_App.worksheets("sheet1").CodeName).Name = "SheetTrial1Sam"
-
Any stuff you want to do(eg. fill value, delete value, get value to use in your program)
You don't open any workbook yet, then , there won't be any active workbook, use this to open workbook
...
-
I didn't look into much detail, but now I do.
Base on my vb2010 code, not sure will work on 19, but I think it does.
=> Basically, the vba and vs code is the same, after you include reference....
-
I'm not sure, if two assign operator(=) in one line is prohibited.
so, try two seperate line
VBComp = "SheetTrial1Sam"
wBK.VBProject.VBComponents("Sheet1").Name = "SheetTrial1Sam"
-
Direct solution : If it is a report, user should see it after the report is generated successfully.
so, you should place oWord.Visible = True after 'do word stuff
edit : this is exactly what you...
-
OK, I remember it and will do that next times.
Thank you, Sir.
-
what you need to do is => try coding yourself, if facing problem, try fixing by yourself.
If can't then post to this forum.
I suggest using simple...
-
ีuhmm. Normally, If debug it in coding PC, it throws exception directly to where problem occurs. But this case, I test on another PC(which really use program but no IDE). So it just throw error but...
-
There is something here also, it seldom seem going wrong, but I don't really know what exactly it is now. But I use bad code but working for temporary solution now.
I am considering your both...
-
Sorry for late reply, I was struggling with another problem for couple of days.(excel.quit still got exce.exe, and some loop problem)
But they are solved now.
Absolutely, sir. This is exactly...
-
I don't even use Double datatype in my code, even though I assume it come from CDec function.
I set a condition to make the value in it to 0 when it is null (code not included), it still get error...
-
Sir, I feel like new kid at first, but now, I feel like an extremely new kid :bigyello::thumb: . I will go on with this.
I will stick to 2010 for some more so long.
However, Thank you for all...
-
Sorry, sir. I stuck so many other issue all day, when come to this my brain is likely dead, cannot figure out the test procedure can expose this.
As a beginner, after this I will be more considering...
-
-
I got
Textbox1_LostFocus
Textbox1.text = "10"
and
Button1_Click
Textbox1.text = (CDec(Textbox1.text) + 5).ToString("N2")
Assume I type 20 in textbox, Then I press the button
What will I...
|
Click Here to Expand Forum to Full Width
|