Retrieving URL

C

ChuckS

I am writing a WEB based application that downloads an XLS file, that contains a macro, from a Web Server to a client and runs the macro. The macro contains code (Function URLDownloadToFile) to download a tab delimited text file from the server. It then opens/reads the file to populate the spreadsheet. I can almost make this work (I'm losing my tabs and linefeeds) if I hardcode the URL in the macro and place the tab delimited text file at that specific location on the server. The problem I have is the text file's name and path are dynamically generated at runtime, therefore I cannot hard code the URL in the macro. Is there any way to retrieve the URL from the macro?

I would appreciate any help I can get.

Thanks,
ChuckS
 

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

Converting URLs in comments to Markdown-formatted links 2
Check whether URL exists 1
Import a comma delimited file & match records 3
parsing and importing a text file with records through a VBA macro 1
Run-time error ‘13’ mismatch type 1
Code Cleaner menu entry disappeared 9
Toggling save warning message on or off 9
Macro to copy files from Folders/Subfolders 3

Top