Search Result

Alby22 · Jun 19 '12, 04:17 PM

I have a time card form set up in excel and each employee will have their own excel workbook for their time card. At the end of the day I need to import the data from each time card into the master workbook. I would like it to output the data in rows and columns in a different format that the time card entry. Attached is the time card form to get a better understanding.I have cleared out all the data in the lists below the form. When finished I will...

Dizo · Jun 18 '12, 03:14 PM

Hello
I am creating a new software with visual studio 2010 using the program language visual basic .NET, well in that software I create a new file in excel 2007, my question is because I do not know how I can create a combobox with data of my database inside, I will be appreciate your help a lot, thank for your time.
To create the combobox I use the next code in a button of my windows form, It actually is an adaptation of the code...

Dizo · Jun 15 '12, 06:25 PM

Hello
I am creating an application with Visual Studio 2010, in my application I need to make a report in Excel and in that report I want to add a combobox with some data, I add the combobox to my excel sheet with the next code:

Code:

Dim xlApp As Excel.Application
        Dim xlBook As Excel.Workbook
        Dim xlSheet As Excel.Worksheet
        Dim xllistbox As Excel.OLEObject
        xlApp = New Excel.Application

...

Marko Danilovic · Jun 11 '12, 02:10 PM

Here is my code:

Code:

Option Explicit On
Option Strict Off
Imports System.IO
Imports System.Text
Public Class Form1
Public moApp As Object
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Try
            moApp = CreateObject("Excel.Application")
            moApp.Visible = False
        Catch

...

MarkBStewart · May 31 '12, 07:46 PM

I am running a simple excel app within Access. I am opening a new workbook, adding data, formatting the sheet ect. It works quite well the first time I run it (click event). The next time it fails with "Error 91 - Object variable or With block variable not set". Here is the first part of the code and the location where it fails on the second try:

Private Sub CalcPercent_Cli ck()

DELCLARATIONS:
...

hd95 · May 16 '12, 09:25 PM

I know how to select 1 sheet or all sheets for an export command, but how would I for example, select "sheet1" and "sheet3" while ignoring "sheet2"?

dchyde · May 15 '12, 05:11 PM

The volunteer organization I work with maintains an Access database of its members. Periodically, geographically specific member lists with portions of each member’s information (the balance is confidential) are distributed to geographically specific coordinators in the form of Excel spreadsheets. While using their member lists, the coordinators learn of updates to the information about members in their area and make changes to the spreadsheets...

anandmadhu · May 7 '12, 04:49 AM

I am using the following code to create an excel file on the share on the remote win2007 professional.

Code:

use Win32::OLE qw(in with);
use Win32::OLE::Const;
use Win32::OLE::Variant;
use Data::Dumper;
use Win32::NetResource

my $Excel = Win32::OLE->GetActiveObject('Excel.Application') || Win32::OLE->new('Excel.Application','Quit');
print $Excel->{Version};
my $Book = $Excel->Workbooks->Add()

...

Sigma7 · Mar 28 '12, 10:11 PM

Good afternoon, I am trying to transfer information from my Excel User Form into the database table. After searching vigourously on the internet, I came across this formula to find the next empty row:

Code:

Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("DocumentFiled")

'Find First Empty Row in Database
iRow = ws.Cells(Rows.Count, 1).End(x1Up).Offset(1, 0).Row

...

proulxfr · Mar 28 '12, 03:49 PM

In Excel, using VBA I created a userform that presents a dynamic listbox. This listbox is build with information included in a specific worksheet. This information is not predefined, it is given by the user varying naming and number of items defined.

By selecting one ore more items from listbox you are able to add specific row in the designed items group. This works fine but using listbox and multiselect. Now I would like to preceed...

dbncourt · Mar 2 '12, 06:37 PM

Using c#, i want to create a Excel file in a given path and name. So far i found this, that could work but it doesnt!

Code:

 oWB.SaveAs(filePath, ".xls", Missing.Value, Missing.Value , Missing.Value , Missing.Value, Excel.XlSaveAsAccessMode.xlShared, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

and the same but insted of the filePath, the fileName. In both cases i get this error:...

franknagy · Feb 29 '12, 02:56 PM

Has the macro language of Excel changed since its version 2002? If yes, where can I see a list of most important changes of its VBA?
TIA
Frank

CookieCoder · Feb 23 '12, 12:42 PM

Hi, Good Morning Experts!
I'm trying to create a new record in Access from Excel VBA. I've got a button in the Excel file, that when pushed will put data from the excel sheet into a NEW record in Access. Here's what I've got so far, but it keeps failing on "Set rstTable = oAcc.Recordset. Open("C:\Docume nts and Settings\ecook\ My Documents\Share Point.mdb")"

Code:

Sub cmdPassDownItem_Click()
Dim oAcc

...

mastap2003 · Feb 13 '12, 09:59 PM

Hi. I have a bit of an issue in a sheet I'm trying to create and have no Idea really where to start.

Basically I currently have a form that inputs data into my s/sheet 'Data'.

I require a button that will produce a summary (possibly message box) of the details that are in the spreadsheet in rows A,B and C. I want the form to display each of the rows that are unique only. ie.

EY18 12-Feb Y-J...

Suggz · Feb 8 '12, 04:28 PM

Hi,

I am attempting to import a text file, but I get an error "(10094) ActiveX Automation: Object var is 'Nothing'."

Not sure what the mistake here is.

Code:

Sub vba_excel_importing_file()
    Dim strFileName As String

    strFileName = InputBox("Enter the full path to the comma " & _
               "separated file to import")

...

Search Result

Import Data From Multiple Excel Workbooks to One Master Workbook

How to create a combobox with my DB in Excel?

Add data to combox Excel

Extract/convert string from XLS

Error 91 - Object variable or With block variable not set

How do I select multiple SPECIFIC sheets from an Excel Workbook?

Updating Access using Excel spreadsheets used to distribute Access info

Using win32::OLE to create excel file on a remote windows share

Excel VBA

Checkbox in Listbox

How do i create a Excel file?

Has the macro language of Excel changed since version 2002?

Excel VBA create new record in Access Table - 2007 Office

Organise Data in Excel

Import text file into excel using vbscript