Hi all,
Using Excel 2010.
Trying to set Excel file as Data Source, keep getting error
The objFolder.Path is returning UAC. Is that a problem? If so, how can I get the drive mapping and not UAC?Could not find installable ISAM
The values for objFolder.Path and sDataFile are as expected.
The file is in .xlsx file format
thx
w
Please Login or Register to view this content.
It is not a UAC problem.
The connection string depends on the file type. See ConnectStrings.com for the connection string.
For an XLSM, it might go something like:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks