Disabling auto-calculation in Excel via Win32::OLE
Can anyone tell me how to disable auto-calculation in Excel (used via
Win32::OLE) please? I've found plenty of references to doing so in
other languages, but for Perl, just some mailing list posts asking the
same thing - and going unanswered, as far as the archive shows...
James.
.
Relevant Pages
- Re: VBA errors in 2007 (works fine in 2003)
... It's just breaking on the Mac version of Excel. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
(microsoft.public.excel.misc) - Re: VBA errors in 2007 (works fine in 2003)
... The file is working as intended now in Excel 2003 and 2007. ... Pak allowing you to call functions in the ATP from within VBA. ... menu in VBA, choose References, and select "atpvbaen.xls". ... If there is the possibility of a name collision (two or more libraries ...
(microsoft.public.excel.misc) - Re: Code looping through files
... What was the filename? ... Excel or from VBA? ... the References list box? ... in a folder, opens each, does things, closes the file and opens the ...
(microsoft.public.excel.programming) - Re: Code looping through files
... the Microsoft vb alert window. ... Excel or from VBA? ... the References list box? ... in a folder, opens each, does things, closes the file and opens the ...
(microsoft.public.excel.programming) - Re: Code looping through files
... List box and I do have Microsoft Forms 2.0 Object Library installed ... Excel or from VBA? ... the References list box? ... in a folder, opens each, does things, closes the file and opens ...
(microsoft.public.excel.programming) |
|
