+ Reply to Thread
Results 1 to 3 of 3

I keep getting error when trying to save.

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    I keep getting error when trying to save.

    I have this code

    HTML Code: 
    I keep getting a error and when I debut it highlights this line - .OLEObjects(sCOMBOBOX_PREFIX & i).Object.Value = vbNullString

    I have attached a sheet the VBA password is Kayley98 jippy.xlsm

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: I keep getting error when trying to save.

    I can't find where "wksLog" is set in your sub. And Excel will not call the error when it run the line of code :
    Please Login or Register  to view this content.
    but it will when you use .OLEObject within the WITH statement because wsklog is Empty.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: I keep getting error when trying to save.

    this code was given to me to clear combo boxes, can you help with that?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VB Save as PDF error
    By Kalb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2012, 07:22 PM
  2. [SOLVED] Save As error
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-06-2012, 09:55 AM
  3. Error in Save As
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2009, 04:28 PM
  4. Subscript out of range error - save copy error
    By bg18461 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2006, 11:53 AM

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