LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 186
Default Issue With Save As

Thanks p45cal for the help. I appreciate it.

"p45cal" wrote:


Jack;435311 Wrote:
Hi,
I am trying to export an access table to an excel workbook using vba.
At the
end I would like to prompt the user with a save as dialog box so that
the
user can choose the corresponding path where the excel spreadsheet will
be
saved. However I do
not know how to prompt the user with a save as dialog prompt. I
appreciate
any help. Thanks.
CODE:


Check out *GetSaveAsFilename *method in Excel help


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=120845


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
save as issue jatman Excel Discussion (Misc queries) 1 March 21st 08 09:41 AM
File Save/Save As Issue Josh O. Setting up and Configuration of Excel 3 August 28th 07 06:33 PM
save as issue eyesonly1965[_13_] Excel Programming 1 May 13th 06 08:39 AM
Excel Save Issue AlbertGe Excel Programming 2 July 22nd 05 04:00 PM
Save As issue Logan[_2_] Excel Programming 2 April 11th 04 04:12 PM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"