Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping from declaring a direct path
Hello.
I would like to know how I make a call to a file in a macro for opening it without using explicit path calls. In other words, I want to copy the entire directory to a USB drive and use the workbook, and its macros from there. My macros current make explicit call to paths that would not be present for the USB drive version of my database. What do I do to properly call a file? The old DOS method of "./pathname/filename.xlsm"? I already learned the other day that recording a macro doesn't always work later if everything is not in the exact same state. I overwrote my entire "main view sheet" because I left out workbook and sheet switching and opening and selecting events. I am learning,though. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping from declaring a direct path
Try using the string returned from
ThisWorkbook.Path Cheers, Rob CellShocked wrote: Hello. I would like to know how I make a call to a file in a macro for opening it without using explicit path calls. In other words, I want to copy the entire directory to a USB drive and use the workbook, and its macros from there. My macros current make explicit call to paths that would not be present for the USB drive version of my database. What do I do to properly call a file? The old DOS method of "./pathname/filename.xlsm"? I already learned the other day that recording a macro doesn't always work later if everything is not in the exact same state. I overwrote my entire "main view sheet" because I left out workbook and sheet switching and opening and selecting events. I am learning,though. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping from declaring a direct path
So I grab that value and pass it to my code segments whenever I need
to call a file not already open? Thanks, btw. On Mon, 07 Dec 2009 19:20:12 +1300, Rob van Gelder wrote: Try using the string returned from ThisWorkbook.Path Cheers, Rob CellShocked wrote: Hello. I would like to know how I make a call to a file in a macro for opening it without using explicit path calls. In other words, I want to copy the entire directory to a USB drive and use the workbook, and its macros from there. My macros current make explicit call to paths that would not be present for the USB drive version of my database. What do I do to properly call a file? The old DOS method of "./pathname/filename.xlsm"? I already learned the other day that recording a macro doesn't always work later if everything is not in the exact same state. I overwrote my entire "main view sheet" because I left out workbook and sheet switching and opening and selecting events. I am learning,though. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping from declaring a direct path
Yes, passing it that way would work.
CellShocked wrote: So I grab that value and pass it to my code segments whenever I need to call a file not already open? Thanks, btw. On Mon, 07 Dec 2009 19:20:12 +1300, Rob van Gelder wrote: Try using the string returned from ThisWorkbook.Path Cheers, Rob CellShocked wrote: Hello. I would like to know how I make a call to a file in a macro for opening it without using explicit path calls. In other words, I want to copy the entire directory to a USB drive and use the workbook, and its macros from there. My macros current make explicit call to paths that would not be present for the USB drive version of my database. What do I do to properly call a file? The old DOS method of "./pathname/filename.xlsm"? I already learned the other day that recording a macro doesn't always work later if everything is not in the exact same state. I overwrote my entire "main view sheet" because I left out workbook and sheet switching and opening and selecting events. I am learning,though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Direct Formula | Excel Discussion (Misc queries) | |||
direct your sum in the right box? | Excel Programming | |||
Direct path to Worksheet | Excel Discussion (Misc queries) | |||
Direct DLL reference? | Excel Programming | |||
Can you direct me. | Excel Discussion (Misc queries) |