![]() |
#13
|
|||
|
|||
![]()
Hi Guessed
Thanks for the reply, unfortunately to run a process to create a dummy file will require another file to exist (a short .com file, for example, to create the dummy) which defeats my aims of being able to pass a single file onto others. The second idea to use the startup path would mean that the excel file would always need to be in a specific directory which then gives the opportunity for another cockup. Currently the only directory stipulation is that the VB6 .exe and the Excel file are in the same folder, but that folder can be in any sub folder on any drive. I think I may have to just settle for the fact that I cant do it. Thanks to all for your suggestions. Mike |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I copy a workbook to another workbook and keep the formatting within the new workbook | excelforsue | Excel | 3 | 09-15-2020 03:37 AM |
Sharing a Workbook that contains array formula link to other workbook | Ahmad.rage22@gmail.com | Excel | 0 | 03-12-2018 10:15 PM |
data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
![]() |
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |