VBA Question

[aush]

Hi All,

I'm trying to implement a set of commands which is being sent to IBM PCOM through data set from Excel.
I've already compiled the necessary commands but stuck on how to trigger F12 to save the data.

I've tried the below with no success ..

Call TKeys(session1, "[F12]")
Call TKeys(session1, "{F12}")

SendKeys {F12}
SendKeys {F12}

Appreciate if anyone can point me in the right direction, thanks.


Thanks, Aaron

 

[saboh12617]

Hello,

I think you are looking for this command Application.GetSaveAsFilename method (Excel) | Microsoft Learn

Just add it to your macro and it should display the dialog box when reached. You can give it optional parameters for the file type.
Like this

ThisWorkbook.SaveAs Application.GetSaveAsFilename

 

[Logit]

SendKeys "{F12}"