SaveAs and relative path

  • Thread starter Thread starter dev
  • Start date Start date
D

dev

Hello,
I am trying to save a Workbook object using the Excel 9.0 Object library
and VB.Net. I am executing this statement:

oBook.SaveAs(ReportPath & Me.txtFileName.Text)

where 'ReportPath & Me.txtFileName.Text' resolves to '..\Serial
Worksheets\myFile.txt'. This is being saved from an exe in a 'bin'
directory on the same level as the 'Serial Worksheets' directory. Like:

_Project
|_ bin <==exe lives here
|_Serial Worksheets <==workbook should save here

The SaveAs method fails because it is trying to save the workbook up 3
levels from the bin directory where Serial Worksheets does not exist.
Anyone have any ideas what is going on?

TIA,
Steve
 
Hi Dev,
The SaveAs method fails because it is trying to save the workbook up 3
levels from the bin directory where Serial Worksheets does not exist.
Anyone have any ideas what is going on?
Click to expand...

I think the ReportPath will need to be a fully-qualified path, not a
relative one.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SaveAs using VB 2
Save ActiveWorkbook dilemma 3
SaveAs file lost 1
SaveAs Macro - Build filename from cell contents HOW? 4
Split file, saving each tab/worksheet to a new workbook, w/tab asworkbook name? 4
Unable to delete file from Sharepoint Server Library using VBA (Ex 6
Run-time error 1004 Method SaveAS of object _Workbook failed 2
disable save and saveas from menubar and save via command button 5

Back
Top