| Author |
Message |
Forum: Support Topic: Excel VBA translation after initial call |
| Xx7 |
|
Posted: May 21st, 2012, 10:37 pm
|
|
Replies: 4
Views: 71
|
When I use this it copies the sheet to another workbook. How can I copy the active sheet to the same workbook?
Code: !i::
XL := Excel_Get()
XL.Activesheet.copy
;sheet_name := XL.Activesheet.name
;sheet_num := XL.Sheets.count
return |
|
 |
Forum: Support Topic: Excel: Close and Save all invisible workbooks |
| Xx7 |
|
Posted: May 21st, 2012, 8:42 pm
|
|
Replies: 2
Views: 32
|
| anybody have a script to close and save all lingering instances of Excel? |
|
|
Forum: Support Topic: Excel VBA translation after initial call |
| Xx7 |
|
Posted: May 21st, 2012, 7:20 pm
|
|
Replies: 4
Views: 71
|
Jethrow,
I'm still having trouble with the copy method.
I would like to copy the active worksheet, move the copy to the end of all worksheets, and keep the original worksheet active (instead of activating the new copied worksheet). |
|
|
Forum: Support Topic: Automate import of data from excel to DB via front end. |
| Xx7 |
|
Posted: May 21st, 2012, 7:07 pm
|
|
Replies: 2
Views: 48
|
| Here's a script to import/export ranges between Excel files. However, your biggest concern is probably getting the info out of the DB in a usable format. ;############### Export a Range ###################### ;1) Create files named BBB.xlsx and CCC.xlsx ;2) Put so test data in cells A1:B5 of BBB.xls... |
|
|
Forum: Support Topic: Open Excel specific sheet |
| Xx7 |
|
Posted: May 21st, 2012, 5:14 pm
|
|
Replies: 6
Views: 106
|
| Here is an example using AutoHotkey_L: xlFile := A_ScriptDir "\MyWorkBook.xls" try xl := ComObjActive("Excel.Application") catch xl := ComObjCreate("Excel.Application") Book := xl.WorkBooks.Open(xlFile) Book.Sheets("Sheet2").Select xl.Visible := True Jethrow,... |
|
|
Forum: Support Topic: Excel - Delete Active Worksheet |
| Xx7 |
|
Posted: May 20th, 2012, 11:00 pm
|
|
Replies: 2
Views: 24
|
Beautiful!
Code: ^!u::
XL := Excel_Get()
XL.Application.DisplayAlerts := False
XL.Activesheet.Delete
XL.Application.DisplayAlerts := True
return |
|
|
Forum: Support Topic: Excel - Delete Active Worksheet |
| Xx7 |
|
Posted: May 20th, 2012, 8:32 pm
|
|
Replies: 2
Views: 24
|
The code below works, but if theres data in the worksheet a pop-up asks if I want to delete the sheet. How can I delete the sheet without the pop-up?
Code: ^!u::
XL := Excel_Get()
XL.Activesheet.Delete
return |
|
|
Forum: Support Topic: Get file path for files on desktop |
| Xx7 |
|
Posted: May 13th, 2012, 6:00 pm
|
|
Replies: 2
Views: 29
|
Thanks... I got it going and put a ClipWait in there
Code: ^+RButton::
clipboard =
SendInput, ^c
ClipWait
MsgBox, % Clipboard
return |
|
|
Forum: Support Topic: Get file path for files on desktop |
| Xx7 |
|
Posted: May 13th, 2012, 5:00 pm
|
|
Replies: 2
Views: 29
|
Would like to get the file path of files on my desktop by putting the cursor on them and running a script. This doesn't work for some reason:
Code: ^+RButton::
clipboard =
SendInput, ^c
Clipboard = %clipboard%
MsgBox, % Clipboard
return |
|
|
Forum: Support Topic: Excel VBA translation after initial call |
| Xx7 |
|
Posted: May 11th, 2012, 12:38 am
|
|
Replies: 4
Views: 71
|
| How do I translate the VBA code that comes after the intial call... see "BLUE": Workbooks.Open [color=#0000FF]FileName:="Array.xls", ReadOnly:=True[/color] Sheets("ABC").Select Sheets("ABC").Copy [color=#0000FF]After:=Sheets(3)[/color] |
|
|
Forum: Support Topic: USB is sometimes "F" drive or "E" drive |
| Xx7 |
|
Posted: May 9th, 2012, 8:39 pm
|
|
Replies: 10
Views: 294
|
|
|
Forum: Support Topic: Run script on user input after first 2 characters |
| Xx7 |
|
Posted: May 9th, 2012, 8:28 pm
|
|
Replies: 3
Views: 52
|
Great, thank you!  I was unaware of Input. |
|
|
Forum: Support Topic: Run script on user input after first 2 characters |
| Xx7 |
|
Posted: May 9th, 2012, 12:21 am
|
|
Replies: 3
Views: 52
|
| I want to type "jj" then some random string and press enter. The random string will be displayed in a msgbox. Eg. jj12345 will display 12345 jjabc will display abc This script does exactly what I want, however I don't want an inputbox. :*:jj:: InputBox, SearchTerm,,,, 300, 130 if (SearchTe... |
|
|
Forum: Custom Topic: Store Google Chrome bookmarks in Excel (AHK_L) |
| Xx7 |
|
Posted: May 8th, 2012, 6:50 pm
|
|
Replies: 6
Views: 836
|
| Well, it is very strange information as to store Google chrome into excel sheet. I am very much curious to know more on this. It allows me to create a searchable database to retrieve bookmarks by using advancedfilters and macros in Excel. Therefore, I can have 1000's of bookmarks and search them in... |
|
|
Forum: Support Topic: Excel: Get path of current & prior open workbooks |
| Xx7 |
|
Posted: May 6th, 2012, 5:26 am
|
|
Replies: 5
Views: 126
|
Thanks Alpha Bravo! I used a different method to accomplish the task.
Please have a look at my script: ---> Excel Hyperlinker |
|
|
| Sort by: |
Login
Register
FAQ
Search