Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2012, 02:01 AM
jillapass jillapass is offline switching windows for variable file name Windows 7 32bit switching windows for variable file name Office 2007
Novice
switching windows for variable file name
 
Join Date: Dec 2011
Posts: 26
jillapass is on a distinguished road
Default switching windows for variable file name

I have a template that users open.
They enter details then press a button, enter a file name and save the file.


The macro then switches them to a different file todo some more processing.
I want to be able to switch back to the file they saved.

The command I have is below, but I want to switch to whatever they entered when they saved the file.

The name they save to is 'myfilename' and I want to switch to that one whatever it is called.
Thanks



Code:
windows("test.dotm").activate
Reply With Quote
  #2  
Old 04-21-2012, 02:59 AM
tinfanide tinfanide is offline switching windows for variable file name Windows 7 64bit switching windows for variable file name Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

I don't know if I've got your message right.
But I've tried in this way. Please see the attachment:
temp1.zip
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
switching windows for variable file name Automatic Switching of Portrait to Landscape Headers Cris4py Word 1 03-15-2012 01:21 PM
Switching between 2 accounts Night Train Outlook 5 02-20-2012 10:02 PM
opening office file deletes copied text from windows clipboard linadze Office 11 02-03-2012 10:35 AM
Switching text on either side of hyphen nignog Word 1 01-23-2012 01:13 PM
Switching between Profiles elsinore Outlook 1 09-21-2008 10:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft