473,467 Members | 1,612 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Save filepath when using create object macro

5 New Member
Windows XP
Access 2003

G'Day

I am using the built in create object macro to save a query to file in an excel format. I have left the "Output File" field blank so that the user can specify where to save the file.

Is there a way to save the filepath selected by the user in the save object dialog box so it can be used later on in my code?

Thanks

Mike D
Sep 10 '07 #1
1 1911
JConsulting
603 Recognized Expert Contributor
Windows XP
Access 2003

G'Day

I am using the built in create object macro to save a query to file in an excel format. I have left the "Output File" field blank so that the user can specify where to save the file.

Is there a way to save the filepath selected by the user in the save object dialog box so it can be used later on in my code?

Thanks

Mike D

Not in that way. What you can do is use a common dialog box to capture a path and or filename prior to executing the command, and passing it into the command as a variable.
You can then do anything you want with the variable.

This link describes the Common Dialog use. Let us know if you have any problems
http://support.microsoft.com/default...;en-us;q303066
J
Sep 10 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: JTMar | last post by:
I need to save a file in UTF-8 format from an ASP file. Using FileSystemObject I can only save them in Unicode (UTF-16, I think) but not in UTF-8: Set zzzz = fso.OpenTextFile(filepath, 2, true,...
5
by: Carl | last post by:
Please can anyone tell me how I can create a macro to save the results of a query as an excel file? The query is called Student List and I would like to save it to "My Documents". We have had...
4
by: Jae | last post by:
I'm writing a web application that exports and imports excel files. The application gets a list of users and their info and displays it in a datagrid .The user then selects to save the file as a...
2
by: mboyda | last post by:
I have a block of code that useses outputstream to save a pdf to a client computer. It prompts the user with the save dialog, works great but the response finishes after the download completes. ...
3
by: Anders | last post by:
Hi, This is the code I am using: string filepath = "Themes/img/logo.rar"; string filename = System.IO.Path.GetFileName(filepath); Response.Clear(); Response.ContentType = "application/zip";
8
by: david.lindsay.green | last post by:
Hello all, I am quite new a web scripting and making web pages in general and I have stumbled across a problem I have as yet been unable to solve. I am trying to take the contents of a textarea box...
10
by: Henok Girma | last post by:
Hello Gurus, I want to save the state of an unbound DataGridView on my Windows Form application to an XML file so i can later load it back.. Basically, on my form I have a DataGridView, it's got...
7
by: CCLeasing | last post by:
I would like to open a text file titled (c:\logs.txt). If the file doesn't exist i would like to create it. if it does exist i would like to append to it. I would like to insert a line into the...
1
by: ankz | last post by:
Hi Guys I have got 3 tables - in Access Database with Student ID as primary Key in all and all tables are linked with 1 to 1 relationship. I have code the everying with manual program to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.