Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Paul,
I didn't had problem with macro security before. I suggest you step(F8) trought your code with the locals window open and check the value of your variables and see if one woudl be changeg by something (...?). For info, what is you current degree of security ? Good luck Regards, JY "Paul Mac" wrote in message ... Hi Jean, I have tried: - Setting the wb Variable as you described - Using the Open FileDIalog.show (then . execute) - Just trying workbook.open all by its lonesome. All with no luck. It appears that as soon as the workbook is called, it stops the current code. I have constructed a workaround by using the Application.Ontime method and calling a sub-set of the code after the point where it stops. Any other ideas would be great. Paul. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I control what application opens a Hyperlink? | Excel Discussion (Misc queries) | |||
What is the application control menu | New Users to Excel | |||
Displaying MS Excel Chart control in ASP.NET Application | Charts and Charting in Excel | |||
macro to close excel application other than application.quit | Excel Programming | |||
Application.OnUndo Questions - Loses Prior Undo's and Runs 1x | Excel Programming |