There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Tech Support Guy Forums > Members List >

MRdNk MRdNk is offline

Member

Visitor Messages

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!
Showing Visitor Messages 1 to 4 of 4
  1. MRdNk
    09-Dec-2009 07:55 PM
    MRdNk
    Please post in the forums, as I use this site - infrequently.

    There are many programmers on this site, that can help.
  2. ExcelGuy
    25-Nov-2009 01:37 AM
    ExcelGuy
    Hello,

    I'm being stuck in Importing 23 datailes ( 3 sheets in each datafile and each datafile is in .xlsx format ) into one single "Import.xlsx" Excel file.These 23 datafiles are placed in a folder "Excel" on the desktop.As I want to import 69 Sheets from the 23 datafiles so I've created 69 Sheets in the file where I want my output/imported datafiles.What would be the code for this ?The name of the 23 datafiles are : " Data for State1.xlsx","Data for State2.xlsx"................,"Data for State23.xlsx".And the name of the datafile ( 69 sheets ) where I want to import these 23 datafiles is " Import.xlsx" and all these 24 datafiles are placed in one folder " Excel " on my desktop.

    Kindly guide.In case the datalies are required I could attach and send it.
  3. CarmelIN
    17-Jul-2009 10:27 AM
    CarmelIN
    Hello,
    I was reviewing a thread from Mar 2008 where you were helping nysgirl with an excel spreadsheet that I'd like to use - its just what I need too. I saved the doc and began making some edits -would you be willing to help me with this? I'd really appreciate it.
  4. bairamsunil
    02-Jun-2008 05:12 AM
    bairamsunil
    Hi,
    My name is bairam, Recently i have started working with VBA, Need some one to help me in the following:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "dbo.tblimport", filetouse, False ' , "Batch!" & strRowStart & ":" & strCol & strRowEnd

    dbo.tblimport is the table name, "Batch!" & strRowStart & ":" & strCol & strRowEnd is my range to be copied

    I am not getting any error and the following code execute as usual, but no import is being done.

    The excel file which I am using has columns which are done by some formula, but in my range the heading are not being used.

    Appriciated
    Bairam

About Me

  • About MRdNk
    About Me
    I'm a Systems Developer, writing ASP.NET / VB.NET, SQL Server, and JavaScript. I passionate about MooTools, and NodeJs; and good quality code.
    Location
    UK
    Occupation
    Systems Developer: ASP.NET / VB.NET, JavaScript, SQL Server 2005/2008
    Experience
    Damn I'm good!
    Computer Specs
    MacBook Pro 2010
    8GB RAM
  • Signature
    MRdNk
    -----------
    Web App Developer: .NET, JavaScript and SQL

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 28-Aug-2011 05:30 AM
  • Join Date: 07-Apr-2007
  • Referrals: 0

Friends

Showing Friends 1 to 2 of 2

Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 10:06 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.