Add Excel headers by command prompt
Tue, 23 Sep 2008 02:48:01 -0700 (PDT)
Hi all
Need some help. A colleague setup an export of SQL to Excel, but he is
not including the headers. Before he fixed it, he went on leave.
Is there any way to add headers afterwards? (I have no access to the
SQL server to amend the script) The export is every day.
I would like to do this via command p ...
|
Air Force1 and Air Jordan shoes PAYPAL wholesale
Tue, 23 Sep 2008 02:19:01 -0700 (PDT)
Air Force1 and Air Jordan shoes PAYPAL wholesale
www.yahoo808shoes.cn
we are professional produce air force1 and jordan shoes
supplier ,carry PAYPAL.main air force1-25th AF1-high AF1-low .air
jordan 1-14,air jordan 23,air force 1&jordan 5,air force1&jordan12,air
jordan1&jordan23 and so on .We are sure you w ...
|
Macroproblem: Proceed another macro after end of loop
Tue, 23 Sep 2008 00:57:59 -0700 (PDT)
Hey guys :)))
Specially thanks to Bob and Ian - who have been very kind and helped
me a lot
However; The more we learn - the more we know how little we know!
So - you guys have carried me over a threshold in using VBA-EXCEL!
Still I find VBA mysterious and difficult to understand some times.
The macroprobl ...
|
External Reference gives error on Emailing
Tue, 23 Sep 2008 12:22:39 +0530
I had a file having External References. When I email this file to some, it
shows #REF! in the cells of External Reference. Pl. provide any solution.
KAPIL JAIN
...
|
Email Errors
Tue, 23 Sep 2008 15:06:22 +1000
This probably should be posted to another group but the skills of this group
are tremendous.
I send a zipped xls file to 7 receipients.
Five receive ok and can read but the other two get binary when they unzip.
My Outlook settings are HTML for sending.
Are I at fault in my settings or have the two getting bina ...
|
personal.xls file
Mon, 22 Sep 2008 21:58:06 -0500
Where is the personal.xls file located in Excel 12? ( I have no hidden
files.)
Thanks
...
|
moving from excel 11 to excel 12
Mon, 22 Sep 2008 20:38:10 -0500
Excel 2007, wXP
New XP computer with Excel 2007 (Excel 12) and leave my old computer with
Excel 2003. I had a bunch of macros in the old computer, but I believe they
were not all attached to specific spreadsheets and I could see a list of all
macros and invoke the one I wanted. With the Excel 2007 computer ...
|
|
|
Need help comparing data from two different excel workbook sheets
Mon, 22 Sep 2008 20:20:58 -0500
I'm new to VB coding. If anyone could help me I would be most grateful.
I need help comparing data from two different excel files.
I want to be able to compare sheet1 of a file (or workbook) to sheet1 for
different excel file (or workbook).
I wanted to automate this process. Basically, select two differen ...
|
SUMIF
Tue, 23 Sep 2008 02:36:26 +0300
This formula works well:
=SUMIF(expensecode,"<>999",E8:E19) formula 1
I tried to add another criteria as follows: always have a zero answer:
=SUMIF(expensecode,OR("<>999","<>888"),E8:E19) formula 2
Expense code is the name range of G8:G19
Can anyone help to make the second formula ...
|
Creating a Graph in Excel
Mon, 22 Sep 2008 15:40:14 -0700 (PDT)
I'm work in a company with a production line that runs in different
modes. I would like to create a graph that has the "date" on the x-
axis and tons on the y-axis. This graph should only include tons
based on the specific mode we are running in. But, I would like to
see that when we run in a different mode, ...
|