Results 1 to 3 of 3

Macro issues

  1. #1
    NoelBlakley is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2018
    Posts
    2

    Macro issues

    Hello,



    I have converted some excel MACRO's to work in CALC but running in to some issuesSheet = ThisComponent.Sheets.getByName("somesheetname").Wh ile this code works when stepping through the code with F8 ... if I save and open my ods file I get an error for each cell that calls the function containing this object??? OpenOffice 4.1.1 BASIC runtime error ... property or method not found: sheets.This error occurs for each cell calling the function and provides no way to ignore all.There doesn't appear to be a way to turn off auto calc when calc opens ... excel has a shift F9 function to force a recalc of a sheet.Am I missing something?

    Please help.


    I didn't find the right solution from the Internet.


    References:-
    https://forum.openoffice.org/en/foru...p?f=20&t=77319


    Thanks

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    649
    what is CALC? This is the access forum, sounds like you need excel or open office help.
    Patience serves as a protection against wrongs as clothes do against cold.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,424
    Quote Originally Posted by Perceptus View Post
    what is CALC? This is the access forum, sounds like you need excel or open office help.
    Did you follow the link? It seems to be BASIC or some form of it - in a type of open programming platform. There are also answers/suggestions there for this issue, which leads me to think it is the better forum to handle this.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    So, like, why do you, like, start a sentence with, like, "so"?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 01-20-2017, 01:21 PM
  2. Access - Macro Issues
    By PrettyMess in forum Access
    Replies: 4
    Last Post: 02-10-2016, 06:56 AM
  3. Replies: 1
    Last Post: 01-13-2015, 12:33 PM
  4. Macro having issues when run on Windows Scheduler
    By faeren in forum Programming
    Replies: 4
    Last Post: 09-15-2011, 08:59 AM
  5. Replies: 0
    Last Post: 01-12-2011, 11:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums