MRdNk

Senior Member

Last Activity: 27-Oct-2009 08:02 AM

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 2 of 2

17-Jul-2009 09: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.
- View Conversation
02-Jun-2008 04: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
- View Conversation

About Me

About MRdNk

Experience

Excel, Access, PHP, Js

Computer Specs

AMD Turion 64 X2 Mobile 2 Ghz
3 GB RAM
Vista Home Premium SP1
Office 2007 Pro.

Running: WAMP Server: Apache, PHP, and MySQL.
Signature
MRdNk
-----------
Excel & Access VBA (class), Javascript, and PHP.
Learning: XML AJAX Development.

Harry Hill's Retort to a Heckler:
'You may say that now, but I'm safe in the knowledge that when I go home, I have a warm chicken in the oven.' - Harry Hill