Hello Everybody,
I am using the TransferSpreadsheet method to import spreadsheets for
processing.
say my code looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport1", "" & strFileExtn, False, "Spreadheet1!A1:D30"
No Problem There.
However, if it looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport2", "" & strFileExtn, False, "Spreadheet2 !A1:D30"
If fails.
What is the difference?
There is a space at the end of Spreadsheet2 I can't change the way
these are named.
So my query is this.
1 Can I get around the problem of TransferSpreadsheet choking when
there is a space at the end of the spreadsheet (tab) name.
2 How do I rename the sheet in Excel from Access.
Thanks a million guys.
O'Donnell 1 4130
Have you tried putting single quotes around the spreadsheet name like this:
DoCmd.TransferSpreadsheet acImport, 0, _
"tbltempImport2", "" & strFileExtn, False, "'Spreadheet2 '!A1:D30"
It's the appropriate reference syntax for a sheet name with spaces in Excel.
Jude sp*******@hotmail.com (O'Donnell Tribunal) wrote in message news:<a9**************************@posting.google. com>... Hello Everybody,
I am using the TransferSpreadsheet method to import spreadsheets for processing.
say my code looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _ "tbltempImport1", "" & strFileExtn, False, "Spreadheet1!A1:D30"
No Problem There.
However, if it looks like this:
DoCmd.TransferSpreadsheet acImport, 0, _ "tbltempImport2", "" & strFileExtn, False, "Spreadheet2 !A1:D30"
If fails.
What is the difference? There is a space at the end of Spreadsheet2 I can't change the way these are named.
So my query is this.
1 Can I get around the problem of TransferSpreadsheet choking when there is a space at the end of the spreadsheet (tab) name.
2 How do I rename the sheet in Excel from Access.
Thanks a million guys.
O'Donnell This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Krishna A.M |
last post by:
Hi,
How do i add a hyperlink to a email id having special characters?
I tried the same , say mailto: test_&_send@hoohoo.com
IN the to box i can see only till test_ and the rest is omitted.
...
|
by: andrewflanders |
last post by:
I have an associative array of keys and values. I want to search a
string for the existance of keys and replace them with the values in
the array. The problem is that some of the keys resemble...
|
by: JMCN |
last post by:
hello
i have your basic select case question. i created a combo box and save
it as a query. so whenever the user selects the value and clicks the
export button, the select case should then export...
|
by: barma16 |
last post by:
I've hit a bit of a brick wall here, and could use some advice. I have
an Access application whose output is a four-tab Excel spreadsheet
where three of the four tabs are the result of database...
|
by: Gary Cobden |
last post by:
I have a problem with the following code, which leaves an instance of
Excel visible in Task Manager.
By a process of elimination I have got it down to the fact that
something in the...
|
by: Lokkju |
last post by:
I am pretty much lost here - I am trying to create a managed c++
wrapper for this dll, so that I can use it from c#/vb.net, however, it
does not conform to any standard style of coding I have seen....
|
by: DeanL |
last post by:
Hey Guys,
Does anyone know of a way to format the output of the
TransferSpreadsheet method in Access 97 so that the exported
spreadsheet has some formatting (column widths, row heights, cell...
|
by: JHNielson |
last post by:
I am having quite the unique problem trying to Export to Excel and I need ot find a solution within 3 hours. -- PLEASE HELP!
The system exports a file from the application that the users can make...
|
by: efrenba |
last post by:
Hi,
I came from delphi world and now I'm doing my first steps in C++. I'm
using C++builder because its ide is like delphi although I'm trying to
avoid the vcl.
I need to insert new features...
|
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: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
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:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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: 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...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |