I have the same problem.
I know this is possible in JavaScript with one line of code:
vSheetContent = document.all.tabContent(0).outerHTML
window.clipboardData.setData("text", vSheetContent)
Surely there is something similar in VBScript - it's such a basic need but it seems you...
Has anyone else encountered a similar problem or found a soln. to this?
I have a piece of Javascript to open an Excel workbook that is sitting on an Oracle application server. I want the workbook to be opened inside the browser but it opens in a separate instance of Excel. I have read a...
Has anyone else encountered a similar problem or found a soln. to this?
I have a piece of Javascript to open an Excel workbook that is sitting on an Oracle application server. I want the workbook to be opened inside the browser but it opens in a separate instance of Excel. I have read a...
Dan,
The code to stop the screen updating is
Application.ScreenUpdating = False
Try it in combination with these lines:
Application.ScreenUpdating = False
Application.StatusBar = "Running macro."
--your code here..
MsgBox "Macro complete", vbOKOnly + vbInformation...
Ok,
.Author cannot be set, but as what is actually used is the value of Application.UserName. You can change the value of .UserName just before your comment adding code (read it into a variable before changing it so you can reset the UserName to its original value).
However, you should be able...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.