Macro Scheduler Forums

fightcancer

JRL wrote: ↑
Tue Mar 27, 2007 1:15 pm
Check out the Assigned> function.

Thanks for this!

fightcancer

Where can I read more about iframes in an IE window please?

fightcancer

wood.john.david wrote: ↑
Sat Mar 12, 2016 6:22 pm
Attached are some routines....

Where are the attachments please? I'm not seeing them.

fightcancer

I haven't. Good idea.

fightcancer

FYI, XLRun doesn't work as intended when there are spaces in the macro name.

Does Not Work:
XLRun>xlBook,Excel Addin Macros.xlam!test3

Does Work:
XLRun>xlBook,ExcelAddinMacros.xlam!test3

(This test used 2 different MS Excel Addin files with the filenames above.)

fightcancer

An "Online Repair" of Office 365 (in Windows 10's Control Panel, Programs, Uninstall a program, Microsoft Office 365, Change) seems to have fixed it. I had previously tried "Quick Repair" which did not help. EDIT: After weeks of testing, an "Online Repair" of Office 365 doesn't help at all. The only...

fightcancer

XLBOOK=ERR

Code: Select all

Let>file=C:\AMD\test.xlsx
IfFileExists>%file%
  IfWindowOpen>test.xlsx - Excel
    XLGet>%file%,xlBook
    Mdl>xlBook
  EndIf
EndIf

Any suggestions?

The Excel file is brand new and completely blank.
Windows 10, updated Office 365, MS 15.0.25

fightcancer

What's the best way to get help with this issue?

fightcancer

Thanks. Any suggestions?

fightcancer

Marcus Tettmar wrote: ↑
Fri Sep 20, 2024 9:45 am
I can't replicate. Same macro, run from top always runs from top, no matter which line I have selected.

Huh.... I can duplicate this issue 100% of the time in 15.0.25 and 15.0.24. Any suggestions?

Anyone else have this issue?

fightcancer

MessageModal>1 Dialog>Dialog1 object Dialog1: TForm Left = 247 Top = 97 HelpContext = 5000 BorderIcons = [biSystemMenu] Caption = 'CustomDialog' ClientHeight = 211 ClientWidth = 476 Color = clBtnFace Font.Charset = DEFAULT_CHARSET Font.Color = clWindowText Font.Height = -11 Font.Name = 'MS Sans Ser...

fightcancer

That fixed it. Thanks!

fightcancer

After some vague Macro Scheduler divide by zero error, I get this error any time I run my macro. What's the fix please?

Error in : [macro]
Line 1495 - Cannot Show Dialog DIALOG1. Not Found

I can then click OK or Abort.

fightcancer

When I use the Search feature at the top right of any page I get this error.

Unable to execute your query. Ensure that a valid subscription key has been set up for your instance.

Is the Search feature broken?

fightcancer

What happens after a full restart and using a different hot key, such as ctrl + alt + r. Ctrl r is likely used by something else. No change after a restart. I don't know how to use a different hotkey without opening the macro in MS15, and I can't open or edit the macro in question through MS15. I g...

Search found 250 matches

Re:

iframes in IE

Re: Scripting for Iframes Using VBScript

Re: XLRun

XLRun

Re: More Excel Trouble

More Excel Trouble

Re: Run from Top Bug?

Re: Run from Top Bug?

Re: Run from Top Bug?

Run from Top Bug?

Re: Cannot Show Dialog DIALOG1. Not Found

Cannot Show Dialog DIALOG1. Not Found

Unable to Search Website

Re: Another Permissions Error