Results 1 to 4 of 4

object doesn't support this property or method

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question object doesn't support this property or method


    I want to write the data without opening the excel file, but when i try to get the columns and rows, "object doesn't support this property or method"
    I want use to TR and TC to find and locate the rows and columns, but error from there, any idea?

    Application.ShowWindowsInTaskbar = False
    Workbooks.Open (ThisWorkbook.Path & Application.PathSeparator & "WSO_Record.xls")
    ThisWorkbook.Activate
    Application.ScreenUpdating = False
    With Workbooks("WSO_Record.xls")
    TR = Application.Match("Work ID", .Rows(1), 0)
    TC = Application.Match("P12", .Columns(1), 0)
    .Sheets("Record").Cells(TC, TR) = ThisWorkbook.Worksheets("Sheet1").Range("A1")
    .Save
    .Close
    End With
    Application.ShowWindowsInTaskbar = True
    Application.ScreenUpdating = True
    Write to WSO.zip



    Moderator's Note: Welcome to the forum, you have to put code tags around codes. Select the code then hit the "#". I'll do it for now. Thank you.
    Last edited by vlady; 01-16-2013 at 01:52 AM. Reason: code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1