Import .csv file with more than 65536 rows into multiple excel she
Fri, 2 May 2008 05:32:01 -0700
Hi,
I have .csv files, all of which have more than 65536 rows. I want to import
it into Excel file with multiple sheets. I don't know much about macro. Can
anyone please help me with the code to import the .csv file into multiple
.xls file.
Thanks in advance,
Snehal Patel ...
|
OUACTRL.ocx and powerpoint
Thu, 01 May 2008 19:10:38 +0200
Hi all,
within a powerpoint presentation I would like to work with a
CommandButton, which executes some Actions / Hyperlinks.
However this button cannot be programmed ("actions ..." in its context
menu is grey).
When I try to find some help to Actions within powerpoint's help file, I
get the message, th ...
|
Globally share all calanders in my network from Exchange server?
Thu, 1 May 2008 09:17:27 -0700
I'm trying to share all user calanders from my Exchange server. can anyone
help? ...
|
Excel VBA Advanced training in London.
Wed, 30 Apr 2008 13:35:58 -0700 (PDT)
Hi All,
I'd like to invite you to the Excel VBA Advanced training in London.
Course Date: 2008-05-14 09:00 - 2008-05-16 17:00
Venue: 112/114 North Acton Road, NW10 6QH, London
Training Outline: http://www.nobleprog.co.uk/training/excel+vba+advanced
Booking: http://www.nobleprog.co.uk/node/1286 ...
|
THe specified device is not open or not recognized by MCI
"mciSendStringA"---VBA
Tue, 29 Apr 2008 21:34:21 -0700 (PDT)
The following is the code (Form_Load), executed from MS Excel (and MS
Word). The "sndPlaySoundA" function from the "winmm.dll" works fine.
What am I missing? Thanks
Public Declare Function mciSendString Lib "winmm.dll" Alias
"mciSendStringA" (ByVal _
lpszCommand As String, ByVal lpszReturnString As String ...
|
Help - Consuming Web Service in VBA
Mon, 28 Apr 2008 06:19:01 -0700
Hi,
I am very familiar with consuming Web Service using any .Net technology and
with the development of VSTO add-in but I am not too familiar with consuming
Web Service in Office VBA.
Can someone offer me some guidance? Apart from the Web Service Toolkit,
which appears to be obsolete now, does VBA natura ...
|
Help. How do I disable a UserForm's close (X) icon?
Wed, 23 Apr 2008 21:21:58 -0700 (PDT)
This may be a really dumb question but how do I disable a UserForm's
close (X) icon? Is this even possible in VBA?
Thanks in advance,
Jose Lopez
...
|
|
|
Importing Text file
Wed, 23 Apr 2008 10:32:53 -0500
I want to import a text file and I've tried the Get External Data wizard and
a TransferText macro. It's putting a blank line in the table between. I've
change the field size from 89 to 90 and I still get a blank record between
each filled in record in the table.
It looks like it has 89 characters and then ...
|
Programatically add a digital signature to a macro
Wed, 23 Apr 2008 05:32:01 -0700
Hello,
I would like to know if anyone has suceeded to programatically sign a macro
in an Office 2007 document?
What I would like to know is how to create the vbaProjectSignature.bin file
that exists in signed Open Xml documents.
Anyone with any idea? ...
|
Reloading Data into a ComboBox using RowSource
Tue, 22 Apr 2008 13:08:08 -0700 (PDT)
Hi,
I have two comboboxes on a VBA form that use dynamic range names for
their RowSource data. Esentially when you select something from the
first combo box, I have it set a cell to the selected value using
controlsource which in turn changes a list on the sheet that was used
in the row source for the second ...
|
