Search Results - VBForums

Search:

Type: Posts; User: westconn1

Page 1 of 13 1 2 3 4

Search: Search took 0.39 seconds; generated 2 minute(s) ago.

  1. Re: Incorrect Starting Range Index using Word Object

    show what code you are using and post a sample document
  2. Re: [Excel] CSV extraction, with a catch or several

    post a sample of .csv
  3. MsOf10 Re: VB IF statement not evaluating "True" when passed as a string

    if you use code tags when posting code, indenting will show in the post

    it would be better to use a select case statement instead of all the elseif s

    your strip function leaves a leading space,...
  4. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    the code all look correct, except the last 3 lines should be in opposite order, though it may not make any difference, selecting a worksheet is not required

    what does happen, is there an...
  5. Re: [Outlook] How to get user info (name) using userID#

    sorry i have no access to a global list as i am not on a domain here, probably why i was not sure about the ID
    contactlist items, in my outlook, have no id field, that i am aware of
  6. Re: [Outlook] How to get user info (name) using userID#

    does this mean you need to look in all the stored emails?

    if you create a new (non-existant) recipient they still have an ID, so i have no idea what the ID relates to, if anything

    to look at...
  7. Replies
    13
    Views
    749

    Re: Outlook Automation

    how is AutoReplywithTemplate called?
    there is nothing in the code that indicates if an event calls the code

    you can use application newmail event to check if it receive item is from specific...
  8. Re: [vb6] How to insert a tabspace in Word Object?

    did you try replacing vbtab with ^t ?
  9. Replies
    4
    Views
    111

    Re: run query via batch or shell

    you could write and shell a .VBS
  10. MsOf10 Re: Populating a combo box in a word document form using an array

    what if you use html email body they can complete in the reply? or a link to an online form? leave word right out of the mix

    when using a document template, you should add a new document based on...
  11. Replies
    9
    Views
    220

    Re: ADO mixed data

    a working example

    Sql = "select * from[sheet5$] as s5"
    rs2.Open Sql, cn, adOpenStatic, adLockReadOnly
    Sheets("sheet1").Range("i1").CopyFromRecordset rs2
  12. Re: Hello VBForums. Need to ask a question about dual monitor in vb?

    http://www.vbforums.com/showthread.php?p=3644600#post3644600
    there is some information here too
  13. Replies
    9
    Views
    220

    Re: ADO mixed data

    from http://support.microsoft.com/kb/257819#RetrieveExcel
    imex = 1 seems to work, as specified, on readonly recordsets
  14. MsOf10 Re: [Excel]How to save a WB w/o losing format.

    do the borders save?
  15. MsOf07 Re: How to search values in external workbook and pull out information from the same

    try like

    For Each ws In ActiveWorkbook.Worksheets
    checknom = Mid(ws.name, 1, 3)
    If IsNumeric(checknom) = True Then
    Set gCell = ws.range("f:f").find(numdoc)
    if not gcell is nothing then...
  16. MsOf10 Re: [Excel]How to save a WB w/o losing format.

    in most cases, you should try avoid selecting or activating anything

    try

    Rows("1:9").Delete Shift:=xlUp

    'and

    with Range("A1:I1000")
    .Borders(xlDiagonalDown).LineStyle = xlNone
  17. Re: Error : Microsoft Office Excel cannot open or save any more documents

    in xp, excel does not always work too well with more memory

    this does not apply to later win versions

    as pointed out earlier, filename variable does not appear to have an value, possibly fn is...
  18. Re: range.Find inside of function always returning 'Nothing'

    post a sample workbook that demonstrates the problem
  19. Replies
    50
    Views
    12,355

    Re: [RESOLVED] Macro to Print excel sheet to PDF.

    try like

    invtitle = array("Original for Buyer", "Duplicate for seller", "Transporters copy")
    for i = 0 to 2
    range("g3").value = invtitle(i) ' change range to position title to suit
    ...
  20. Replies
    1
    Views
    220

    Re: Copy webcontent to a document

    try pastespecial
  21. Re: vba excel run-time error 1004 Application-defined or object-defined error

    for any assistance, you would probably need to show the preceding code
  22. Re: Connecting to Excel 2010 with VB 6 lates service pack error

    as excel 9.0 refers to excel 2000, i guess this could be the problem

    maybe the desktop had an earlier version of excel installed previously, allowing it to still work
    see what versions are...
  23. Replies
    4
    Views
    555

    Re: Im a rookie- simple help!

    try like

    Set fso = CreateObject("scripting.filesystemobject")
    Set mydocs = fso.getfolder("c:\my documents")
    For Each fol In mydocs.subfolders
    Debug.Print fol.Name, fol.Size;...
  24. MsOf10 Re: Populating a combo box in a word document form using an array

    have you considered pdf forms, just about everyone has a pdf viewer, that can fill forms, or even an online web form, hard to mess with those

    how about using masked edit boxes, at least it would...
  25. Re: Works with Left Button But Not Right Button

    i think you still need to send leftbutton to the window, even if it is your right button click
  26. MsOf10 Re: Populating a combo box in a word document form using an array

    there could be several methods
    can you get the information from your oultook contacts?
    put the list in a separate text file, where you can just add to the bottom of the list without editing your...
  27. Replies
    14
    Views
    980

    Re: SAVING ALGORITHM in VB

    i ran the code as posted, it appeared to need no additional inputs, the output i got
    the inputs used appear to be
    do the outputs appear to be correct for the inputs above?
    what values are the...
  28. MsOf10 Re: Access Force two text boxes to always equal 100 percent

    put a label at end of textbox for % character?

    i tested. added a userform with 2 textboxes

    Private Sub textbox1_AfterUpdate()
    If IsNumeric(TextBox1.Value) Then
    TextBox2.Value = 100 -...
  29. Thread: Macro Help

    by westconn1
    Replies
    15
    Views
    926

    Re: Macro Help

    afaik you cannot return the filename or file object from the saveas statement
    though it does not error if the parameters are enclosed in brackets

    the error is, an extra & after objmsg.saveAs
    ...
  30. Re: Combining two Worksheet_SelectionChange

    try like


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim targetRange As Range, selectedRange As Range, col As Range
    Set targetRange = Range("C6:C9")
    Set selectedRange =...
  31. MsOf10 Re: Access Force two text boxes to always equal 100 percent

    try like
    Me.LADay10s.Value = 100 - val(Me.LANight10s.Value) & "%"
  32. Thread: Macro Help

    by westconn1
    Replies
    15
    Views
    926

    Re: Macro Help

    maybe i could, if i could read anything from the image
  33. Replies
    14
    Views
    1,055

    Re: Start of line and end of line problem

    you have done enough posts here, to know to use code tags when posting code

    post a sample document that we can use to test your code with
    including which parts are supposed to be moved to other...
  34. Replies
    9
    Views
    626

    Re: Overwrite existing folder

    i posted that already in your other thread
  35. Replies
    4
    Views
    508

    Re: no permit save or save as workbook

    there may also be issues on closing the workbook without saving, to avoid that you can put

    thisworkbook.saved = true

    in the workbook before_close event
  36. Replies
    4
    Views
    508

    Re: no permit save or save as workbook

    in the workbook_beforesave event

    cancel = true
  37. Re: [SOLVED] Select cell with greatest value in user-defined range

    thnx anyway
  38. Replies
    14
    Views
    1,055

    Re: Start of line and end of line problem

    maybe you look for 3 ^p together to find 2 empty lines, first at end text, next two in empty lines?

    i think those line breaks will be ^l rather than ^p
  39. Replies
    9
    Views
    626

    Re: Overwrite existing folder

    @ techgnome

    both vb functions and fso can work with space in paths
    shell which uses dos commands is the main area with problems of this type
  40. Re: Select cell with greatest value in user-defined range

    nothing wrong with that i can see, i just tried to build into existing loop
Results 1 to 40 of 498
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.