Search:

I need to export data from Excel 2007 file to Access 2007 table.

The excel file has 65536 rows and I am not able to export more than 65536 rows of data.

Here is the code

con=...

Hi

I want a save dialog box to be prompted to save a file.
I need the code in MS Access.

Please Help.

application.displayalerts=false does not suppress the message

When I open .xlsm file I get the following message:

"File Conversion in progress".

How can I suppress this message from excel macro.

Hi

How to suppress macro security warning that comes up when I open the MS Access database.

Opening “C:\Test\test.mdb”
This file may not be safe if it contains code that was intended to harm...

Hi

What is amount of data or Size (in GB) that the MS Access can accomodate.

Thanks.

Hi

We have developed an Excel tool with macros in it.
We are actually planning to package the tool.

And when the User installs the Executable; the exe has to install the tool on C:\Program...

Hi

Can anyone please let me know which are all the versions is Microsoft Office Spreadsheet Component 11.0 compatible.

Is it Compatible with Excel 97/2000/2002.

Thanks

Hi

I have developed a Excel tool.
I want this tool to be packaged for deployment on user's desktop.
Can I package this tool using Package and Deploment wizard provided by Microsoft Visual...

I need to access data from a workbook which is exsiting on a remore site (for eg: http://excelfile.com)

I have to write a Excel(Excel 2003) Macro for this

How do I do that.

Please help

Advanced filter in Excel does not do Exact string match.

For example, if suppose I want to extract all those records which has value FS in column A, if I apply an advanced filter output will...

Hi

How can I do exact match for Advanced filter

Hi
I am using Labels and Combo boxes in Excel 2003 application.
I have designed the excel sheet setting the Zoom magnification to 94%.
But when I reduce the Zoom magnification to 78% the font of...

Thanks for the reply.

The code below "CheckIfNotepadisOpen" would help me find if there are any notepads open.
But I want find if C:\test1.txt is open or not.

How can I do that?

Hi

I am using a Shell Command in Excel Macro to open the notepad.
Shell "Notepad.exe " & "C:\test1.txt"

I want to check if this file is open, if its open then I do not want to open the notepad...

Hi

I know that Wrod Wrap is not supported by Microsoft Office 2003 Spreadsheet Component , Can I use some WinAPI or anything with the help of which I can enable the word wrap.

Thank you.Please...

Hi

if I use the below code to exclude one row from filter criteria. It excludes all the rows which are selected.

Sheet1.Spreadsheet1.ActiveSheet.AutoFilter.Filters(1).Criteria.FilterFunction =...

Hi

I am using a OWC11 spreadsheet component to display some data.
But the excel application is taking long time to open up.

Please help

Hi

Once I apply the filter.
I want to save the filter criteria.
So that once I turn off the filter.
I must be able to reapply the filter.

How can I do that.

the filter is applied to OWC...

Hi

I am unable to freeze the size of the spreadsheet component in Excel.

I am using the OWC Spreadsheet control to display some data.

Whenever I open the Excel application the size of the...

The code I have used to change the color of the hidden cells is:

ThisWorkbook.Worksheets("Sheet1").Spreadsheet1.Worksheets("Sheet1").Range("A2:I2").Interior.Color = vbWhite

[Spreadsheet1- is a...

Hi

I am unable to change the color of the hidden cell in OWC Spreadsheet component.

Please Help.

Hi

I am using an Microsoft Spreadsheet cotrol 11.0 (OWC Spreadsheet) in an Excel application.

I want to Wrap text in the spread sheet control and also apply filter, not the one which the...

Hi

How to split one single cell into two cells in excel 2003

Thanks

I have created a digital certificate on my machine to supress "Enable/Disable Macros message"

How can I use the certificate for other users to that the message "Enable/Disable Macros message" does...

Hi

Digital Signature signed an accepted for the first time. - How Can I do this

Hi

I have used Active X Controls in Excel 2003.
When I open the workbook I get a warning message

"The application is about to initialize ActiveX controls that might be unsafe . If you trust...

Hi

When I open the workbook I get a Security warning message.
To Enable / Disable Macros.

Can I supress this Programmatically.

I know, I can supress the message by setting the Macro...

If I have some other workbook open the Worksheet_SelectionChange is not working.

Please help

Hi

While Copying the data from one worksheet into another worksheet using macros , I get the below message
"Data on the Clipboard is not the same size and shape as the selected area. Do you want...

Hi

Its still giving me the same error, after making the above code change

Yes Frame1 is on Sheet1

Comboboxes are in the Frame, not on the form.
Visible and enabled properties are set to true
Sheet1.Frame1.Controls("ComboBox1").SetFocus- is the code I am using

Hi

I have a Frame and three Comboboxes and 2 CommandButtons.

One of the commandbutton is for Searching the records and other is to clear the data.

After doing search, When I click on button...

Hi

I am using Active X controls in my Excel Application (Version:2003).
When ever I open the application I get a message:


"The application is about to initialize ActiveX Controls that might...