473,388 Members | 1,309 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > creating links to excel in vba

Join Bytes to post your question to a community of 473,388 software developers and data experts.

creating links to excel in vba

I am seeking to create links to excel spreadsheets using DAO and VBA.
The links will be "linked tables."

I have working code to refresh links, but that is not what I want to
do. I also need to create them from.

Can anybody point me in the right direction?

Thank you,
Charles
Nov 14 '06 #1
1 1483
On Tue, 14 Nov 2006 11:17:15 -0500, ChasW <wrote:
>I am seeking to create links to excel spreadsheets using DAO and VBA.
The links will be "linked tables."

I have working code to refresh links, but that is not what I want to
do. I also need to create them from.

Can anybody point me in the right direction?

Thank you,
Charles
Well I have isolated the problem. It was with some of the sheet names
within the spreadsheet ending with a space and access not allowing the
last character in the field to be a space?

How can I get access to allow the last character in the field to be a
space?

Is there a way to read all of the sheet names from and excel file?
Nov 14 '06 #2
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
Creating Excel CSV
by: Jeremy Langworthy | last post by:
Hi I am trying to create a MS Excel format CSV but I can't figure out how to get the line feed/carriage return/new record working properly. I am nding each line/record with these characters:...
PHP
1
Creating a large number of charts automatically
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have...
ASP / Active Server Pages
5
Creating a large number of charts automatically (repost)
by: Alan | last post by:
Hi there, Are there Excel charting gurus here?? If so then please read on... Sorry for the cross-post but I'm not familiar with the Excel groups. I've posted to asp.general because if I have...
ASP / Active Server Pages
5
Creating Excel with asp.net
by: Guy Incognito | last post by:
Hello, I've written an asp.net application that creates Excel documents. It works by creating an excel document in XML format. But I wonder if I'm reinventing the wheel. I know that there are...
.NET Framework
9
Creating Excel document from Dataset and XML ?
by: Paul | last post by:
Hi all Arggghhh........... The problem.....I want the user to be able to create an excel document and name particular cells in the document where they want the data to be placed and then save...
.NET Framework
4
Creating Excel spreadsheet
by: Randy | last post by:
Hello, I'm getting an "Access Denied" error when I hit the line of code... Excel.Application oXL = new Excel.Application(); From what I've read, you can get around this by putting the file...
C# / C Sharp
14
Programmatically creating Excel spreadsheets in ASP.NET
by: Raoul Snyman | last post by:
Hi, I need to be able to programatically create excel spreadsheets in ASP.NET (C#), WITHOUT having MS Office on the server. Does anybody have any advice/links/whatever for me? Thanks in...
ASP.NET
7
creating an excel file from .net application
by: Paul | last post by:
Hi I have created an excel file download feature within a .net application using Microsoft Office XP primary interop assembly for excel. I was just wondering if anyone knows if you can also embed...
ASP.NET
0
Links in excel and vb
by: woodford123 | last post by:
Hi all, Here's hoping you can help a very new person to VB. I've got an Excel file with links to other Excel files in hundreds of cells, but there are two parts of these links in each cell I...
Visual Basic 4 / 5 / 6
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!