98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Read specific cell value and same value named Folder/file into c
Read specific cell value and same value named Folder/file into c
Resolved · Low Priority · Version 2007
Thu 9 Feb 2012, 12:11Delegate Palvinder said...
Palvinder has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Read specific cell value and same value named Folder/file into c
I read a specific cell Value in my current worksheet.
This cell value happens to be the same name of the FOLDER and FILE name in a specified path on the C: drive.
If found (only got one sheet in it) I want to copy and paste values
into my current workbook in a specified named work sheet.
Otherwise display file not found.
Appreciate you help on this
Kindest Regards
Pal
Thu 16 Feb 2012, 10:43Trainer Anthony said...
RE: Read specific cell value and same value named Folder/file in
Hi Palvinder, sorry for the delay in getting back to you. Your query involves several different aspects already covered in our course material, such as moving data from one sheet to another and error trapping. One addition, however, is testing to see whether a file or folder exists which these links should help you with:
http://www.ozgrid.com/forum/showthread.php?t=43256
http://www.excelguru.ca/content.php?157
Hope this helps,
Anthony
Thu 23 Feb 2012: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between Worksheets without using the mouseUse the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys. |
