+ Reply to Thread
Results 1 to 4 of 4

VBA coad mantained in workbook is not working when open same work book in openoffice

Hybrid View

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    4

    VBA coad mantained in workbook is not working when open same work book in openoffice

    VBA coade not working in Openoffice
    Dear Sir,
    I have written below Coad to close my work book when I am not working on it
    But when Iam opening this workbook in open office it is not working
    At the same time it is working in excel
    This workbook
    Private Sub Workbook_Open()
    MsgBox "This workbook will auto-close after 20 seconds of inactivity"
    Call SetTime
    End Sub
    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Call Disable
    End Sub
    Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    Call Disable
    Call SetTime
    End Sub
    Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target _
    As Excel.Range)
    Call Disable
    Call SetTime
    End Sub
    Module1
    Dim DownTime As Date
    Sub SetTime()
    DownTime = Now + TimeValue("00:00:30")
    Application.OnTime DownTime, "ShutDown"
    End Sub

    Sub ShutDown()
    ThisWorkbook.Save
    ThisWorkbook.Close
    End Sub
    Sub Disable()
    On Error Resume Next
    Application.OnTime EarliestTime:=DownTime, Procedure:="ShutDown", _
    Schedule:=False
    End Sub

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,362

    Re: VBA coad mantained in workbook is not working when open same work book in openoffice

    Hi Sandeep,

    Let me try to understand what you are trying to do.

    1. You open an Excel workbook and are running code in that workbook.
    2. The code stops running but the workbook is open? Or is it closed?
    3. Then you try to open this Excel file, that is running?, with Open Office and it doesn't open?

    I guess I'm confused on what the question is.

    Also, Edit your post above and select the code and click on the "#" icon above the message area to put you code in tags.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-03-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA coad mantained in workbook is not working when open same work book in openoffice

    Dear Sir,

    i am sharing this workbook with some other user
    some of them have exl and some of them open office.

    when i am open this workbook in excel it save and close when it is not active more then 30 second.
    after this when another user same workbook is open in open office it not close after 30 second if sheet is not active.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,362

    Re: VBA coad mantained in workbook is not working when open same work book in openoffice

    Hi Sandeep,

    I wouldn't expect Open Office and Microsoft to be completely compatible. I found a thread that might give some help at:
    https://forum.openoffice.org/en/foru...ic.php?t=31097 and
    http://www.pcworld.com/article/20785...atibility.html

    I just talked to a Microsoft executive who suggests it might be a bug in Open Office.
    Last edited by MarvinP; 02-28-2015 at 02:11 AM.

+ 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. Help Copying Range from an open workbook to an array in the Active work book
    By Aussiexile in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-04-2014, 09:47 PM
  2. Replies: 0
    Last Post: 06-12-2013, 09:05 AM
  3. how to get excel to open a work book
    By Wade LEES in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2009, 04:58 AM
  4. Work Book Open
    By newbie13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2008, 05:51 AM
  5. open work book
    By nowfal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2005, 06:42 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