Posted
by running4surival
on Stack Overflow
See other posts from Stack Overflow
or by running4surival
Published on 2010-05-06T19:52:29Z
Indexed on
2010/05/06
20:08 UTC
Read the original article
Hit count: 402
How do I import data from a excel sheet onto a PGSQL database on linux?
© Stack Overflow or respective owner
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 Stack Overflow
- Search for 'Stack Overflow'
Hello,
I am using MS Office 2007. Please let me know that how can I copy whole data from sheet one to sheet two. I want to copy the whole data from row 5 to onward in sheet two. The whole scenrio is given below in detail.
Sheet one:
Copy the data from column B and Row 3
Sheet Two:
Paste the…
>>> More
as seen on Super User
- Search for 'Super User'
I know the shortcut CRTL + page up/down
but I need the similar function that exists eg in internet explorer: Shift + alt
I found a macro that is close but does not entirely solve the problem:
If ActiveSheet.Name = "To Do" Then
Sheets("Budget").Activate
ElseIf ActiveSheet.Name = "Budget"…
>>> More
as seen on Super User
- Search for 'Super User'
I have a spreadsheet in Open Office 3.0 Calc.
The spreadsheets consist of the first sheet and an arbitrary number of additional sheets, each collecting data for a specific month. The Month sheets have an identical structure. The first sheet is supposed to provide an overview to the most important…
>>> More
as seen on Super User
- Search for 'Super User'
Hi, I have one excel workbook.2 years before I set password protection option for one of the sheet of that excel file.But now I have forgotten the password.Is there any way to recover the password of that excel sheet?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Excel 07. I have two excel spreadsheets. Sheet1 has a few cells on it that I would like to be populated with a few cells from sheet2. This I want sheet1 to replicate this about 400 times for all employees in the agency.
Here is the example.
Sheet 1
Person name number1 number 2 number 3
Cell …
>>> More
