|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Hi Oliver,
I am experiencing the following issue:
- Searching for string within VBA macro code
- RM starts to process a SHARED workbook
- Console output locks up with last msg, "Updating VBA code in document"
- Windows unresponsive, ReplaceMagic at ~100% CPU usage
RM config:
Password to open doc.. = <blank>
Password to change doc.. = <blank>
Close convert file window.. = 1
Restart Office...= 500
Checkmark options = <unchecked>
When RM is in this state I access the network share that contains the shared workbook, open-unshare-save, however RM does not retry/recover from this. Only solution is to reboot. RM appears to be stuck in a loop.
I urgently need your assistance.
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi, can you send me file that caused problem? I will try to test it locally and to see what is making problem. You can use support@replacemagic.com address. Thanks, Oliver ReplaceMagic team
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Hi Oliver, unfortunately I am unable to send you the file due to confidentiality of content.
However RM also did not respond after VBA scanning a newly created excel file which had been saved as a shared workbook. I created this 'test' file to rule out any content. The fail occurred with or without macro code contained within workbook. It appears to be due to shared nature of file.
Can you test this to verify? Is there any configuration items I can adjust or debug/logging mode I can run?
I have tried this on 2 separate virtual machines and a physical, all running XPSP2 with Office 2K3SP2.
Thanks for your fast response,
J
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jim,
there is a list of things that can not be done when you have shared workbook and one of them is "changes in VBA".
We will try today to find a solution for that and our idea is:
- check is workbook shared
- if yes remove sharing
- make changes
- put back sharing
Can you tell me do you use only sharing or protect and share (plus tracking options)?
I hope that until the end of day we will have new version for you.
Best regards,
Oliver
ReplaceMagic team
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Hi Oliver, the situation is that I have to scan many (sometimes >1000) workbooks spread across many subdirectories. I do not own these workbooks and I do not have a person who knows ahead of time if they are shared or not. So disabling shared option before running RM is not an option for me.
I need RM to detect if the workbook is shared and skip past, not just hang. I also need this to apply to workbooks that for example have outdated links etc, basically anything that pops up as the workbook is opened and requires user intervention. If this is not possible then running RM as an automated "scan and report" tool without constant monitoring is not possible.
I look forward to your response.
Jim
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Oliver, apologies, I did not answer your question in my previous post. The sharing can be either pwd protected or not. There is a mix. Similarly, there could be workbooks that are pwd protected/read only, therefore prompt user when workbook is opened.
Is it possible to incorporate some form of watchdog timer to force termination on the thread that is "stalled" e.g. due to waiting on user input or due to project being protected, which would enable RM to proceed with scan?
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jimm,
thanks for information.
Of course that disabling sharing is not an option. Because if that we want to integrate auto unsharing and then later setting sharing back.
We can build that in case of shared workbook ReplaceMagic skips opened file.
Considering outdated link I think that ReplaceMagic will automatically close that notification popup if you use "Close convert window" options as you do.
As you will have different combinations of sharing (with password, without password,...) we will create that RM first checks is workbook shared, if it is it will try to remove sharing and if we can not do that (because of password) then RM will skip this file.
As soon as I have some results I will let you know.
Threads are unfortunatelly not possible because RM was build on technology that does not support them. We plan in future to switch RM to for example .Net and then we will integrate that everything goes over threads where we can control how thread is working (is it responsive or not).
This is plan for future but for now threading is not possible.
Best regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Thanks Oliver for your prompt response. With regards to the automatic handling of "updated links" popup, does
the "Close Convert File windows after sec" setting also handle ReadOnly password prompt windows and any user input popups when the workbook is opened?
I hope you do not mind me asking but what is the purpose of RMThreadKiller if the application does not handle thread monitoring/termination?
FYI, I have "Close Convert File windows after sec" set to 1 second.
When will you have a patch for me to test?
Thanks
Jim
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Thread killer application will try to close all opened windows where some user input is expected.
As RM does not support threading this is some kind of try how to force popup to be closed.
Thread killer will check window name and if it is in list of popup's that we found it will close it.
As we do not know all possible popup's that Office applications can send if you do not mind please send to us window titles and we will integrate them in "Thread killer".
I expect that you will get patch (or new version) later during this day. I can not promise that it will support Office 2007 but this will also come in next few days.
Regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jim,
one more question - are your files with XLS or some other extension?
Thanks,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Thanks Oliver, to answer your questions:
- I cannot tell you the popup window title as RM hides the excel process as a hidden/background process.
I have only had limited success in forcing process to the foreground by using explorer to browse for current
file (feedback from console) then opening this XLS file, then the popup appears.
However, this method is not reliable as implementation of RM would appear to take control of GDI and continue
to run CPU at high % even when "stalled" waiting for I/O. It is not always possible to force excel window to
foreground.
- I do not need Office 2K7 version at this time, only O2K3.
- All files with XLS extension.
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jim,
thanks for answers.
I tested with file that is password protected and also shared and RM will close password window so I do not expect any problems.
Also we managed to automatically unshare file, make changes and share it back. Of course, please do tests on your side later :).
Before 1h I managed to come in same position like you with 100% of CPU but now this bug is fixed (at least we did not get any problem).
In next 1h I will make test on Office 2007 and then I will send you link for new version.
Regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Thanks Oliver,
- Typical popup window that RMThreadKiller is not handling well is "VBAProject Password"
- As before I do not require O2K7, only O2K3
Great that you also see 100% CPU issue.
I look forward to the new app. Will my licence work with this?
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
jmce_999 wrote:Thanks Oliver,
- Typical popup window that RMThreadKiller is not handling well is "VBAProject Password"
- As before I do not require O2K7, only O2K3
Great that you also see 100% CPU issue.
I look forward to the new app. Will my licence work with this? In addition Oliver can you also add the following popup window title to RMThreadKiller lookup: - "Problems During Load" Thank you.
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Sure, I will add this.
Unfortunatelly I have again problem when I move sharing, make changes, put sharing back and save file.
On first look everything is ok but when I open next time file it is not any more shared.
I will need to investigate this a little bit deeper because this is totally strange as complete process worked before.
I am sorry for this delay.
For files where VBA Projects are password protected new version of RM will skip changes in that section but it will make changes in other parts of document.
Office 2007 will be covered.
Your license is valid :).
Regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jim,
before few seconds I sent email with details about new version.
Officially new version will come in next few days.
Best regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Thanks Oliver for sending the revised version. Did you get a chance to verify it works searching/changing macro code? I ran it last night and it found XLS workbooks but the console did not indicate that it checked the VBA code.
Normally I expect the console to output details of the first pass XLS search, then if macro code is found, a second pass with output to the console similar to:
• Updating links in <filename>.xls'.
• Updating VBA code in document...
• No update(s) in this file.
I am running v2.0.0 again on another set of workbooks to double check.
Thanks,
Jim
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
jmce_999 wrote:Thanks Oliver for sending the revised version. Did you get a chance to verify it works searching/changing macro code? I ran it last night and it found XLS workbooks but the console did not indicate that it checked the VBA code.
Normally I expect the console to output details of the first pass XLS search, then if macro code is found, a second pass with output to the console similar to:
• Updating links in <filename>.xls'.
• Updating VBA code in document...
• No update(s) in this file.
I am running v2.0.0 again on another set of workbooks to double check.
Thanks,
Jim Bug confirmed. The new version is indeed skipping past vba project that is password protected or workbook that is shared BUT it is also skipping past the scan of VBA code in unprotected/unshared workbooks. Can you verify?
|
|
Rank: Administration
Groups: Administration
Joined: 12/5/2006
Posts: 114
Points: 801
|
Hi Jim,
I just tested with few Excel files where I had something in VBA and I got correct results.
Here is example from my console:
Process started on: 01.02.2008 22:47:57
Search for: 'karina'
Replace with: 'jana'
Match case: 'Falsch'
Updating links in 'C:\1\vba\Book1.xls'.
Updating VBA Code in document...
File 'C:\1\vba\Book1.xls' is updated (3).
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
No update(s) in this file.
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Updating links in 'C:\1\vba\Book1.xlw'.
Updating VBA Code in document...
File 'C:\1\vba\Book1.xlw' is updated (3).
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
No update(s) in this file.
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Updating links in 'C:\1\vba\Book11.xls'.
Updating VBA Code in document...
File 'C:\1\vba\Book11.xls' is updated (3).
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
File 'C:\1\vba\Book11.xls' is updated (1).
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Updating links in 'C:\1\vba\Book2.xlw.xls'.
The file is currently unavailable.
Updating links in 'C:\1\vba\Tab9_AOC31.xls'.
Updating VBA Code in document...
No update(s) in this file.
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
File 'C:\1\vba\Tab9_AOC31.xls' is updated (1).
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Updating links in 'C:\1\vba\VBA Code Scripts.xls'.
Updating VBA Code in document...
File 'C:\1\vba\VBA Code Scripts.xls' is updated (30).
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
No update(s) in this file.
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Updating links in 'C:\1\vba\VBAPassword.xls'.
Updating VBA Code in document...
No update(s) in this file.
Updating hyperlinks...
No update(s) in this file.
Updating links to OLE objects...
No update(s) in this file.
Updating text in document...
File 'C:\1\vba\VBAPassword.xls' is updated (1).
Updating header in documents...
No update(s) in this file.
Updating footer in documents...
No update(s) in this file.
Updating comment in documents...
No update(s) in this file.
Process sucessfully finished on: 01.02.2008 22:48:11
Made: 42 changes.
Duration: 14 Seconds.
Some file were without protection, some were with shared workbooks, some with VBA protection.
As my test was ok, I have to say that I am confused.
Of course, I will test futher.
Best regards,
Oliver
Oliver
ReplaceMagic Support
|
|
Rank: Advanced Member
Groups: Member
Joined: 1/30/2008
Posts: 57
Points: 171
Location: Canada
|
Hi Oliver, here is my test process using version 2.0.0:
- create new excel file, New Microsoft Excel Worksheet.xls
- create 3 procedures, one in Sheet1, ThisWorkbook & Module1 e.g.
Sub module_test()
MsgBox "Change the following UNC - \\myserver1\myfolder1"
'\\myserver1\myfolder1
End Sub
- save without sharing or password protection at any level
- Select 'Search More' option in RM
- Only checkbox VBA
- add the following pairs:
myserver1->myserver2 ; myfolder1->myfolder2
Run this search/change and nothing happens.
The 'Search & Replace' option, where it is possible to search on a single entry, DOES work but it is not acceptable to then have to re-run every time with a new search argument.
Did you test 'Search More' option?
|
|
|
Guest |
