Hello Group,
I will appreciate it if you could give me an optimized method to do the following operation in my VBA code:
1) when the xla file gets open it has to open with two sheets: she...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/16/2007 Rating: 9.6 Views: 0
How can I rearrange following code
Private Sub Command1_Click()
DoCmd.TransferSpreadsheet , acImport, "TransferInput", "a:\NY81900-C0090-DQ-D070627-T123457.xls", True
End Sub
So, instead of ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_228...
I am working on a VBA script to convert formating in a word document to some special markup used by FlexWiki. The problem I am having is the converting of font colors. It is impossible to search fo...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/...
Zones:
MS WordDate Answered: 05/03/2008 Rating: 8.2 Views: 0
I have an Excel macro that has a compile error I can't debug. The error reads <<End If without block If>>. The thing is that I think I have a block If. Here is my code:
Sub PrintAreaCopiesMsg(...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23535454.html
Hi there:
I have a form that contains 10 text boxes and 7 comboboxes that the end user has to complete. Once they are done, they click a commandbutton that has the "Activeworkbook.sendmail" atta...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/29/2008 Rating: 7.6 Views: 0
Does anyone know how to embed menu buttons in a form? I have an application that uses an rtf activex control and a custom menu that is launched when the form launches. I would ike the items ion t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23778788.html
Hi,
I'm using excel 2000.
I made (using VBA code) an excel sheet which opens, refreshes, sends itself to a mail recipient automatically,
and then closes.
Now when the one who recieves the...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi there:
I am not very familiar with VBA in Excel so please keep this in mind if this seems like an obvious question. I have a simple combobox and command button and I have the following code:
...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/06/2008 Rating: 9.0 Views: 4
I have a Class Command Handler:
-----------------------------------------------
Option Explicit
Implements CommandHandler
'*-----------------
'* PJM Start
'* 2008-11-14 Note from PJ Mur...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/18/2008 Rating: 7.7 Views: 0
I've seen this posted numerous places on the web, but I can't find any that won't cause MsQuery to complaint about the Sql syntax.
Here's what I want to do
Table has 4 columns of interest, un...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...