Thanks IDBR and PHV for your replies, sorry about the delay in responding.
I will investigate both but PHV suggestion regarding using the DIR function does looks more encouraging when looking this up within the A97 Help pages.
Stacem
p27br
I have heard/read about doing this before (somewhere) but if I recall it was not using standard VBA code and requires more coding depth than I have at present.
Do you have an example?
I want to create a link to files that are contained within an NT folder. However, I don't want to display the standard Windows Explorer window panes to the user.
I wish to have the file names in the folder displayed in a form that I have created, how can this be done?
(I currently use a...
Lewds
The sheet is a hidden sheet and not a named range, however, I will now name the range in the hidden sheet to see if your solution works. Thanks
rbowes
Your solution takes the approach to resolve this from within the Access code module and I will also give this a try as it might be more...
I have a standard excel workbook which contains 2 sheets
One of these sheets "Upload" is hidden and contains only the data I wish to import in to my db via TransferSpreadsheet.
My code reads:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, _
"tblBulkRenewalData"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.