-
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
-
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I want to concatenate two strings for the shell file im getting error when i have created the shell file in following manner could you please suggest how to get it set
export APP_HOME="/home/sfptladmin/ArchivalDaemon"
export JAVA_HOME="/usr/lib/jvm/java-7-oracle/jre"
export LIBPATH="/home/sfptladmin/ArchivalDaemon/lib"
export…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've been wondering whether there is a good "git export" solution that creates a copy of a tree without the .git repository directory. There are at least three methods I know of:
git clone followed by removing the .git repository directory.
git checkout-index alludes to this functionality but starts…
>>> More
-
as seen on Super User
- Search for 'Super User'
With the new version of Snow Leopard, OSX upgraded the bash version to GNU bash, version 3.2.48(1)-release (x86_64-apple-darwin10.0).
Now, my .bashrc sets the following settings:
# Colors
export TERM=xterm-color
export GREP_OPTIONS='--color=auto' GREP_COLOR='1;32'
export CLICOLOR=1
export LSCOLORS=ExGxFxDxCxHxHxCbCeEbEb
#…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I compiling with Solaris 10 SPARC, jdk 1.6 from Sun, Ant 1.7.1 from OpenCSW.
I have no problem running hadoop 0.17.2.1
However, I have problem compiling/integrating hive with the error 'cannot find symbol', although I followed the tutorial.
I have the hive source code from SVN exactly from tutorial…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
When I export the content of the display tag table I use the data shows up fine, but the header cells are surrounded by html span tags, which is slightly annoying.
I can imagine why Displaytag uses spans around the column header's text, but it shouldn't transpose in the exported data I think…
>>> More
