Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CreateNewDocument : an small but interesting discovery from office
Hi, all newcomers in using office VBA
I wonder this simple sentence to create new documents and add to excel activecell will defnintely useful for those don't know it, and I also cannot find it using search engine here. (I even just know this minutes ago, it is even not in help files of VBA that I solely rely on) On error resume next Set ObjHyper = _ .Hyperlinks.Add(Anchor:=ActiveCell, _ Address:="C:\test.xls") ObjHyper.CreateNewDocument _ FileName:="c:\test.xls", _ EditNow:=True, Overwrite:=False -- a scientist |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
office 2003 small buisness edition | Excel Discussion (Misc queries) | |||
Where do I find a template for a small office inventory/supplies | Excel Discussion (Misc queries) | |||
MS Office 2000 - Small Business Financial Manager | New Users to Excel | |||
office 97 small business edition, excel does not work on xp | Setting up and Configuration of Excel | |||
Office Small Business ver. 2003 has problems running in XP | Excel Discussion (Misc queries) |