Search:

Type: Posts; User: fubao

Search: Search took 0.03 seconds.

  1. Re: Error : System.InvalidCastException: 'Conversion from string "Sheet1" to type 'In

    OK, How about this. should be work

    VBComp = wBK.VBProject.VBComponents(Excl_App.worksheets("sheet1").CodeName).Name = "SheetTrial1Sam"
  2. Re: Closing Generated MS Word Doc causes error 'Call was rejected by callee'

    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
    ...
  3. Re: Error : System.InvalidCastException: 'Conversion from string "Sheet1" to type 'In

    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....
  4. Re: Error : System.InvalidCastException: 'Conversion from string "Sheet1" to type 'In

    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"
  5. Re: Closing Generated MS Word Doc causes error 'Call was rejected by callee'

    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...
  6. VS 2010 Re: conversion from string " " to type 'Double' is not valid

    OK, I remember it and will do that next times.
    Thank you, Sir.
  7. VS 2010 Re: HOW TO READ ALL DATA FROM weight scale INTO TEXTBOX visual basic 2010

    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...
  8. VS 2010 Re: conversion from string " " to type 'Double' is not valid

    ี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...
  9. VS 2010 Re: conversion from string " " to type 'Double' is not valid

    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...
  10. VS 2010 Re: conversion from string " " to type 'Double' is not valid

    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...
  11. VS 2010 [RESOLVED] conversion from string " " to type 'Double' is not valid

    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...
  12. VS 2010 Re: two events occur in the same time which will occur first

    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...
  13. VS 2010 Re: two events occur in the same time which will occur first

    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...
  14. VS 2010 Re: two events occur in the same time which will occur first

    Thank you so much, sir !
  15. VS 2010 [RESOLVED] two events occur in the same time which will occur first

    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...
Results 1 to 15 of 15



Click Here to Expand Forum to Full Width