Despite having at least 2 days VBA programming experience, this one has
got me... I'm trying to export multiple tables into one worksheet in
Excel. I've adapted code that I've got from this forum, but I keep
getting the "User-Defined type not defined" error on 'Dim objXL As
Excel.Application'. Again, from my limited time as a veteran copier,
paster and editor, I've had this problem before when using a browse
window - which was fixed by downloading the appropriate reference.
Can anyone tell me if that is the problem, and if so, where would a
fella find such a magical download site to get the required reference?
And of course, if you really wanted to make my day and "lend" me the
magic coding required to export... well, that'd just be dandy....
Cheers
Reg 3 2945
Hi,
Add a reference to:
Microsoft Excel 10.0 Object Library (or 9.0 depending on your version of
Access).
"Regnab" <p.*******@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com... Despite having at least 2 days VBA programming experience, this one has got me... I'm trying to export multiple tables into one worksheet in Excel. I've adapted code that I've got from this forum, but I keep getting the "User-Defined type not defined" error on 'Dim objXL As Excel.Application'. Again, from my limited time as a veteran copier, paster and editor, I've had this problem before when using a browse window - which was fixed by downloading the appropriate reference.
Can anyone tell me if that is the problem, and if so, where would a fella find such a magical download site to get the required reference? And of course, if you really wanted to make my day and "lend" me the magic coding required to export... well, that'd just be dandy....
Cheers
Reg
Regnab wrote: Despite having at least 2 days VBA programming experience, this one has got me... I'm trying to export multiple tables into one worksheet in Excel. I've adapted code that I've got from this forum, but I keep getting the "User-Defined type not defined" error on 'Dim objXL As Excel.Application'. Again, from my limited time as a veteran copier, paster and editor, I've had this problem before when using a browse window - which was fixed by downloading the appropriate reference.
Can anyone tell me if that is the problem, and if so, where would a fella find such a magical download site to get the required reference? And of course, if you really wanted to make my day and "lend" me the magic coding required to export... well, that'd just be dandy....
Avast ye scurvy scum, hoist the jolly roger :-)
I suspect you already have Excel rather than download it from somewhere
so it should already be in your list of possible references to add.
--
[OO=00=OO]
Arrghhh - you're right. Land ahoy...oh no, hang on a sec... it's a
reef.... haul to the starboard side. This VB business is full of
flamin' wrecks. Thank you both kindly - I've now got my compiler
sailing happily past that part of the problem.... pulling up sharply at
the next line of code ;). But no doub't she'll be a fine export ship
when she's done. Now if only I could get her to stop taking on
water.....
Thanks heaps fellas - much appreciated....
Respect
Mr R This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Shawn Mehaffie |
last post by:
I have the following class that I've wirtten to take a Dataset and
automatically export it to either XML, ASCII or Tab delimited file. The
reason I wrote it they way I did was that I don't want to...
|
by: Seema |
last post by:
Hello,
i am trying to export the crystal report in pdf format but i am getting
error while exporting.
Error in File c:\inetpub\wwwroot\Crys\CrystalReport1.rpt: Access to report
file denied....
|
by: Paolo |
last post by:
Hello,
I am trying to create a procedure to export my Access data to a word
template.
I would like to export data from two tables to a word file at the same
time. My two tables are named CASES...
|
by: Charlie |
last post by:
Hello,
I have data in an Access table that I would like to export to multiple
HTML tables. I would like to split the data in the Access table
(about 92,000 records) into multiple HTML...
|
by: Steven |
last post by:
Hi there,
I am trying to export a chart using the Excel11 object from C#. I can
properly open workbooks and read cells, but calling Export() on the Chart
object throws a COMException
...
|
by: Leonard Danao |
last post by:
Anyone have any ideas as to why this is happenning. There are no other
versions of Crystal installed aside from the one that came with vs2003
enterprise.
the error happens when the...
|
by: chaitu |
last post by:
Hi,
Can anybody tell me what the error code for Export is. Like i get the
message
SQL3104N The Export utility is beginning to export data to file...
|
by: CoolFactor |
last post by:
MY CODE IS NEAR THE BOTTOM
I want to export this Access query into Excel using a command button on an Access form in the following way I describe below.
Below you will find the simple query I am...
|
by: Access user |
last post by:
My apologies for crossposting this, but I did not get any response in
microsoft.public.access
...
|
by: iheartvba |
last post by:
Hi I am using Access 2007 and am trying to export a query to a fixed length text file. I tried using the following code to export the text file:
DoCmd.TransferText acExportFixed, , "qryFFRDeFile",...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
| |