I am trying to write a macro that publishes the print area as a non-interactive web-page to a file that sits in the same location as the spreadsheet from which the macro is being run. I am using the the following macro: Code: Sub SaveRangeWeb2() 'Creates a web page without interactivity from specified range ActiveWorkbook.PublishObjects.Add _ SourceType:=xlSourcePrintArea, _ Filename:=ActiveWorkbook.Path & ' Sample1.htm', _ Sheet:=ActiveSheet.Name, _ HtmlType:=xlHtmlStatic ActiveWorkbook.PublishObjects(1).Publish (True) End Sub I am having some problems with this though. First, it only publishes what ever is defined as the print range on the first sheet in my workbook, not the currently active sheet.
I want it to publish the print area of the currently active sheet. Second, once the macro runs one time, no matter what I name the output file name, it still uses sample1.htm. So when I run the macro the first time it creates the file called sample1.htm. However, if I change the name of the output filename in the macro to sample2.htm, it still names it sample1.
Any help would be much appreciated! I have a VBMacro Excel file loaded on a Server that numerous people access. A Macro in this file creates a Copy of a specific Sheet within the Active Workbook and I want to Save it to the individual's Desktop. How do I find out what the current User's desktop folder path is each time the Marco is run by a different User?
Example User's path: 'C: Documents and Settings jfarc Desktop' Where 'jfarc' is the name of the current User which, will of course change with every different User that runs the Macro. Also, is there a way to pull out of Excel what is the current User's 'Options General Default File Location' entry? Which may differ from the above directory. I am familiar with and use the following coding for Opening/Saving files to the current directory of the opened workbook, but it only gives the path of the existing Excel workbook and not the current User's Directory Path: Dim wbThis As Workbook Set wbThis = ThisWorkbook ChDir wbThis.Path. Arcangelo from Italy asks: How can I write an Excel VBA macro to save the current Excel file with a filename derived from cell A1?
This macro is amazingly straight-forward: Public Sub SaveAsA1() ThisFile = Range('A1').Value ActiveWorkbook.SaveAs Filename:=ThisFile End Sub I'm totally lost on this 'amazingly straight-forward' macro!!!! Could someone help if I tell you the SAVE location? It's T: COMMISSIONING IJT TIMELOG project Staff#1.
Finally, some Excel shortcuts are just plain different on a Mac. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. For a complete list of Windows and Mac shortcuts, see our side-by-side list. We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience. That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. Excel is quite robust, meaning there is a lot of different tools that can be utilized within it, and therefore there are many skills Excel Resources Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen and are an essential alternative to using a mouse. This article itemizes the keyboard shortcuts for Excel for Mac. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Excel for Mac.
I'm just not certain what value I'm replacing in the Macro above. Any help appreciated. I am using XL2007 and have a macro that refreshes microsoft query connections. The issue is the refreshes only happen if you step through the macro using the debugger.
Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. This Settings Advanced Settings Downloads DownloadsLocation option appears to work for every attached file except a PDF (at least on the Mac version of Chrome that I use). When an attachment is a PDF, no pop-up window asking where to save appears as it does for Word, Excel & various image files.it just automatically downloads. Mac command for step backward in photoshop.
When you run the macro normally, everything else functions properly, but the data is not refreshed. Any help is appreciated. Here is an excerpt of the code: Workbooks.Open Filename:='C: Profile.xls' Sheets('SELECTION').Select Range('F3').Value = SNR ' THIS PART ONLY WORKS IF YOU STEP THROUGH THE MACRO USING THE DEBUGGER.IF YOU RUN MACRO NORMALLY THE CONNECTIONS DO NOT REFRESH ActiveWorkbook.Connections('Connection').Refresh ActiveWorkbook.Connections('Connection14').Refresh ActiveWorkbook.Connections('Query from C_Profile').Refresh ActiveWorkbook.Connections('Query from C_Profile1').Refresh.
- пятница 01 февраля